Heading row

[Leon]

How can I make the heading row show at the top of page each time I page
downward

 

[Andy]

Put the cursor into a cell on the row you want to hold on the screen then,
from the menu,
Window > Freeze Panes

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"

 

[Norman Harker]

Hi Leon!

If your heading is in row 1

Select A2
Window > Freeze Panes

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Joe Kelb]

For Printing:
File > Page Setup > click on the Sheet tab.
In the "rows to repeat at top" field you type in what you want to be
seen. (As an example, if your header row is columns A through G you
would type in a1:g1)
Then click OK



For Viewing in the application:

click on the row beneath the header. Click on the Window menu. Click
Freeze Panes.

 

[Leon]

Excellent, thanks a bunch