What's New in Excel for the web

Published 03-02-2021 12:22 PM 4,926 Views

Delighting our customers with faster, smoother, and richer experiences in Excel for the web is an uncompromised goal across our Excel team.  Recently we shared how we’ve continued to improve performance to make opening workbooks, navigating a workbook, and other interactions faster and smoother for you.  Today we’re introducing several additional features to help you better navigate and manipulate your Excel files in a browser:

  • Easier worksheet navigation
  • Multiple range selection
  • Zoom in/out
  • Excel keyboard shortcuts by default
  • Version history
  • Regional settings

 

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 your worksheet.

 

cuong_16-1614714305315.png

 

 

Multiple range selection

You can now select multiple ranges that are not adjacent to each other – and fill color or copy-and paste.  Hold the Ctrl key while selecting as many ranges as you want.  The example below shows how you can select two non-adjacent columns and apply conditional formatting.

 

discon.selection.gif

 

 

Excel keyboard shortcuts by default

Excel for the web now supports your keyboard shortcuts by default.  Keyboard shortcuts like Alt, Ctrl-1, Ctrl-Shift-A, etc., go to Excel and not your browser.  To see the list of Excel keyboard shortcuts, click on the Help tab and select Keyboard Shortcuts – Override browser shortcuts is checked by default.

 

cuong_18-1614714305516.png

 

 

Zoom in/out

Excel for the web now supports many ways to zoom in/out.  Zoom in to get a close-up view of your data or zoom out for an overview look of your worksheet:

  • Pinch/stretch to zoom on touch screen or trackpad
  • Ctrl + mouse wheel
  • Ctrl Alt +/- key
  • Click the +/- button
  • Select a predefined zoom level from 25% to 200% in the bottom right corner

 

cuong_19-1614714305517.png

 

 

  • Coming soon: Zoom button in the menu ribbon under the View tab!

 

cuong_20-1614714305523.png

 

 

Version history

You can now view and restore previous versions of your Excel file using version history.  Track activities in the workbook by others collaborating with you and revert to a previous version if needed.  Select File > Info > Version History

 

version-history2.gif

 

 

Regional settings

You can now change region settings in Excel for the web to set your date/time, number, and currency formats in a couple ways:

  • Select File > Options > Regional Format Settings, or

 

regional-settings.gif

 

 

  • Select the Number Format drop down list > More Number Formats…

 

cuong_23-1614714309884.jpeg

 

 

These are just some of the latest improvements, many more are coming soon!

 

Your feedback helps shape the future of Excel for the web.  Please let us know how you like a particular feature and what we can improve upon—send us a smile or frown.

 

Want to know more about Excel for the web?  See What's new in Excel for the web and subscribe to our Excel Blog to get the latest updates.  Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on Facebook and Twitter.

 

 

 

8 Comments

When we think about the complexities present even in the most basic web sites, and then we look at Excel for Web, we realize that we are facing a great masterpiece of Programming!

Step by step Excel Online becomes more and more powerful

Contributor

amazing job!

Trusted Contributor

It is nice to see that in Excel for the web the simplicity of the excel complexity appears more and more.


panta rhei ("everything flows")

 

Well done .. keep it up 

Regular Visitor

Great news! Does this also apply to Excel in MS Teams?

Occasional Contributor

Excel’s evolution is simply amazing!

Microsoft

@Marco Henrichs , all these web enhancements are available in MS Teams. 

Occasional Visitor

@Danielle_Rifinski 

Our Company is moving from GSuite to Office365 one item that is coming up is unable to copy large amount of rows our clients get the below error.  Does MS have a roadmap to resolve the below item?

 

When copying data into Excel Online, it has a limitation size of 100k. Also, if the Excel workbook contains too many resources

Co-Authors
Version history
Last update:
‎Mar 03 2021 10:45 AM
Updated by: