How to print some fixed rows on top of each pages?
D David McRitchie Jan 25, 2004 #2 Hi Toto, File, Page Setup, Sheets, Rows to Repeat at top: $1:$1 for more information on freezing rows for display and printing with particular columns or rows repeated see http://www.mvps.org/dmcritchie/excel/freeze.htm --
Hi Toto, File, Page Setup, Sheets, Rows to Repeat at top: $1:$1 for more information on freezing rows for display and printing with particular columns or rows repeated see http://www.mvps.org/dmcritchie/excel/freeze.htm --
B Bob Phillips Jan 25, 2004 #3 Go to File>Page Setup and on the Sheet tab, set the Rows to repeat at top, such as $1:$2 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Go to File>Page Setup and on the Sheet tab, set the Rows to repeat at top, such as $1:$2 -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
