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) |