| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to have frozen panes print on every printed page
I have a sheet that has a title and header cells as 2 rows frozen at the
top. I would like those two rows to appear on every printed page. Is this possible? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to have frozen panes print on every printed page
One way:
File/Page Setup/Sheet, Rows to repeat at top: $1:$2 In article , "Edward" wrote: I have a sheet that has a title and header cells as 2 rows frozen at the top. I would like those two rows to appear on every printed page. Is this possible? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to have frozen panes print on every printed page
"Edward" wrote in message
... I have a sheet that has a title and header cells as 2 rows frozen at the top. I would like those two rows to appear on every printed page. Is this possible? What version of Excel? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to have frozen panes print on every printed page
"JE McGimpsey" wrote in message
... One way: File/Page Setup/Sheet, Rows to repeat at top: $1:$2 That's why I asked what version of Excel - it's in a different place in 2007.... |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to have frozen panes print on every printed page
Thanks!
It's '97 by the way but I have it now "Gordon" wrote in message ... "JE McGimpsey" wrote in message ... One way: File/Page Setup/Sheet, Rows to repeat at top: $1:$2 That's why I asked what version of Excel - it's in a different place in 2007.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| frozen panes print top of each page | New Users to Excel | |||
| How to print row one on each printed page | Excel Discussion (Misc queries) | |||
| How can I print frozen panes to appear above print selection in Ex | Excel Discussion (Misc queries) | |||
| How do I print frozen panes on each page as a header? | Excel Discussion (Misc queries) | |||
| Saving as web page for workbook with frozen panes | Excel Discussion (Misc queries) | |||
![Edward[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
