3.4 Preparing to Print
Learning Objectives
- Locate and fix formatting consistency errors.
- Apply new formatting techniques.
- Use Print Titles to repeat rows and columns on each page of a multiple page worksheet.
- Control where page breaks occur in a multiple page worksheet.
In this section, we will review a worksheet for formatting consistency, as well as learn two new formatting techniques. This worksheet currently prints on four pages, so we will learn new page setup options to control how these pages print. A new data file will be used for this section.
Reviewing Formatting for Consistency
Open the “CH3-Gradebook and Parks” workbook if it isn’t already open.
Click on the “Park Size” sheet tab within your “CH3-Gradebook and Parks” workbook .
You have been given a spreadsheet with data about the national parks in the western United States. Your coworker formatted the workbook and has asked you to review it for consistency. You also need to prepare it for printing. Figure 3.26 shows how the second page of the finished worksheet will appear in Print Preview.
Reviewing Formatting for Inconsistencies
The first thing you are going to do is review the worksheet for formatting inconsistencies.
- Scroll through the worksheet and locate the following formatting errors:
- The formatting of the Utah label does not match the other states.
- The Year Established values for Hawaii are not center aligned like the other years.
- The cells for the Nevada data should have the same green fill color as the other alternating states.
- The number of digits after the decimal place for the Size values is inconsistent. Also, these values should be formatted with Comma style to make them easier to read.
- To fix these errors, complete the following steps:
- Merge & Center A34:A38. Change the font size to 16 and apply Bold format.
- Center align C28:C29.
- Apply the green fill color to A31:E31 (be sure to match the green fill color of the other states).
- Select E4:E43 and apply Comma Style. Use Increase Decimal and/or Decrease Decimal until one digit appears after the decimal place for all values.
- While you’re fixing errors, proofread the sheet and correct any typos.
- Finally, let’s add color to the two sheet tabs. The use of colored tabs assists in navigating between sheet tabs.
- Right-click the “Park Size” sheet tab ( Mac users hold down Ctrl key and click the sheet tab)
- Point to Tab Color and choose a “blue” color.
- Now right-click the “Grades” sheet tab, point to Tab Color and choose an “orange” color. That’s it!
Fine-tuning Formatting
Now that you have fixed the inconsistencies in the formatting, you decide to apply some formatting techniques to make the worksheet look even better. You are going to start by vertically aligning the names of the states within the cells.
- Select A4:A43 (the cells with the state labels).
- Click the Home tab on the ribbon.
- In the Alignment group, click the Middle Align button (see Figure 3.26). Notice that the names of the