Same heading on every page

[Rae]

Hi all,
Basically a small problem here. Was wondering if it is possible to se
my exel spreadsheet to have the same table heading for every pag
automatically instead of having to cut and paste all the time. Fo
example, a column of "serial number" may drag over many pages so ho
can make the header "Serial number" of that column appear automaticall
everytime the numbers continue to a subsequent page? Thank you!

Rgds,
Ra

 

[Guest]

Hi

Go to File / Page Setup / Sheet tab and use the 'Rows to repeat at top'
option.

 

[Rae]

Hi,
cool, just what i wanted. Thanks!

Rgds,
Ra

 

[Guest]

Thanks for the feedback!