| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header Row Repeated on Each Page
I want the Header Row (Row #1) to automatically appear at the top of each page.
I have done this before, but can't remember how I did it. Hope you can help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header Row Repeated on Each Page
Go into Page Setup. Select the Sheet tab. In Rows to Repeat at top, enter
$1:$1 Tyro "Musette" wrote in message ... I want the Header Row (Row #1) to automatically appear at the top of each page. I have done this before, but can't remember how I did it. Hope you can help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header Row Repeated on Each Page
Tyro:
Thank you for your help and quick response. It worked perfectly! "Tyro" wrote: Go into Page Setup. Select the Sheet tab. In Rows to Repeat at top, enter $1:$1 Tyro "Musette" wrote in message ... I want the Header Row (Row #1) to automatically appear at the top of each page. I have done this before, but can't remember how I did it. Hope you can help. |
| 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 header only on first page of multi page excel file | Excel Discussion (Misc queries) | |||
| Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
| header and footer on every page except the first page? | Excel Discussion (Misc queries) | |||
| changing page numbers in repeated header | Excel Discussion (Misc queries) | |||
Hybrid Mode
