Print area, Rows to repeat at top, columns to repeat at left [Unable to Select in Excel 365]

Anonymous
2021-11-06T18:06:36+00:00

Hi All,

Is this a bug or what in Excel 365. Print area, Rows to repeat at top, columns to repeat at left [Unable to Select in Excel 365]

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 No comments
{count} votes

11 answers

Sort by: Most helpful
  1. Anonymous
    2021-11-06T19:53:06+00:00

    Hi

    My name is André. I am an independent consultant.

    Just for testing, can you define your printable area using this method?

    https://support.microsoft.com/en-us/office/set-...

    Answer here so I can continue helping you.

    André.

    0 comments No comments
  2. Anonymous
    2021-11-06T20:08:47+00:00

    Hi

    My name is André. I am an independent consultant.

    Just for testing, can you define your printable area using this method?

    https://support.microsoft.com/en-us/office/set-...

    Answer here so I can continue helping you.

    André.

    Hi, Thanks for your response. After selecting print area E4:I14, still cannot able to select rows and columns to repeat. Screenshot below.

    Thanks,

    Excel Lover

    0 comments No comments
  3. Anonymous
    2021-11-06T20:39:39+00:00

    And when you click directly from the page layout tab. Print Titles. can you use the option?

    0 comments No comments
  4. Anonymous
    2021-11-06T21:02:38+00:00

    And when you click directly from the page layout tab. Print Titles. can you use the option?
    Image

    Yes dear, I can then use this option if uses "print titles", it is enabled from there but disabled on other screen as shared screenshot above. It seems a bug, hopefully MS will resolve it soon.

    Regards,

    Excel Lover

    0 comments No comments
  5. Anonymous
    2021-11-06T21:05:17+00:00

    I believe it's not a bug, but some configuration, because in 2016 the option is also disabled.

    0 comments No comments