Microsoft Office Tutorials and References
In Depth Information
Printing row and column headings on each page
Printing row and column headings on each page
When you print a worksheet in which the data doesn’t fit on a
single screen, you might have trouble remembering which data
is stored in which column. Rather than having to look back to
the top of the worksheet—or even type your headings where
you guess that the screen transitions occur—you can have Excel
print your column and row headings at the top and left of every
page. By printing the column and row headings on each page,
you save time, improve comprehension, and reduce frustration
when dealing with large worksheets.
Identify the rows and columns to repeat
1 Click the Page Layout tab.
2 Click Print Titles.
3 Click the Sheet tab.
4 Click in the Rows To Repeat At Top box.
5 On your worksheet, select the row headings that you want to
repeat.
6 Click the Columns To Repeat At Left box.
7 On your worksheet, select the column headings that you want to
repeat.
8 Click OK.
1
2
6
3
4
7
5
TIP Repeating rows and columns on every page is useful when
your worksheet contains frozen panes and you want to have the
frozen panes appear on every page of the printout, just as they appear
on the screen.
8
SEE ALSo For more information about frozen panes, see “View
multiple parts of a worksheet by freezing panes” on page 93.
Search JabSto ::




Custom Search