| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
same heading on each page while printing
When I have a large document in Excel which I want to print....I only get the
heading on the first page... However, I would like the heading to show up on each page...is that possible? So it concerns the first row... Thansk in advance |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
same heading on each page while printing
Page Layout / click on the arrow in the lower right hand corner of the Page
Setup list of options / Page Setup window will launch / Sheet tab / single left hand click in the Rows to repeat at top: box / then click in the rows that you wish to repeat at the top (for example rows 1 and 2) / this will put $1:$2 in the Rows ro repeat at top: box / single left hand click on OK. This should give you what you want. Steve. "mariekek5" wrote: When I have a large document in Excel which I want to print....I only get the heading on the first page... However, I would like the heading to show up on each page...is that possible? So it concerns the first row... Thansk in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Heading on each page | Excel Discussion (Misc queries) | |||
| Printing a heading on each new page when printing | Excel Discussion (Misc queries) | |||
| Page Heading | Excel Discussion (Misc queries) | |||
| Heading at the top of page... | Excel Worksheet Functions | |||
| print heading row on every page | Excel Discussion (Misc queries) | |||
Linear Mode
