Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing: rows repeating across the top
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing: rows repeating across the top
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. "IlliniEric" wrote in message ... |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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing repeating columns on the same page | Excel Discussion (Misc queries) | |||
How can I print repeating rows on every page when printing? | Excel Discussion (Misc queries) | |||
suppress printing a repeating value in a column | Excel Discussion (Misc queries) | |||
Printing: repeating columns on left and RIGHT | Excel Discussion (Misc queries) | |||
Printing: repeating columns on left and RIGHT | Excel Discussion (Misc queries) |