Jan's Working with Numbers

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-Firstname-Lastname.xlsx (saved in previous lesson)

Edit Header: Page Layout View

1. Open  trips9-Firstname-Lastname.xlsx  from your Class disk in the  excel project2  folder to Sheet1.
2. Switch to Page Layout view.
3. Edit the Right section to read  Excel Project 3 
   
4. Use Save As to save the file to the a new folder,  excel project3 , on your Class disk as  trips9-titleformatted-Firstname-Lastname.xlsx .
   Create the folder excel project3 if it does not yet exist.
   How to handle a full disk

---

Format Cell: Dialog

1. Select cell A1 =  World Travel Inc. 
2. From the ribbon on the Home tab in the Cells tab group, click the button Format and then Format Cells....
   The Format Cells dialog appears, open to the Font tab. It has 6 tabs for formatting options.
3. Click on each tab to see what you can use it for. So many choices! Especially notice the choices on the tabs Number and Alignment.
    
4. Return to the Font tab.
   Cell A1 is still selected.  

5. Make the following choices:
    
   Font = Matura MT Script Capitals
   Font Size = 24
   Font Color = Blue, Accent 1, Darker 25%

   

6. Click on OK to close the dialog and apply your choices.
   

---

Format Cell: Ribbon

Some of the most common formatting choices are also available on the ribbon. Handy! 

1. Select cell A2 =  Anniversary Specials 
2. On the  Home tab in the Font tab group, use the buttons to format this cell as:
    
   Font = Arial;
   Font Size = 18;
   Font style = Bold;
   Font Color = Blue, Accent 1, Darker 25%

---

Format Cell: Merge and Center

1. Select the range A1:E2, which is first two rows across the width of your data.
    
2. On the Home tab click  the Merge and Center button.
   You get a warning! 

    When cells are merged, all data is lost except what is in the upper left cell. This is very different from the way Word handles merged table cells, where 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.
   

3. Click Cancel.

   Problem: 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.
   

4. Select just A1:E1 this time - all on the same row.
5.  Click on  the Merge and Center button again. The text in A1 is centered across the selection.
   
6. Select range A2:E2.
7. Click the Merge and Center button.  The text in A2 is centered over the selected range.
8. Save.
     [trips9-titleformatted-Firstname-Lastname.xlsx]
   

---

Unmerge Cells: Ribbon & Dialog

If you change your mind or have not selected the right cells to merge, you can unmerge in two ways - the ribbon and the Format Cells dialog. This section is just practice with no changes to save.

Unmerge with Ribbon:

1. Click on the title, World Travel Inc., in the merged cell on row 1.
   The merged cell is selected.  
2. Click the arrow beside the Merge and Center button. 
   The menu opens.
   
3. Click on Unmerge Cells.
   The text moves back to A1 but it is still centered in that single cell. That makes part of the title hang out of view to the left.
   
4. Click in cell A3 to deselect.
   
5. Undo.

Unmerge with Dialog:

1. Click on the subtitle in row 2.
   
2. On the Home tab, click the dialog box launcher for the Alignment tab group.
   The Format Cells dialog opens to the Alignment tab.
   
3. Uncheck the box by Merge Cells.
    
4. Click on OK to close the dialog.
   The subtitle is back into A2 but still centered.
   
5. Undo.

 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.