Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep heading so it prints on multiple pages
I want to print multiple pages using the same heading that is at the
beginning of a column without having to insert rows with the same heading at a page break. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep heading so it prints on multiple pages
Go to File | Page Setup | Sheet tab and you will see that you can
specify Rows to Repeat at Top. Ensure that your print area excludes these rows, otherwise they will be printed twice on the first page. Hope this helps. Pete de2137 wrote: I want to print multiple pages using the same heading that is at the beginning of a column without having to insert rows with the same heading at a page break. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep heading so it prints on multiple pages
File, Page Setup and click on the Sheet tab. Click in the box 'Rows to repeat
at top' and select your row(s) on the worksheet. -- Hope this helps, MarkN "de2137" wrote: I want to print multiple pages using the same heading that is at the beginning of a column without having to insert rows with the same heading at a page break. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep heading so it prints on multiple pages
FilePage SetupSheet"Rows to repeat at top"
Enter 1:1 or point to the row(s) you want repeated. Gord Dibben MS Excel MVP On Mon, 16 Oct 2006 16:20:02 -0700, de2137 wrote: I want to print multiple pages using the same heading that is at the beginning of a column without having to insert rows with the same heading at a page break. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep heading so it prints on multiple pages
Hi Pete,
Why the print area should exclude the rows to repeat at top? It will not be printed twice even if it is included. Jaleel "Pete_UK" wrote: Go to File | Page Setup | Sheet tab and you will see that you can specify Rows to Repeat at Top. Ensure that your print area excludes these rows, otherwise they will be printed twice on the first page. Hope this helps. Pete de2137 wrote: I want to print multiple pages using the same heading that is at the beginning of a column without having to insert rows with the same heading at a page break. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep heading so it prints on multiple pages
Go to File select "Page setup" select the "Sheet" tab and then click the "row
to repeat at top" text box and then select your heading row, and click on text box againg and then click print. "de2137" wrote: I want to print multiple pages using the same heading that is at the beginning of a column without having to insert rows with the same heading at a page break. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Hiden Pages | Excel Discussion (Misc queries) | |||
Column heading at 45 degrees | Excel Discussion (Misc queries) | |||
when printing multiple sheets, first prints single side rest doub. | Setting up and Configuration of Excel | |||
compling info from multiple pages onto one page? | Excel Worksheet Functions | |||
combining multiple pages from Web automatically | Excel Discussion (Misc queries) |