Short version:
Excel for the Web Usability Enhancements: Microsoft continue to improve Excel for the Web with a number of recent improvements. If you are still avoiding the web version due to performance, it might be time to give it another go.
Details:
Microsoft continue to improve Excel for the Web with a number of recent improvements. If you are still avoiding the web version due to performance, it might be time to give it another go.
When using Excel for the web, the following scenarios have been optimised for usability and navigational experiences:
- Easier worksheet navigation: When opening an Excel workbook with multiple worksheets, you can now jump directly to the worksheet you want. Simply click on the new All Sheets button in the lower left corner and then select the desired worksheet
- Multiple range selection: You can now select multiple ranges which are not adjacent to each other, and fill colour (or copy-and paste). Holding the Ctrl key now enables selecting multiple ranges
- Zoom in/out: Excel for the web now supports multiple ways to zoom in/out. Zoom in for a close-up view of your data or zoom out for an overview of the worksheet. New Zoom methods include: Pinch/stretch to zoom on touch screen or trackpad, Ctrl + mouse wheel, Ctrl Alt +/- key, Click the +/- button or selecting a predefined zoom level from 25% to 200% in the bottom right corner of the screen
- Excel keyboard shortcuts by default: Excel for the web now supports keyboard shortcuts by default (e.g. Keyboard shortcuts like Alt, Ctrl-1, Ctrl-Shift-A, etc., now go to Excel for the web and not the browser). To see the list of Excel keyboard shortcuts, click on the Help tab and select Keyboard Shortcuts. Note: The Override browser shortcuts setting is checked by default.
- Version history: You can now view and restore previous versions of Excel files using version history. You can track activities in the workbook by others, collaborate with others and revert to a previous version as needed.
- Regional settings: You can now change regional settings in Excel for the web to set their date/time, number, and currency formats.
Availability:
Available now.
Links:
Supporting Microsoft blog post: https://techcommunity.microsoft.com/t5/excel-blog/what-s-new-in-excel-for-the-web/ba-p/2163998
