Figure 3.26 Completed National Parks worksheet Reviewing Formatting for Inconsistencies Figure 3.26 shows how the second page of the finished worksheet will appear in Print Preview.

You also need to prepare it for printing. Your coworker formatted the workbook and has asked you to review it for consistency. You have been given a spreadsheet with data about the national parks in the western United States. Open the “CH3-Gradebook and Parks” workbook if it isn’t already open.Ĭlick on the “Park Size” sheet tab within your “CH3-Gradebook and Parks” workbook. A new data file will be used for this section.

This worksheet currently prints on four pages, so we will learn new page setup options to control how these pages print. In this section, we will review a worksheet for formatting consistency, as well as learn two new formatting techniques.

Control where page breaks occur in a multiple page worksheet.

Use Print Titles to repeat rows and columns on each page of a multiple page worksheet.

Locate and fix formatting consistency errors.

Alignment dialog box launcher