What's New in Excel (July 2023)

Welcome to the July 2023 update. Check out this new Excel add-in that will supercharge the EVE online gaming experience here >.

 

This month, we are excited to share the release of Insert Pictures into Cells and Set Default Theme for Windows and Mac Insider users. Mac Insider users can also Automatically Crop Pictures. Furthermore, Excel for web users can now Format Individual Data Points in your Charts. 

 

The second release of the year for our Enterprise users in the Semi-Annual Channel is also available now – catch up on these feature releases here >.

 

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. Format Individual Data Points in your Chart via Home Ribbon Controls

Excel for Windows:

1. Share a Section of a Workbook (Current Channel)
2. Copy Values Quickly from the Status Bar (Monthly Enterprise Channel) #FIA
3. Insert Pictures in Cells (Insiders) #FIA
4. Default Theme for Office (Insiders)

Excel for Mac:

1. Automatically Crop Pictures (Insiders)
2. Insert Pictures in Cells (Insiders) #FIA
3. New Default Theme for Office (Insiders)

Android

1. Insert Photos from Android Phone (Insiders)
2. New Default Theme for Office (Insiders)

Excel for web

1. Format Individual Data Points in your Chart via Home Ribbon Controls

You can now format data points in your chart using the Home Ribbon Controls. With this update, you can choose the fill color for each individual point in the data series. This can be a helpful way to highlight particular data points and illustrate trends in your data.

 

 

Excel for Windows

1. Share a Section of a Workbook (Current Channel)

Whether collaborating through Teams or on the web, you may want to share information from a workbook. You can share the entire workbook, but often it’s safer, faster, and more efficient to share just a section of the workbook for viewing or editing. You can now easily share with others a link to a specific range, table, or chart, now available on Windows.  Read more >

Share a Section of a Workbook

#FIA

2. Copy Values Quickly from the Status Bar (Monthly Enterprise Channel)

 You can now select the value that you want to copy and move it to the clipboard. Then, you can simply paste the information wherever you need in your workbook. Read more here or watch this video from one of our Excel MVP's.

 

#FIA

3. Insert Pictures in Cells (Insiders)

We've enabled the ability for a picture to become the actual cell value. It remains attached to the data even when the sheet’s layout is modified. You can use it in tables, sort, filter, include it in formulas, and much more! Read more here > or watch this Youtube instructional video from one of our Excel MVP's Leila Gharani.

Insert Pictures in Cells

4. New Default Theme for Office (Insiders)

We’ve refreshed the Office theme with a new default font, color palette, style, and line weights that help you make your documents more modern and accessible. Read more here >

 

Excel for Mac

1. Automatically Crop Pictures (Insiders)

With a single click, the Auto Crop command helps you identify the most important parts of your picture and crops out the rest. This feature is also available for iOS Insiders. Read more here >

Automatically Crop Pictures on Mac

#FIA

2. Insert Pictures in Cells (Insiders)

We've enabled the ability for a picture to become the actual cell value. It remains attached to the data even when the sheet’s layout is modified. You can use it in tables, sort, filter, include it in formulas, and much more! Read more here >

Insert Pictures in Cells

 

3. New Default Theme for Office (Insiders)

We’ve refreshed the Office theme with a new default font, color palette, style, and line weights that help you make your documents more modern and accessible. Read more here >

 

Android

1. Insert Photos from Android Phone (Insiders)

In the past, transferring images from your Android phone to a Word, Excel, or PowerPoint files required multiple steps. That’s no longer the case! You can now do so by using a wireless connection. Read more here >

 

2. New Default Theme for Office (Insiders)

We’ve refreshed the Office theme with a new default font, color palette, style, and line weights that help you make your documents more modern and accessible. Read more here >

 

 

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 Twitter.

 

Special thanks to our Excel MVPs David Benaim and Bill Jelen for their 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. Bill is the founder and host of MrExcel.com and the author of several books bout Excel.