| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Repeating the Row Headers on each page
I have a spreadsheet with several pages on it. I want to repeat the rows
headers that came on the first page on each page. How to do that? Please help!! -- TS |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Repeating the Row Headers on each page
TS
Assuming "pages" means printed pages......... FilePage SetupSheetPrint Titles. Rows to repeat at top and Columns to repeat at left. Assuming "pages" means worksheets............ Select first sheet then right-click and "select all sheets" Enter your headers/titles in row 1 on active sheet. These will be replicated on each sheet. DO NOT FORGET to "ungroup" the sheets when done. Gord Dibben Excel MVP On Tue, 6 Dec 2005 11:48:03 -0800, "TS" wrote: I have a spreadsheet with several pages on it. I want to repeat the rows headers that came on the first page on each page. How to do that? Please help!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Page Numbering | Excel Discussion (Misc queries) | |||
| Page Numbers | Excel Discussion (Misc queries) | |||
| 1st page only Headers & Footers | Excel Discussion (Misc queries) | |||
| Repeating Rows and Columns on each page of print out | Excel Discussion (Misc queries) | |||
| If I change page margins headers don't line up??? | Excel Discussion (Misc queries) | |||
Hybrid Mode
