L
Leon
How can I make the heading row show at the top of page each time I page
downward
downward
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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"
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"
N
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.
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.
J
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.
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.
L
Leon
Excellent, thanks a bunch