Discover more about your data
The new Ideas button looks for patterns in your data, and uses them to create intelligent, personalized, suggestions.
See formulas in living color
Just like in other versions of Excel, formulas are now color-coded so that you can differentiate between arguments.
Reference cells like a champ
Writing a formula? Reference another sheet's cell by clicking the sheet, then the cell.
Additional features
| Insert PivotTable |
| Insert and edit shape |
| Insert connectors |
| Insert image |
| Data validation |
| Duplicate sheet |
| Color sheet tab |
| View who's locking my file |
| Open workbooks in edit mode by default (when the file is on SharePoint Online) |
| Reference a cell in another sheet |
| Insert or delete a table row or column |
| Insert copied cells |
| Cut, copy, and paste plain text across workbooks |
| Display named ranges |
| Colored references in formulas |
| F4 keyboard shortcut: cycle through absolute and relative references in forumlas |
Previous releases
| Freeze panes |
| Conditional formatting |
| Increase and decrease font size |
| Set the width or height of columns and rows |
| |
| Additional border types |
| Strikethough text |
| Increase or decrease indent |
| Shapes rotation |
| Render grouped opjects |
Coming soon
| Cut, copy, paste an image, shape, chart, or equation |
| Insert a Pivot Chart from a PivotTable |
Get started
Templates to get you started (link to Get started with Excel for the web topic)
Tutorials (link to Get started with Excel for the web topic)
For developers (link to Get started with Excel for the web topic)
Send us feedback
Suggest a feature (link to new Give Excel for the web feedback topic)
Report an issue (link to new Give Excel for the web feedback topic)
Blogs
Excel Online: News & Updates, Summer 2018
by Kasper Langmann on 08-07-18
The Excel for the web interface has come a long way, making it easier for users to see, find, and work with their data. Here are the ways that you can customize the interface but couldn't back in 2016.
Read more
Insert Pivot Tables in Excel Online
by Gregory Appel on 03-04-18
Inserting new Pivot Tables in Excel for the web is now possible! This long awaited feature is now available to Excel for the web.
Read more
Introducing Forms for Excel
by Olaf Hubel on 09-22-17
Forms for Excel, powered by Microsoft Forms, has replaced Excel Survey. This update comes with a modern experience to make it simple and easy to collect information from users.
Read more
More resources
-
Ask an expert in the Excel Tech Community
-
Get support in the Answers community
-
Suggest a new feature or improvement on Excel User Voice
-
Find out what the Excel team is up to at the Excel Blog.
-
See what's new in all the Office Online apps at What's new in Office Online.
No comments:
Post a Comment