| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Rows After Page Breaks
I am working on a sheet now for business leads. I set up the page layout for
letter size and I would like to have rows 1 & 2 to print on every page. How can I make this happen without having to cut and paste on every page manually? Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Rows After Page Breaks
Maybe you could try this (check to see if it breaks your page breaks):
File|Page setup|Sheet tab Type 1:2 in the "Rows to repeat at top" box RJ Swain wrote: I am working on a sheet now for business leads. I set up the page layout for letter size and I would like to have rows 1 & 2 to print on every page. How can I make this happen without having to cut and paste on every page manually? Thank you -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Rows After Page Breaks
Under page set up, go to the sheet tab. Click inside Rows to repeat at the
top and then select the two rows you want repeated and then click ok. Do a print preview to make sure it will print the rows you want. "RJ Swain" wrote: I am working on a sheet now for business leads. I set up the page layout for letter size and I would like to have rows 1 & 2 to print on every page. How can I make this happen without having to cut and paste on every page manually? Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: how to insert page breaks between all the rows at once? | Excel Discussion (Misc queries) | |||
| How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
| Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
| Ignore page breaks for hidden rows | Excel Discussion (Misc queries) | |||
| How to copy page breaks within an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
