| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Use rows 1-3 for header on all 13 pages
My spreadsheet has 15 columns of numbers and is quite long. I want the first
3 rows (my header) to print at the top of each page. Is there a way to do this. Thanks, SJL |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use rows 1-3 for header on all 13 pages
FilePage SetupSheet tab, Rows to repeat at top
-- Kind regards, Niek Otten "sjl" wrote in message ... | My spreadsheet has 15 columns of numbers and is quite long. I want the first | 3 rows (my header) to print at the top of each page. Is there a way to do | this. | | Thanks, | SJL |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use rows 1-3 for header on all 13 pages
I have done this but I'm not quite sure what to add in the space. What ever I
put it states "reference invalid" ... what am I doing wrong??? "Niek Otten" wrote: FilePage SetupSheet tab, Rows to repeat at top -- Kind regards, Niek Otten "sjl" wrote in message ... | My spreadsheet has 15 columns of numbers and is quite long. I want the first | 3 rows (my header) to print at the top of each page. Is there a way to do | this. | | Thanks, | SJL |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Use rows 1-3 for header on all 13 pages
The easiest way is to click in the space, then to select whichever row(s)
you wish to be repeated on each page. -- David Biddulph "STEC" wrote in message ... I have done this but I'm not quite sure what to add in the space. What ever I put it states "reference invalid" ... what am I doing wrong??? "Niek Otten" wrote: FilePage SetupSheet tab, Rows to repeat at top -- Kind regards, Niek Otten "sjl" wrote in message ... | My spreadsheet has 15 columns of numbers and is quite long. I want the first | 3 rows (my header) to print at the top of each page. Is there a way to do | this. | | Thanks, | SJL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print area selection slows excel, formula for hiding rows?? | Excel Discussion (Misc queries) | |||
| repeat rows pattern through pages | Excel Discussion (Misc queries) | |||
| Print few rows with many colums so that rows wrap on printed pages | Excel Discussion (Misc queries) | |||
| Automatically inserting rows | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Linear Mode
