| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you set up a page break with a repeating top row
I have a work sheet with alot of columns with each having a different header
subject. Each column has hundreds of rows of data. How do I set a page break where the headers for the columns will appear on each page. Also if I delete a row it will automaticly bump the next row up without effecting the column headers. Please help. Thank you |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you set up a page break with a repeating top row
Tools -- Page Setup -- Sheet tab
There's a section in there for repeat rows at top. Select the rows you want to be on each page in that box. - Search "bossyone99" wrote: I have a work sheet with alot of columns with each having a different header subject. Each column has hundreds of rows of data. How do I set a page break where the headers for the columns will appear on each page. Also if I delete a row it will automaticly bump the next row up without effecting the column headers. Please help. Thank you |
| 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) | |||
| Can't delete a page break | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
| content does not stay in page break | Excel Worksheet Functions | |||
Hybrid Mode
