"Print Titles" in Excel is disabled. How to enable it? 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              Ravi 7/18/2005 9:07 PM PST   Question   The "Print Titles" while doing Print preview for an Excel worksheet(s) is coming as disabled. I am unable to select row(s) and/or column(s) to repeat on every page while printing. What should be done to enable this?     Was this post helpful to you?         Reply |   Top           Niek Otten 7/19/2005 12:33 AM PST   Answer   That option is always disabled in the print preview. Use the Page Setup command in rhe File menu. -- Kind regards, Niek Otten Microsoft MVP - Excel "Ravi" <Ravi@discussions.microsoft.com> wrote in message news:8916AA2A-87A3-4FB1-A7C8-79B2B94F2DD2@microsoft.com... > The "Print Titles" while doing Print preview for an Excel worksheet(s) is > coming as disabled. I am unable to select row(s) and/or column(s) to > repeat > on every page while printing. What should be done to enable this?     Was this post helpful to you?         Reply |   Top           Ravi 7/19/2005 9:14 AM PST   Thanks, It worked - quite simple. Regards, Ravi "Niek Otten" wrote: > That option is always disabled in the print preview. > Use the Page Setup command in rhe File menu. > > -- > Kind regards, > > Niek Otten > > Microsoft MVP - Excel > > "Ravi" <Ravi@discussions.microsoft.com> wrote in message > news:8916AA2A-87A3-4FB1-A7C8-79B2B94F2DD2@microsoft.com... > > The "Print Titles" while doing Print preview for an Excel worksheet(s) is > > coming as disabled. I am unable to select row(s) and/or column(s) to > > repeat > > on every page while printing. What should be done to enable this? > > >     Was this post helpful to you?         Reply |   Top           Jake M.D. 5/9/2008 7:49 AM PST   What about in Office 2007? I click on the "Office Button" but there is not a page set-up option. :( "Niek Otten" wrote: > That option is always disabled in the print preview. > Use the Page Setup command in rhe File menu. > > -- > Kind regards, > > Niek Otten > > Microsoft MVP - Excel > > "Ravi" <Ravi@discussions.microsoft.com> wrote in message > news:8916AA2A-87A3-4FB1-A7C8-79B2B94F2DD2@microsoft.com... > > The "Print Titles" while doing Print preview for an Excel worksheet(s) is > > coming as disabled. I am unable to select row(s) and/or column(s) to > > repeat > > on every page while printing. What should be done to enable this? > > >     Was this post helpful to you?         Reply |   Top           David Biddulph 5/9/2008 9:00 AM PST   According to the 2003 to 2007 translation guide at http://office.microsoft.com/en-us/help/HA101491511033.aspx?pid=CH102457041033, there's a Page Layout tab in 2007, and an arrow at the bottom of that. -- David Biddulph "Jake M.D." <JakeMD@discussions.microsoft.com> wrote in message news:394F15F0-55C0-4925-A171-460ED4788548@microsoft.com... > What about in Office 2007? I click on the "Office Button" but there is not > a > page set-up option. :( > > "Niek Otten" wrote: > >> That option is always disabled in the print preview. >> Use the Page Setup command in rhe File menu. >> >> -- >> Kind regards, >> >> Niek Otten >> >> Microsoft MVP - Excel >> >> "Ravi" <Ravi@discussions.microsoft.com> wrote in message >> news:8916AA2A-87A3-4FB1-A7C8-79B2B94F2DD2@microsoft.com... >> > The "Print Titles" while doing Print preview for an Excel worksheet(s) >> > is >> > coming as disabled. I am unable to select row(s) and/or column(s) to >> > repeat >> > on every page while printing. What should be done to enable this? >> >> >>     Was this post helpful to you?         Reply |   Top           lindaesser 1/12/2009 8:49 AM PST   "David Biddulph" wrote: > According to the 2003 to 2007 translation guide at > http://office.microsoft.com/en-us/help/HA101491511033.aspx?pid=CH102457041033, > there's a Page Layout tab in 2007, and an arrow at the bottom of that. > -- > David Biddulph > > "Jake M.D." <JakeMD@discussions.microsoft.com> wrote in message > news:394F15F0-55C0-4925-A171-460ED4788548@microsoft.com... > > What about in Office 2007? I click on the "Office Button" but there is not > > a > > page set-up option. :( > > > > "Niek Otten" wrote: > > > >> That option is always disabled in the print preview. > >> Use the Page Setup command in rhe File menu. > >> > >> -- > >> Kind regards, > >> > >> Niek Otten > >> > >> Microsoft MVP - Excel > >> > >> "Ravi" <Ravi@discussions.microsoft.com> wrote in message > >> news:8916AA2A-87A3-4FB1-A7C8-79B2B94F2DD2@microsoft.com... > >> > The "Print Titles" while doing Print preview for an Excel worksheet(s) > >> > is > >> > coming as disabled. I am unable to select row(s) and/or column(s) to > >> > repeat > >> > on every page while printing. What should be done to enable this? > >> > >> > >> > > >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies