What's New in Excel (June 2022)

Published Jun 28 2022 03:00 PM 20.4K Views
Microsoft

Welcome to the June 2022 update. We are excited to share the general availability of sheet protection and semi-select for links creation in the web for Excel for the web and automatic alt text suggestions for charts and PivotCharts across Excel for Windows and Excel for Mac - among other features. For Insiders, we're rolling out the ability to insert data from picture in Excel for Windows.

 

Check out this Excel Features Flyer to find if a specific feature is in your version of Excel

 

Excel for the web

  • Sheet protection

  • “PivotTable Connections” in slicer settings pane

  • Semi-select for links creation

Excel for Windows

  • Data from Picture (Insider Beta)

  • Automatic alt text suggestions on charts and PivotCharts (Current Channel & Monthly Enterprise Channel)

Excel for Mac

  • Automatic alt text suggestions on charts and PivotCharts

  • Import from local text, CSV, and XLSX files with data preview

 

Excel for the web

Sheet protection

Excel for the web now supports enabling and configuring sheet protection. Users can now turn sheet protection on and off, temporarily pause protection for just their session, and configure unlocked ranges and other sheet protection options.

Sheet ProtectionSheet Protection

 

 

“PivotTable Connections” in slicer settings pane

Customize which slicer applies to which PivotTable - now in Excel for the web! Choose your slicer connections in the PivotTable settings in Excel for the web.

PivotTable connections in slicer settings panePivotTable connections in slicer settings pane

 

Semi-select for links creation

Create workbook links using cross-workbook formula selection, also known as semi-select - now in Excel for the web.

 

 

Excel for Windows

Data from Picture (Insiders Beta)

With the new Data from Picture feature in Excel for Windows, you can insert data from a picture on your clipboard or an image file from your computer. There’s no need to type all the data—Excel can do it for you! Read more > 

Insert data from pictureInsert data from picture

 

 

Provide automatic alt-text suggestions on charts and PivotCharts (Current Channel & Monthly Enterprise Channel)

Are you frustrated by charts missing their alternative text, so you don't know what the chart is conveying? Now, Excel automatically recognizes and generates alt text if you're using a screen reader and you land on a chart or Pivot Chart that is missing it.

 

 

Excel for Mac

Provide automatic alt-text suggestions on charts and PivotCharts

Excel now automatically recognizes and generates alt text if you're using a screen reader and you land on a chart or Pivot Chart that is missing it.

 

Import from local text, CSV, and XLSX files with data preview

You can now import data from local files such as Excel workbooks, Text and CSV files, using Power Query in Excel for Mac.

Import local files from text, CSV, and XLSX filesImport local files from text, CSV, and XLSX files

 

 

Your feedback helps shape the future of Excel. 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.

 

Subscribe to our Excel Blog and the Insiders 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. 

 

Check out this Excel Features Flyer to find if a specific feature is in your version of Excel
5 Comments
Version history
Last update:
‎Jul 26 2022 10:34 AM
Updated by: