What’s New in Excel (October 2024)

Excel for Windows, Mac, and the web:
– GROUPBY and PIVOTBY functions

Excel for Windows:

– Focus Cell (Insider)

– Color picker

– New templates in Excel

– Draw and hold gestures (Insider) #FIA

Excel for Mac and iOS:

– Seamlessly switch between Apple devices with Handoff support (Insider)

Excel for the web

Clean your data with Copilot in Excel

Copilot in Excel lets you organize your data with just one click. Clean Data detects text inconsistencies, number formatting issues, and extra white space and provides solutions for them. SThis means selecting the Clean Data option in the Data tab of the ribbon. Or, interact with the pop-up banner to get started.. Read more here >

Inconsistent text suggestion cards showing mixed case examples of the word ‘Excel’, including ‘Excel’, ‘EXCEL’, and ‘Excel’.

Excel for Windows, Mac, and the web

GROUPBY and PIVOTBY functions

These features are now generally available to users in Current Channel. GROUPBY and PIVOTBY You can perform data aggregation using a single formula. All you need is 3 arguments. me) What to group, ii) the values ​​to aggregate, and iii) the function to use for the aggregation. Read more here >

Group by:

Pivot ratio:

Excel for Windows

Focus Cell (Insider)

Use Focus Cell to make the active cell more visible in your worksheet. Focus Cell applies a vivid highlight to the corresponding row and column of the active cell and increases the border thickness of the active cell. This makes the active cell more visible and makes it easier to identify data in the same row and column. Read more here >

Animation showing the Focus Cell command used in an Excel worksheet.

color picker

Excel’s color picker now includes a feature that shows whether the selected color contrasts appropriately with the background. When you hover your mouse over a color, you’ll see a tooltip indicating whether that color has “low contrast” or “good contrast” against the background. You can also turn on the “High Contrast Only” toggle to filter and display only colors with sufficient contrast.

The color picker displays a tooltip that previews the color’s contrast with the background.

New templates in Excel

We’re excited to introduce three new Python features in Excel templates. To access, go to: File > New. Then type “python” in the template search bar. Python in Excel templates are currently only available in English.

1. Python in Excel tutorial: learnLearn about Python in Excel and how you can use it to analyze data directly within an Excel spreadsheet.

GIF showing how to interact with the Python Getting Started template in Excel

2. QR aspirateode ggenerator: Easily create customized QR codes in Excel to share with others and quickly access links.

GIF showing how to create a QR code using an Excel template

3. dummy dAtta ggenerator: create Realistic dummy data for testing Or demo.

GIF showing how to interact with the random data generator template

Draw and Hold Behavior (Insider)

To create cleaner lines and shapes, you can now use draw and hold actions. Draw a line, arrow, or shape (such as a circle, oval, triangle, square, rectangle, diamond, pentagon, or hexagon) all at once, hold the pen in place for a few milliseconds, and watch how the shape changes. It has been changed to a cleaner version. You can rotate or resize the shape by pressing and dragging. Read more here >

Animation of drawing a straight line using drag and hold motion

Excel for Mac and iOS

Switch seamlessly between Apple devices with Handoff support (Insider)

Handoff is an Apple feature that lets you continue working on content while switching from one Apple device to another. For example, if you’re working on an Excel spreadsheet on your iPhone and want to switch to your Mac, Handoff allows you to do so in just a few clicks. Read more here >

Many of these features are a result of your feedback. thank you! your continuation Running feedback (#FIA) Help us make Excel better for everyone. Let us know if you like a particular feature and how we can improve it.“Please compliment me” or “Please make a suggestion”.. You can also submit new ideas or vote on other ideas by: microsoft feedback.

our subscriptionexcel blog and Insider Blog To get the latest updates. Stay connected with us and other Excel fans around the world.excel communityand follow usX (formerly Twitter) .

Special thanks to Excel MVP. David Benaim,bill jellen, alan murray and John Michaludis Thank you for contributing to this month’s What’s New in Excel article. David publishes weekly. youtube video and regular LinkedIn Posts Learn about the latest innovations in Excel and more. Bill is the founder and host. MrExcel.com He is also the author of several books on Excel. Alan is an Excel instructor, author, speaker, and best known for his blog. computergaga.com and youtube channel With the same name. John is the Founder and Chief Inspiration Officer. MyExcelOnline.comHe has passionately taught thousands of professionals how to use Excel to stand out from the crowd.