How can I make the heading row show at the top of page each time I page downward
L Leon Jan 22, 2004 #1 How can I make the heading row show at the top of page each time I page downward
A Andy Jan 22, 2004 #2 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"
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"
N Norman Harker Jan 22, 2004 #3 Hi Leon! If your heading is in row 1 Select A2 Window > Freeze Panes -- Regards Norman Harker MVP (Excel) Sydney, Australia [email protected] Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
Hi Leon! If your heading is in row 1 Select A2 Window > Freeze Panes -- Regards Norman Harker MVP (Excel) Sydney, Australia [email protected] Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes.
