Excel - Print Headers on every page

 Excel - Print Headers on every page

There is a "shortcut" to print the headers on every page.

See following table, have 100 lines.

Select the first row (or two first rows, or even columns...)

And in the "Name Box" area/cell type “Print_Titles” (Without quotes, the image is in Portuguese).

This depends on the language of the program, see bellow.

Now when print (or print preview) you see the headers in all pages.

Please check in your Excel language the window bellow, settings to print, you should enter in the "Name Box" the exact name, with underscores separating the words.

You can use the "Name Box" to navigate in the spreadsheet, if enter "E50" you go to cell "E50"... and there are other uses for the "Name Box".