| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Header Insanity
Hi,
I have a multiple-paged (35 pages) sheet displayed landscape on 11x17 paper. On page 1, the first three rows contain information about each subsequent page, but I don't want them displayed on the subsequent pages. When I am editing the file, they only appear on the first page (which is all I want). However, when I switch to print preview or actually print the file out, the first three rows are repeated on each page in the sheet. I have no headers (or custom) headers set. Does anyone know what the problem is? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header Insanity
Not a problem. A selection someone made. Go to File, page setup, Sheet tab.
Delete rows to repeat at top Excel 2007, Page Layout, Page Setup, Dialog box, select Sheet tab. Delete rows to repeat at top Tyro wrote in message ... Hi, I have a multiple-paged (35 pages) sheet displayed landscape on 11x17 paper. On page 1, the first three rows contain information about each subsequent page, but I don't want them displayed on the subsequent pages. When I am editing the file, they only appear on the first page (which is all I want). However, when I switch to print preview or actually print the file out, the first three rows are repeated on each page in the sheet. I have no headers (or custom) headers set. Does anyone know what the problem is? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Header Insanity
On that sheet select File - Page Setup - Sheet | and blank out "Rows to
Repeat at Top" -- HTH... Jim Thomlinson " wrote: Hi, I have a multiple-paged (35 pages) sheet displayed landscape on 11x17 paper. On page 1, the first three rows contain information about each subsequent page, but I don't want them displayed on the subsequent pages. When I am editing the file, they only appear on the first page (which is all I want). However, when I switch to print preview or actually print the file out, the first three rows are repeated on each page in the sheet. I have no headers (or custom) headers set. Does anyone know what the problem is? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
| Get Intersection value given column header and row header | Excel Discussion (Misc queries) | |||
| Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
| Excel: custom header - is it possible to paste into header? | Excel Worksheet Functions | |||
| how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
Hybrid Mode
