Header Insanity

Z

zac.whirley

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?
 
T

Tyro

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
 
J

Jim Thomlinson

On that sheet select File -> Page Setup -> Sheet | and blank out "Rows to
Repeat at Top"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing header rows.. 5
Trouble with Page Setup to Print 11x17 2
setting the area to show up in preview 3
Printing 1
Single Header 6
Printing very large spreadsheet 1
Header 1
Print Fit To Not Working 1

Top