This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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]
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.
I believe it's not a bug, but some configuration, because in 2016 the option is also disabled.
Yes, you are right, seems configuration wasn't correct, because through one screen the option is enabled and if we go with other options i.e. page setup, the same is disabled. Hope MS will fix this in next update.
I'm checking here in the documentation if have something, as soon I have news, will post it here.
I'm checking here in the documentation if have something, as soon I have news, will post it here.
OK, thank you for the help.
Looking forward to get this resolved in subsequent updates in Excel 365
Hi Hassan!
I'm Jen, and I'd be happy to help you out with this issue.
The Print Title options including Rows to repeat is always disabled in the Print Preview's page setup. Display the spreadsheet in Normal view, go to Page Layout Tab and click on Print Titles.
I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.
Best Regards!
Jen :)
Hi Hassan!
I'm Jen, and I'd be happy to help you out with this issue.
The Print Title options including Rows to repeat is always disabled in the Print Preview's page setup. Display the spreadsheet in Normal view, go to Page Layout Tab and click on Print Titles.
I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.
Best Regards!
Jen :)
Hi Jen!
Thank you for the response.
In the print setup, these should not be disabled, I guess it is a configurational error as one of the respondent also pointed that in Excel 2016, same configurational mistake / error was there, I have written to Microsoft via email and hopefully this configurational error will be fixed in the next updates in Excel 365.