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:

Gridline

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.

 

Keep going...

 

Exam 77-882: Microsoft Excel 2010 Core

3. Formatting Cells and Worksheets

3.5. Manipulate Page Setup options for worksheets: Print Titles