Print "freeze panes" on succeeding pages? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              kdhelm 4/7/2007 1:14 PM PST   Question   How do you set computer to print "freeze panes" on succeeding pages in excell?     Was this post helpful to you?         Reply |   Top           Andrea 4/7/2007 1:36 PM PST   Answer   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?     Was this post helpful to you?         Reply |   Top           kdhelm 4/7/2007 1:55 PM PST   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?     Was this post helpful to you?         Reply |   Top           John 4/7/2007 2:02 PM PST   Answer   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?     Was this post helpful to you?         Reply |   Top           OneCosmicGuy 10/9/2008 4:37 PM PST   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?     Was this post helpful to you?         Reply |   Top           RagDyeR 4/7/2007 2:08 PM PST   Answer   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" <kdhelm@discussions.microsoft.com> wrote in message news:DC41DFB5-99DE-41AD-A06A-D258E3E7E801@microsoft.com... 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?     Was this post helpful to you?         Reply |   Top           Alain59 6/2/2008 6:48 PM PST   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?     Was this post helpful to you?         Reply |   Top           Gord Dibben 6/3/2008 8:05 AM PST   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 File>Page 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 <Alain59@discussions.microsoft.com> 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?     Was this post helpful to you?         Reply |   Top           melon 6/28/2008 3:36 AM PST   "kdhelm" wrote: > How do you set computer to print "freeze panes" on succeeding pages in excell?     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies