Intermittent problem with "Rows to repeat at the top" under Page Setup
I work on my Excel spreadsheets in Page Layout view and have being using the "rows to repeat at the top" command in Page Setup for years without any problem when using Office 2011. After switching to Office 365, I am now having intermittent problems with the cell reference on page 2 of a spreadsheet if I have used the "rows to repeat at the top" command. When I click on a cell on page 2, the cell reference intermittently goes out of sync with the cursor by the number of rows that I have repeated at the top of the page. Very frustrating. I have taken this up with Microsoft Support, and they have confirmed that this seems to be a problem in Office 2016 and Office 2019, but not Office 2011.
Could you please fix this bug as it is very frustrating!
Thanks for your feedback. This issue has been fixed and will be available in the next monthly release of Excel for Mac. Once you have version 16.30 or greater, you should no longer have this issue. If you want to get the fix sooner, you can opt into the Insiders program and choose the Fast updates. To do so, just go to Help > Check for Updates. Then check the box to join the Office Insider Program and choose Office Insider Fast. Then press Check for Updates and install version 16.30×.