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 make you look back to the top of the worksheet, or even type your headings where you guess the screen transitions occur, you can have Excel print your column and row headings at the top of every page. By printing the column and row headings on each page, you will save time, improve accuracy, and reduce frustration when dealing with large worksheets.
On your worksheet, select the row headings you want to repeat.
On your worksheet, select the column headings you want to repeat.
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.
For more information about frozen panes, see "View Multiple Parts of a Worksheet by Freezing Panes".
18.221.163.13