Excel MSO 2010 - Excel

Joined
Sep 9, 2015
Messages
3
Reaction score
1
When trying to print a selected area, the "rows to repeat at top" are greyed out (as are the other two adjacent options.
Have read the "cures" for Excel 2003 and 2008, (leave print preview and use file/print/page setup) but these do not work for my 2010 version.
Can anyone help please?
 
I've heard of this error before, it seems to be a bug in Excel. Did you get to the page set-up through the print options? If so, try the button on the ribbon instead - select the Page Layout tab, the click on the Print Titles button in the Page Layout group. Hopefully it should allow you to select the option you're after.

Let me know how you get on :)
 
Hi Becky.
Thank you.
I have tried accessing throught the print options and the file menu, but neither worked.
Your method works perfect. Thank you again.
 
Hi Becky.
Thank you.
I have tried accessing throught the print options and the file menu, but neither worked.
Your method works perfect. Thank you again.

Excellent, thanks for letting me know :)
 
Back
Top