In Excel your formatting choices are on the ribbon but also are grouped neatly in a single dialog with six tabs. There are so many choices! It will take you a while to become familiar with all of them.
In this section you will apply text formatting. Later you will work with number formats, alignment, borders, and fills.
Step-by-Step: Apply Formatting
|What you will learn:|| to edit an existing header in Page Layout View
to apply text formatting with dialog
to apply text formatting with ribbon
to merge cells and center cells
to unmerge cell
Start with: trips9-Lastname-Firstname.xlsx (saved in previous lesson)
Open trips9-Lastname-Firstname.xlsx from your Class disk in the excel project2 folder to Sheet1.
Experiment: Format Cells dialog
Click on each tab to see what you can use it for.
Open the drop lists to see what the choices are.
Especially notice the choices on the tabs Number and Alignment.
Altogether there are a LOT of choices!
When you have inspected all of the choices on all of the tabs...
Make the following choices:
Font = Matura MT Script Capitals
Font Size = 24
Font Color = Blue, Accent 1, Darker 25%
Some of the most common formatting choices are also available on the ribbon. Handy!
Merging can lose data!
Only the data in the upper left cell is kept when cells are merged. This is very different from the way Word handles merged table cells. In Word each cell's contents becomes a separate paragraph in the merged cell.
At least Excel will warn you that you are about to lose data.
Text in A2 vanishes
If you clicked on OK in the message box, then all of the selected cells merge into a single cell but only the text from the first cell is kept.
Solution: Undo immediately.
If you change your mind or have not selected the right cells to merge, you can unmerge in two ways, using the ribbon or the Format Cells dialog. This section is just practice with no changes to save.
Add button to
Quick Access Toolbar: If you find yourself doing a lot of unmerging or
having to take out centering, you could customize your Quick Access Toolbar to include a Merge Cells button (without the centering) and an Unmerge Cells button.