Excel | Formatting worksheets exercise | Making Formatting Changes - Catalog

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Software ==> Excel  (151 exercises)
Version ==> Excel 2016 and later
Topic ==> Formatting worksheets  (9 exercises)
Level ==> Relatively easy
Subject ==> Excel training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Open the workbook contained in the folder shown above.

Make the following formatting changes:

  • Insert a few extra blank rows at the top and then type in the new title shown below
  • Format the font, size and colour of the title and add underlining
The new title

The new title at the top of the worksheet

  • Change the font and colour of the titles on row 4
  • Increase the row height of row 4 and make it top aligned
Row 4 before the alignment changes

Row 4 before the alignment changes

After the alignment changes

Row 4 after the alignment changes


  • Make everything in the 'Call ID' and the 'Date' columns centre aligned
  • Select the whole of column D (click on the column letter) and add text wrap so that you can see all of the longer text entries
The column is too narrow Word Wrap solves the problem
  • Click in the middle of the worksheet and press CTRL + A to select it all, then add borderlines everywhere (apart from on the title at the top)
  • Add light yellow shading to the titles on row 4 so that they look similar to this:
New shading on titles

You don't have to choose yellow shading


Your finished example should look something like this:

Finished formatted example

Your workbook doesn't have to look exactly the same as this!

Use File - Save As... to save the file in your work folder with this new name:

Formatted Catalog Orders

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post