What is New in Excel for the web in March 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. 

thumbnail image 1 captioned Function library

Function library

New filter menu

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

thumbnail image 2 captioned 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 
thumbnail image 3 captioned How to insert slicer

How to insert slicer

thumbnail image 4 captioned Insert slicer dropdown menu

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. 

thumbnail image 5 captioned How to insert Microsoft stock images

How to insert Microsoft stock images

thumbnail image 6 captioned Search 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. 

thumbnail image 7 captioned Insert Bing pictures on Excel for the web

Insert Bing pictures on Excel for the web

thumbnail image 8 captioned Search Bing images

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! 


Source:
 
Excel for the web is constantly changing and adapting to better meet your needs by listening to your feedback and putting this into action.
Where is "Simplified Ribbon"?! :woozy:
 

My Computer

System One

  • OS
    Win 11 Enterprise
    Computer type
    Laptop
    CPU
    i7
    Hard Drives
    SSD
Back
Top