Try
Page Layout ribbon tab|Page Setup group
This is a discussion on Excel 2010 Page Setup greyed out within the Excel Questions forums, part of the Question Forums category; I have a printer installed and Ready. I have tried changing to all different views (Normal, Page Layout, Page Break) ...
I have a printer installed and Ready.
I have tried changing to all different views (Normal, Page Layout, Page Break) before going to File > Print > Page Setup.
I have tried selecting one cell (and hitting esc a few times) and I have tried highlighting the entire sheet.
The worksheet isn't protected nor is it shared.
Every time I go to the Page Setup, Sheet tab, the following are all greyed out:
Print Area, Rows to Repeat at Top, Columns to Repeat at Left.
All other functionality in the Page Setup is unaffected.
Any idea of what I'm missing to be able to allow it to repeat rows at the top?
Try
Page Layout ribbon tab|Page Setup group
Hope this helps, good luck.
Peter
- Read the Posting Guidelines, Forum Rules & FAQs
- Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste
- If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
Thanks you!
Bookmarks