Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.3 Format Worksheets and Workbooks: Modify Page Setup (Print Titles)

Page Layout -> Page Setup ->Print Titles

Page Setup: Print Titles

You can select which Titles you wish to print on your spreadsheet.

 

7. Try This: Print Titles

Go to Page Layout -> Page Setup.

Click on Print Titles.

 

What Do You See? The Page Setup window will open. You will be prompted to select which Row you would like to repeat at the top of each page in your print out.

 

What Else Do You See? You can select if you would like to Print the following:

Gridlines

Black and White

Draft quality

Row and column headings.

 

Try This, Too: Select the Rows to Repeat

Go to Rows to repeat at top.

Select Row 1.

Excel will enter $1:$1 in the blank.

 

Click OK.
Keep going...

graphic1
 
graphic2