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

Excel for the web is constantly evolving and adapting to meet your needs. We listen to your feedback and put it into action. Excel for the Web is excited to announce the next set features, which include the following improvements to improve the quality and effectiveness your work.

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

New Conditional formatting experience 

Conditional formatting capabilities make it easier to manage, edit, or create formatting rules in Excel for web. 

 

For more information, click here: New Conditional Formatting experience in Excel for the web – Microsoft Tech Community 

 Function library 

Excel users who are skilled in formulas will find them indispensable. Many users rely on the functions library to help identify and find the right function to use. With this improvement, we bring Excel’s familiar formula library to you in Excel for the web.  

Function libraryFunction library

 

New filter menu 

The new filter menu makes it easier and more efficient to filter data. 

New filter menuNew filter menu

Insert slicer 

You can create slicers for PivotTables using Excel to filter data the way that you want.  

  • Filter data in a PivotTable easily 
  • Visually identify the filtered items within a PivotTable 
  • Interactive summaries can be created using slicers that are connected to multiple PivotTables  

How to insert slicerHow to insert a slicer

Insert slicer dropdown menuDropdown menu for insert slicer

Upload online photos 

Insert Stock Images and Pictures From Bing Search on Excel For the Web  

Now you can find high-quality images from Microsoft Stock Images and add them to your worksheet. You can filter the images using the categories available in the Stock images window. Stock Images also offers Cutout people and Stickers for Excel. You can also search Stock Images using keywords. You can choose multiple images from all categories and then insert them onto an Excel worksheet.  

How to insert Microsoft stock imagesHow to insert Microsoft stock photos

Search Microsoft stock imagesSearch Microsoft stock images

Bing Pictures search is now available in Excel for the Web. Search the internet for a picture using keywords, or use the prepopulated picture category. Multiple pictures can be selected and inserted onto an Excel worksheet.  

Insert Bing pictures on Excel for the webBing pictures can be imported into Excel to make it web-friendly

Search Bing imagesSearch Bing Images

These are just a few of the recent improvements. Many more are on the horizon!  

 

Leave a Reply

Your email address will not be published.