Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
How do you set computer to print "freeze panes" on succeeding pages in excell?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
if you mean how to repeat rows and columns each page:
go to page setup, sheet Tab and than you can input wich row to repeat on top and wich column to repeat at left Andrea "kdhelm" wrote: How do you set computer to print "freeze panes" on succeeding pages in excell? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
Thank you Andrea, what does it mean when it says I do not have a valid
reference. I want to print row 1 and row 2 what do I enter in the box and how should it read? Thanks "Andrea" wrote: if you mean how to repeat rows and columns each page: go to page setup, sheet Tab and than you can input wich row to repeat on top and wich column to repeat at left Andrea "kdhelm" wrote: How do you set computer to print "freeze panes" on succeeding pages in excell? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
Enter
1:2 Then <OK When you go back to: <File <SetUp <Sheet tab, You'll see: $1:$2 -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "kdhelm" wrote in message ... Thank you Andrea, what does it mean when it says I do not have a valid reference. I want to print row 1 and row 2 what do I enter in the box and how should it read? Thanks "Andrea" wrote: if you mean how to repeat rows and columns each page: go to page setup, sheet Tab and than you can input wich row to repeat on top and wich column to repeat at left Andrea "kdhelm" wrote: How do you set computer to print "freeze panes" on succeeding pages in excell? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
in the box you need to enter $1:$2. The easy way to do this is to click in
the row to repeat box and use the mouse and clicl on the rows you want to repeat. -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "kdhelm" wrote: Thank you Andrea, what does it mean when it says I do not have a valid reference. I want to print row 1 and row 2 what do I enter in the box and how should it read? Thanks "Andrea" wrote: if you mean how to repeat rows and columns each page: go to page setup, sheet Tab and than you can input wich row to repeat on top and wich column to repeat at left Andrea "kdhelm" wrote: How do you set computer to print "freeze panes" on succeeding pages in excell? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
Hi, how do you do that in Excel 2007. The freeze pane is always gray and
there is no page setup menu function. I am baffled. Alain "Andrea" wrote: if you mean how to repeat rows and columns each page: go to page setup, sheet Tab and than you can input wich row to repeat on top and wich column to repeat at left Andrea "kdhelm" wrote: How do you set computer to print "freeze panes" on succeeding pages in excell? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
See Ron de Bruin's site for where to find the menu commands in 2007
http://www.rondebruin.nl/0307commands.htm Rows to repeat at top should be under FilePage Layout Note: you don't use the "Freeze Panes" for printing. Gord Dibben MS Excel MVP On Mon, 2 Jun 2008 18:49:00 -0700, Alain59 wrote: Hi, how do you do that in Excel 2007. The freeze pane is always gray and there is no page setup menu function. I am baffled. Alain "Andrea" wrote: if you mean how to repeat rows and columns each page: go to page setup, sheet Tab and than you can input wich row to repeat on top and wich column to repeat at left Andrea "kdhelm" wrote: How do you set computer to print "freeze panes" on succeeding pages in excell? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
"kdhelm" wrote: How do you set computer to print "freeze panes" on succeeding pages in excell? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print "freeze panes" on succeeding pages?
Im looking for a way to do this when I save the excel file as a web page. In
Office 2000, I could save it with interactivity or something and when viewed as a webpage, the freeze panes would work.... after upgrading to Office 2007, can't get that to work anymore. I would assume it's still possible? TIA! Adam "John" wrote: in the box you need to enter $1:$2. The easy way to do this is to click in the row to repeat box and use the mouse and clicl on the rows you want to repeat. -- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "kdhelm" wrote: Thank you Andrea, what does it mean when it says I do not have a valid reference. I want to print row 1 and row 2 what do I enter in the box and how should it read? Thanks "Andrea" wrote: if you mean how to repeat rows and columns each page: go to page setup, sheet Tab and than you can input wich row to repeat on top and wich column to repeat at left Andrea "kdhelm" wrote: How do you set computer to print "freeze panes" on succeeding pages in excell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"freeze panes" in excel '97? | New Users to Excel | |||
Excel loses "Freeze Panes" setting | Excel Discussion (Misc queries) | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
print the "Feeze Panes" to each page | Setting up and Configuration of Excel | |||
How do I freeze panes in different pages on the same worksheet? | Excel Discussion (Misc queries) |