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?

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?

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?