Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
"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.... |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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.... |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
"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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |