Displaying header row

[amcrowe]

Sounds simple, but how do I display a row of column headers all the time I scroll down and examine rows too far down for the header row to "normally" be displayed?

There is a way to print each new page with the column headers, but I need it for screen display.

 

[Brian from Maui]

If your header row ts in A1:G1 for example, click on B1 go to Windows/Freeze Pane

 

[Corni]

If you need to print the column header for each page you print, you have to set up page:

File/Page Setup/Sheet tab/Select Rows to repeat at top.