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...