What's New in Excel (June 2024)
Published Jun 25 2024 04:09 PM 7,149 Views
Microsoft

Happy Pride month! Show off your Pride in Excel with a special theme for Mac and iOS users.

 

Welcome to the June 2024 update. This month, prompt Copilot in Excel to work with columns & formulas in Excel for web, Windows, and Mac; navigate and perform tasks more quickly with KeyTips in Excel for Mac, now available to Beta Channel users; and view and open your most recently accessed Excel files from the home screen on your iOS device, now available to Insiders.

 

Excel for web, Windows, and Mac:

- Copilot in Excel: Working with Columns & Formulas

 

Excel for Mac:

- KeyTips (Insiders)

Excel for iOS:
- Recent Files Widgets (Insiders)

 

Excel for web, Windows, and Mac

 

Copilot in Excel: Working with Columns & Formulas
Copilot can help write complex formulas, including ones that work with text. See the examples below and
read more here >

 

Example 1: Organize data by splitting a single column into multiple columns

Prompt: "Split the first column into three: Name, Years alive, and Country. Insert after the first column"

 

Example 2: Calculate age by extracting the years from a string of text

Prompt: Add a column that calculates how long each person was alive for. If they are still alive, write 'Alive today.'"

 

*If you try these prompts and they do not work as expected, it mostly likely is due to our gradual feature rollout process. Please try again in a few weeks.

 

Excel for Mac

 

KeyTips (Insiders)

KeyTips are keyboard shortcuts for items in the ribbon menu in Microsoft applications. They provide a quick way to navigate and perform tasks with your keyboard—no clicking required. You might be familiar with KeyTips on your Windows PC, and they function the same way on a Mac. Read more here >


KeyTips preview on the ribbon tabKeyTips preview on the ribbon tab

 

Excel for iOS

 

Recent Files Widgets (Insiders)
Quickly access your recently used files straight from your home screen with Recent Files widgets for Word, Excel, and PowerPoint for iOS. The widgets allow you to both view and open your most recently accessed files in that app from the home screen on your device. Read more here >

Recent Files widgetsRecent Files widgets

 

 

 

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—"Give a compliment" or "Make a suggestion"..  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 X, formerly Twitter.

 

4 Comments
Co-Authors
Version history
Last update:
‎Jul 02 2024 12:59 PM
Updated by: