| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do I make the first three rows repeat on top of every page?
I am using Excel 2002 and have documents with 9 colums wide and 100 to 200
rows long. I am printing in landscape mode on letter size paper. I want the first three rows of the very first page to repeat at the top of each new page that gets printed. So every time there is a page break it will re-insert the top three rows before continuing with the row sequence? Ok,,, so I am a newbe :o) Thanks for any help. StardustDave. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I make the first three rows repeat on top of every page?
Hi Dave
Have a look at Page Setup/Sheet/Rows to repeat box HTH Michael "StardustDave" wrote: I am using Excel 2002 and have documents with 9 colums wide and 100 to 200 rows long. I am printing in landscape mode on letter size paper. I want the first three rows of the very first page to repeat at the top of each new page that gets printed. So every time there is a page break it will re-insert the top three rows before continuing with the row sequence? Ok,,, so I am a newbe :o) Thanks for any help. StardustDave. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do I make the first three rows repeat on top of every page
"Michael M" wrote: Hi Dave Have a look at Page Setup/Sheet/Rows to repeat box HTH Michael "StardustDave" wrote: I am using Excel 2002 and have documents with 9 colums wide and 100 to 200 rows long. I am printing in landscape mode on letter size paper. I want the first three rows of the very first page to repeat at the top of each new page that gets printed. So every time there is a page break it will re-insert the top three rows before continuing with the row sequence? Ok,,, so I am a newbe :o) Thanks for any help. StardustDave. Worked perfect! Thanks Michael. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I enter rows to repeat on sheet tab? | Excel Discussion (Misc queries) | |||
| repeat rows for add'l pages for tabs on a multi-tab worksheet | Excel Worksheet Functions | |||
| Page Numbers | Excel Discussion (Misc queries) | |||
| how i make a pgm in excel for copying all the rows to a new file . | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
Linear Mode
