Thread: Header Insanity
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default 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?