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


--
ace_stace
------------------------------------------------------------------------
ace_stace's Profile: http://www.excelforum.com/member.php...o&userid=33263
View this thread: http://www.excelforum.com/showthread...hreadid=530858

Hi ace_stace

If you mean when printing then:

FilePage 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

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


--
ace_stace
------------------------------------------------------------------------
ace_stace's Profile: http://www.excelforum.com/member.php...o&userid=33263
View this thread: http://www.excelforum.com/showthread...hreadid=530858

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

What option are you talking about? Page Setup or Freeze Pane?

--
Regards,
Fred


"ace_stace" wrote in
message ...

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


--
ace_stace
------------------------------------------------------------------------
ace_stace's Profile:
http://www.excelforum.com/member.php...o&userid=33263
View this thread: http://www.excelforum.com/showthread...hreadid=530858