Blog Post

Excel Blog
2 MIN READ

What's New in Excel for the web (March 2022)

Avital Nevo's avatar
Avital Nevo
Icon for Microsoft rankMicrosoft
Mar 14, 2022

Excel for the web is constantly changing and adapting to better meet your needs by listening to your feedback and putting this into action. The Excel team is excited to announce the next set of features coming to Excel for the web, which include the following improvements that will help elevate the quality and effectiveness of your work.

  • New Conditional formatting experience  
  • Function library
  • New filter menu 
  • Insert slicer 
  • Insert online pictures  

New Conditional formatting experience 

The new Conditional Formatting capabilities allow an easier experience for you to manage, edit, and create formatting rules in Excel for the web. 


For more information: New Conditional Formatting experience in Excel for the web - Microsoft Tech Community 

 

Function library 

Formulas are essential for skilled excel users. Many users rely on the function library to help find and identify the right function to use. With this improvement, we bring Excel’s familiar formula library to you in Excel for the web.  

Function library

 

New filter menu 

Filtering data is now easier and more convenient with the new filter menu. 

New filter menu

 

Insert slicer 

Create slicers for PivotTables in Excel for the web to filter data the way you want.  

  • Filter data in a PivotTable with ease 
  • Visually identify the filtered items in a PivotTable 
  • Create interactive summaries with slicers connected to one or multiple PivotTables  

How to insert slicer

Insert slicer dropdown menu

 

Insert online pictures 

Insert Stock Images and Pictures from Bing search on Excel for the Web  

You can now find high-quality images from Microsoft Stock images and add them to your worksheet. Use the categories on the Stock images window to filter out the images as you need. Stock Images also provides you with Cutout People and Stickers on Excel for the Web. You can also search Stock Images, Cutout people, and Stickers using keywords in the search bar. You can select multiple images across all categories and insert them onto the Excel worksheet.  

How to insert Microsoft stock images

Search Microsoft stock images

 

Bing Pictures search is now available on Excel for the Web. Search for a picture on the web using keywords or use the prepopulated picture categories. You can select multiple pictures and insert them onto the Excel worksheet.  

Insert Bing pictures on Excel for the web

Search Bing images

 

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.  You can also submit new ideas or vote for other ideas via Microsoft Feedback.

 

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 Twitter.  

 

Thank you!  

 

 

Updated Mar 14, 2022
Version 1.0

3 Comments

  • Awesome improvements! Shame the last example in the video is erroneous. It probably should have been =NOT(F2) got to be careful with relative references in Conditional Formatting. 

  • Same basic issue

    There doesn't seem to be any way to delete things from the ribbon.

    In addition these mysterious changes deleted things I used or moved them into

    tabs that now require extra "work" to get them.  Example: Bold, italic, underline, fill color are now hidden in FONT. There must be a way to have a ribbon CUSTOM for 

    users requiring some basic stuff

    Jim the wine guy

  • Bill__B_-1935's avatar
    Bill__B_-1935
    Copper Contributor

    This group of ? improvements was applied to an EXCel spreadsheet last week and I tried to get pass it but somehow - something has taken away the current sheet I was working on and several recent years of similar info.  Now I'm lost - how to recover, what to do next, the program today only showed the former method of spreadsheet applications.     Can anyone give me an Idea of what to do next,   was the former sheets saved in the cloud or what.  as you can probadly tell I am not very well skilled to the updated world

    Bill Bylsma