- In Windows Excell you can search for data in one tab or in all tabs in the workbook.
In Mac Excel the functionality exists to search for the positioned to tab only.
To search all, user will have to select each tab and search on that tab.
If you have 255 tabs, you have to repeat that search 255 times.
That is an inconsistent functionality.
- In Windows Excel, user can utilise keyboard to toggle between several open workbooks. In Mac excel, user cannot do same.
Thanks for posting this suggestion. This request is already supported in Excel for Mac. You can search the workbook and if you click Next/Previous in the search field, it will take you to the sheets where the search result is found. You can also go to Edit > Find > Find…, and choose the option to find “Within” the workbook or the sheet.
With regard to switching between open workbooks, you can press CMD + ` (the key above the TAB key on US keyboard). This switches between windows in Excel.
Steve K [Microsoft Excel]
- Don't see your idea?