Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Row as Header
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Row as Header
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. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Row as Header
And if you're referring to the screen:
Select cell A2 WindowFreeze Panes -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave" wrote in message ... | 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
Get Intersection value given column header and row header | Excel Discussion (Misc queries) | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
Excel: custom header - is it possible to paste into header? | Excel Worksheet Functions | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) |