Having a Row Appear as the First Row on Every Page

G

guilbj2

I have a large grid type sheet with a row about 60 columns wide with al
of the column headings in it. I'd like this row to apear as the firs
one on every page. I haven't been able to get it to work as a heade
so I'm looking for another solution. To date I've just copied an
pasted it but that means a lot of work to adjust page breaks etc. a
the report changes. If anyone knows how to get a row to appear as th
first one on every page, I'd really appreciate the advice
 
A

Andy B

Hi

Go to File / Page Setup and the Sheet tab gives you the option of 'rows to
repeat at top'. Just enter $1:$1

Andy.
 
G

George Nicholson

File>PageSetup>Sheet "Rows to Repeat At Top"

(Note: this setting is only available through File>PageSetup, not through
PageSetup in PrintPreview.)
 
Top