Excel Row as Header

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kat - 02 Apr 2008 17:51 GMT

I am making a table and the top row has all the headings for each column. I
want this row of headings to appear on each page, since the table extends to
3 pages and users will be adding rows frequently. Is this possible, and if
so, how?

thank you

Reply to this Message

Dave - 02 Apr 2008 19:34 GMT

Hi Kat,
If you are refering to printed pages, then:
File > Page Setup
Then select the 'Sheet' tab and enter your heading row where it says
'Rows to repeat at top'.
I use XL2000. Other versions might be slightly different.
Regards - Dave.

Reply to this Message

Niek Otten - 02 Apr 2008 20:42 GMT

And if you're referring to the screen:

Select cell A2
Window>Freeze Panes

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Kat,
| If you are refering to printed pages, then:
[quoted text clipped - 3 lines]
| I use XL2000. Other versions might be slightly different.
| Regards - Dave.

Reply to this Message

Rate this thread: