Although we are marking this as completed, it’s an ongoing effort to improve performance in Excel. Significant improvements have been made in both Page Layout View and Normal view, and since it’s an ongoing effort, we expect more in the future. If you have specific issues with performance, it would be helpful if you submit feedback to the Excel team by using the Send-a-Frown button in the top-right corner of the app.
Frozen rows and columns scroll into the unfrozen area at the top and left when scrolling to the top row or leftmost column. After scrolling into the frozen cells, clicking the the top or leftmost unfrozen cell selects multiple cells equal to the number of frozen rows and columns.39 votes
This is fixed as of 15.20, which was released in May (so if you haven’t updated, please do!)
We know that this broke in 15.19.1, and we’ve got a fix that will be in 15.20.
Sorry for the inconvenience. It should be that once you scroll down, so that the duplicated rows are no longer shown, they won’t be shown again.
When using excel on a mac in full screen view the arrows that appear to the very left of the first tab name do not work. This is super frustrating when you are using workbooks with many tabs that overflow the width of the screen. Switching through them with keyboard shortcuts to get to a tab that is off screen is very tedious.
This functionality returns in non-full screen views.47 votes
This update is very long overdue, but this issue has been fixed as of late last year.
When I import a text file and want to select all of the columns as text the horizontal scroll feature does not work and I can only change what ever I can see in the window to text. I use the feature on a weekly basis. This makes excel 2016 unusable for me on a Mac.75 votes
Hi everyone – thanks for your persistence with this suggestion. This issue has been fixed. To get the fix, please install the latest updates by going to Help > Check for Updates. If you have version 16.41 or greater, you should be able to scroll horizontally in the table shown in the text import wizard.
Steve K [MS Excel]
Is it possible to use a simple key combination to switch tabs? Like <CMD><TAB> to switch between windows... Maybe make it an option to change the <CTRL><TAB> function which switches through worksheets. When I'm in a single worksheet I often want to <TAB> through the tabs!5 votes
You can switch between sheets today by either using Ctrl + Page Down or Option + Right Arrow to go to the next sheet, or reverse directions to go to the previous. Our full list of shortcuts in Excel for Mac 2016 is here: https://support.office.com/en-us/article/Keyboard-shortcuts-in-Excel-2016-for-Mac-acf5419e-1f87-444d-962f-4e951a658ccd
Hope this helps!
When double clicking in a worksheet tab and editing its name etc.., after pressing enter the user cannon press Control or Alt +Pg up or down and move to the next sheet. The user MUST click in the worksheet 1st before using the keyboard shortcut to navigate to the next worksheet. This is not correct behavior and seems to be a bug. Does not work like this in Office 2011 or the Windows version. Can you please fix? Thank you.1 vote
This issue has been fixed in a recent update. Please update to the latest version.
I am so used to being able to alt+tab between two windows in the same Excel workbook. This should be available in Office for Mac 3655 votes
In Excel for Mac, you can press CMD+` (the key above TAB on a US keyboard) to switch between windows in Excel.
- Don't see your idea?