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?
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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 :)
 
Joined
Sep 9, 2015
Messages
3
Reaction score
1
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.
 

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top