File-> Print

Print Preview

So, what does it look like when Excel repeats the titles at the top of each page? You can use Print Preview to proof your work.

 

Try This, Too: Print Preview

Go to File->Print.

 

What Do You See? The new Backstage view has a very detailed Print Preview. On the left you can choose which printer and edit the printer Settings.

 

On the right side of the Backstage view is the Print Preview. You can use the navigation buttons at the bottom to turn the pages and see if the Titles are repeated.

 

So far, so good. Click on the Page Layout Ribbon and keep going, please...

 

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.5. Manipulate Page Setup options for worksheets: Print Preview