Header Insanity

  • Thread starter Thread starter zac.whirley
  • Start date Start date
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?
 
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
 
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 very large spreadsheet 1
Access Sorting and grouping using multiple tables 0
Access Page Header with merge field 0
Change Header on Multiple Sheets without Changing Other Formatting 1
Insert automatic page numbering into a cell, not a header or foote 1
setting the area to show up in preview 3
printing a header in Excel 2
Printing header rows.. 5

Back
Top