Excel 2010 Page Setup greyed out

[henway]

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?

 

[Peter_SSs]

Try

Page Layout ribbon tab|Page Setup group

 

[henway]

Thanks you!

 

[DataAnalyst]

I had this problem with a report I've been doing every month for more than a year. Each month I make a new file and a big pivot table. I always use the Page Layout ribbon and Page Setup for this. When I went to add the rows to repeat setting on the current report it was greyed. This had never happened before with this Excel on this computer.

I combed through the Excel options without finding the setting, then opened some other Excel files and none of them were greyed. I looked again at the settings for my pivot and they weren't greyed! Apparently opening other excel files fixed this glitch. Entered my settings quick before this happens again!

 

[SysEngineer]

I had this problem with a report I've been doing every month for more than a year. Each month I make a new file and a big pivot table. I always use the Page Layout ribbon and Page Setup for this. When I went to add the rows to repeat setting on the current report it was greyed. This had never happened before with this Excel on this computer.

I combed through the Excel options without finding the setting, then opened some other Excel files and none of them were greyed. I looked again at the settings for my pivot and they weren't greyed! Apparently opening other excel files fixed this glitch. Entered my settings quick before this happens again!

I have had this problem (but only on some tabs) and spent hours trying to figure out why these options were grayed out. Spent hours searching the web, and only found the obvious solutions. I just closed the file and re-opened it, and the problem went away. I am using Excel 2013, but I have also seen this on 2010. An obvious bug in Excel.

 

[GBinVent]

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?

-------------------------------------------------------------------------
Excel 2010 - If more than one cell is selected on a worksheet other than the one you are trying to set the print area on, the Print Area icon will be greyed out. Un-select multiple cells is all other sheets.