What's New in Excel (June 2023)
Published Jun 27 2023 06:00 AM 37.9K Views
Microsoft

Welcome to the June 2023 update. We celebrated Pride this month, read more on how to add a touch of Pride to your Excel here

 

This month we also bring you Formula Suggestions and Formula by Example for Excel web users. Use Image and Data Types in PivotTables are now available for Windows and Mac Insider users, and Generate an Accessible PDF is available to all Mac users.

 

Many of these features are the result of your feedback. THANK YOU! Your continued Feedback in Action (#FIA) helps make Excel better for everyone. 

 

Excel for web:

  1. Formula Suggestions
  2. Formula by Example
  3. Support Chart Formatting via Selection & Ribbon Buttons
  4. Move Chart Elements within Chart Player
  5. Name Manager #FIA

Excel for Windows:

  1. Office Scripts (Current Channel and Monthly Enterprise Channel)
  2. Get Data from Dynamic Arrays (Current Channel) #FIA
  3. Rapid Refresh (Current Channel) #FIA
  4. Guided Reapply (Current Channel)
  5. Use Image and Data Types in PivotTables (Insiders)
  6. Paste Values Directly into Your Workbook Using a Keyboard Shortcut (Current Channel)

Excel for Mac:

  1. Generate an Accessible PDF #FIA
  2. Enhanced Search Experience #FIA
  3. Use Image and Data Types in PivotTables (Insiders)

Excel for web

1. Formula Suggestions

Type the “=” sign in a cell or the formula bar and Excel will auto-suggest the best formula based on contextual insights from your data. Formulas that can be suggested are SUM, AVERAGE, COUNT, COUNTA, MIN, and MAX. This feature is now available for all web users who have English set as their primary language. Read more here >

 

2. Formula by Example

As you are performing manual and repetitive data entry in a column, Excel will now suggest you to fill the entire column with a formula in case we identify a pattern. This is similar to Flash Fill, however, instead of static text - now formulas can be suggested. This feature is now available for all English locale web users. Read more here >

 

3. Support Chart Formatting via Selection & Ribbon Buttons

Format your chart using the Home Ribbon Formatting controls.

 

4. Move Chart Elements within Chart Player

Click and drag chart element and trend line equation to move them in the chart. This expands users' ability to customize how their chart looks.

 

#FIA

5. Name Manager

Create named ranges from the Name Box in Excel for the web. Users can also search in the name box for any named ranges.

Excel for Windows

1. Office Scripts

Automate repetitive worksheet tasks without needing any programming experience. Perform the actions you want in Excel, and the recorder will create an Office Script to replay those actions for you. Read more >

Record worksheet actions using Office ScriptsRecord worksheet actions using Office Scripts

#FIA

2. Get Data from Dynamic Arrays

Get Data from Table/Range now includes Dynamic Arrays! Select any Dynamic Array on the grid and import it using Power Query.

 

#FIA

3. Rapid Refresh 

Rapid Refresh is a feature that automatically reloads the workbook in coauthoring scenarios where the user may be prompted to refresh manually. Multi-workbook support and support in Excel for Mac coming soon.

Rapid Refresh for WindowsRapid Refresh for Windows

 

4. Guided Reapply

Previously, when coauthoring got interrupted for one reason or another, users would have to select “Save As” (which creates another copy of the file) or “Discard” their changes to get back to the shared file. With Guided Reapply, users can review the pending changes and return to the shared file with confidence.

Guided Reapply for WindowsGuided Reapply for Windows

 

5. Use Image and Data Types in PivotTables (Insiders)

Data types and in-cell images are a powerful part of modern Excel, and now, they come intact to your PivotTable rows and columns including the same interactions you have in your source data (image cards, data type icons, data type cards, and so on). Read more >

Use images and data types in PivotTables, for Windows and Mac InsidersUse images and data types in PivotTables, for Windows and Mac Insiders

6. Paste Values Directly into Your Workbook Using a Keyboard Shortcut

The keyboard shortcut CTRL+SHIFT+V lets you quickly Paste Values rather than having to choose Paste Values from the menu. This feature is currently rolling out to Windows users. Read more here >

Excel for Mac

#FIA!

1. Generate an Accessible PDF

Previously when you exported to PDF on Mac, there were no tags added to communicate the structure of the document so all of the content was jumbled together. Now, the PDF service automatically creates accessibility tags, which brings the experience on par with Win32.

Generate an accessible PDF on MacGenerate an accessible PDF on Mac

 

#FIA

2. Enhanced Search Experience (Insiders)

The search experience has been revamped to provide a single place to find content from multiple sources. This function provides smart search suggestions before you type as well as supporting searching for more than just text in your document, i.e., you can also search for commands, help articles, or web results (such as definitions, media, and Bing results). Read more here >

Enhanced Search Experience in Excel for Insiders Mac usersEnhanced Search Experience in Excel for Insiders Mac users

 

3. Use Image and Data Types in PivotTables (Insiders)

Data types and in-cell images are a powerful part of modern Excel, and now, they come intact to your PivotTable rows and columns including the same interactions you have in your source data (image cards, data type icons, data type cards, and so on). Read more >

Use images and data types in PivotTables, for Windows and Mac InsidersUse images and data types in PivotTables, for Windows and Mac Insiders

 

 

Check if a specific feature is in your version of Excel

Click here to open in a new browser tab

 

 

 

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.

 

Special thanks to our Excel MVP David Benaim for his contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more.

6 Comments
Version history
Last update:
‎Jun 28 2023 02:01 PM
Updated by: