Repeat Row is greyed out

Copper Contributor

I am unable to repeat row in the page set up area. I have checked I do not have multiple worksheets selected, my printers are all linked correctly and I am not editing another cell. I noticed this on a new spreadsheet however I have since noticed that all my spreadsheets have this section greyed out including spreadsheets which I have already inserted repeat rows.

4 Replies

@MissTracyB32 

Make sure that you open the Page Setup dialog from the Page Layout tab of the ribbon, and not from File > Print.

Thanks @Hans Vogelaar 

I have tried multiple ways. Via the page layout section, via the command shortcut and via the file page. Any other thoughts. 

 

@MissTracyB32 

Repair Office?

Thank you. Working now. I think it must have been a Microsoft problem as all worksheets lost the function. All worksheets now have the function back.