Repeating headings

A

ace_stace

Is it at all possible, to have a table with column headings/titles that
can be repeated on further pages if the table takes up more than one.
So that the headings will appear on the top of each page without having
to insert rows to copy and paste the headings in:)

would appreciate any help

even if it is just to confirm that there is no function that will do
this
 
S

Scoops

Hi ace_stace

If you mean when printing then:

File>Page Setup, Sheet tab, input or select the "Rows to repeat at
top".

If you mean when viewing the worksheet then:

Activate the cell below and to the right of the cells you want fixed
and click Windows> Freeze Panes.

Regards

Steve
 
A

ace_stace

yes that makes sense

but the option to input specific cells or highlight they is greyed out
and i cant access it for some reason
 
S

Scoops

Hi ace_stace

Sorry, I've not come across an instance where I can't input or select
the rows I want, perhaps someone else has...

Regards

Steve
 
Top