Printing: rows repeating across the top

  • Thread starter Thread starter IlliniEric
  • Start date Start date
I

IlliniEric

I have a worksheet that is very wide and cannot fit on one page. I want rows
1-3 to repeat on each page. I know how to go into Page Setup and set it up
to do it, but it only works when the worksheet is long as opposed to wide (in
other words, when the page breaks are horizontal as opposed to vertical). Is
there any way to do this, or is this just not programmed into Excel?
 
you can set rows to repeat at top and cols to repeat at left and they do
show on every print page. it not matter if sheet is wide or not. but remeber
that the rows that repeat at the ones in same colums as the print rg that
appear on that page. so it the print rg that appear in a page is Q20:Z50
then the roes that repeat are like Q1:Z3. if nothing there you see nothing.

|I have a worksheet that is very wide and cannot fit on one page. I want
rows
| 1-3 to repeat on each page. I know how to go into Page Setup and set it
up
| to do it, but it only works when the worksheet is long as opposed to wide
(in
| other words, when the page breaks are horizontal as opposed to vertical).
Is
| there any way to do this, or is this just not programmed into Excel?
 
Back
Top