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.
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.
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!
- Don't see your idea?