560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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 at the top of the worksheet.
Now apply the following formatting to the column titles row:
Change the font and colour of the titles on row 4
Increase the row height of row 4 and make it top aligned
Here's what the row should look like before you change the vertical alignment:
Row 4 before the alignment changes
And here's what it should look like after this:
Row 4 after the alignment changes.
Make the following additionalc 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.
You can now see all of the entries in the Description column.
We haven't finished yet!
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:
You don't have to choose yellow shading!
Your finished example should look something like this:
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 Catalog Formatting answer.
You can find other training resources for the subject of this exercise here:
25 Aytoun Street