| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
"Print Titles" in Excel is disabled. How to enable it?
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? |
|
#2
|
|||
|
|||
|
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" wrote in message ... 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? |
|
#3
|
|||
|
|||
|
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" wrote in message ... 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Print Titles" in Excel is disabled. How to enable it?
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" wrote in message ... 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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Print Titles" in Excel is disabled. How to enable it?
According to the 2003 to 2007 translation guide at
http://office.microsoft.com/en-us/he...CH102457041033, there's a Page Layout tab in 2007, and an arrow at the bottom of that. -- David Biddulph "Jake M.D." wrote in message ... 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" wrote in message ... 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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Print Titles" in Excel is disabled. How to enable it?
"David Biddulph" wrote: According to the 2003 to 2007 translation guide at http://office.microsoft.com/en-us/he...CH102457041033, there's a Page Layout tab in 2007, and an arrow at the bottom of that. -- David Biddulph "Jake M.D." wrote in message ... 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" wrote in message ... 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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"Print Titles" in Excel is disabled. How to enable it?
Wow. Grrr! thanks, I never would have known!
"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" wrote in message ... 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I print graphs poster size (4 - 8 1/2 x 11) in Excel 2002? | Charts and Charting in Excel | |||
| wanna use print preview in excel 2002 without printer connection | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
| EXCEL - Cannot print borders in color(s) I have selected | Excel Discussion (Misc queries) | |||
Hybrid Mode
