Share via

Print titles area in Excel is grayed out

Anonymous
2023-10-24T21:52:17+00:00

Every so often when trying to enter rows to repeat at top of every page, the page setup/print titles/rows to repeat at top and columns to repeat at left are both grayed out. Can't get it to allow titles of any kind.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

17 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-06-24T10:08:52+00:00

    Hi All - I just had the same experience. And same, same, couldn't find the answer.

    BUT eventually I found a completely different Excel file open, with a dialogue prompting me to save it. Once I did that save, then the row titles became editable on the other s/sheet I was interested in.

    Could be just happy coincidence. But once I cleared that other dialogue, I was OK to set the rows titles.

    10+ people found this answer helpful.
    0 comments
  2. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-10-24T21:57:20+00:00

    You should be able to set these from the Page Layout tab of the ribbon.

    It is not possible to do so when you click Page Setup after selecting File > Print.

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2024-11-15T22:50:09+00:00

    THANK YOU!!! That was the culprit and driving me b-a-n-a-n-a-s! :)

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2024-06-26T03:19:20+00:00

    Thanks! That worked perfectly. Appreciate the help.

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2023-10-24T22:18:01+00:00

    I had not selected print yet. And the page layout tab was as below. I have since had to print and shrink the whole document to fit to one page so I would have the row titles. Why does this happen? it doesn't happen every time I open a spreadsheet, but I can't figure out the common issue.

    0 comments