Categories: Blog

What’s New in Excel (July 2023)

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

https://cdn.embedly.com/widgets/media.html?src=https%3A%2F%2Fwww.youtube.com%2Fembed%2Fjjgo2Lgbtvs%3Ffeature%3Doembed&display_name=YouTube&url=https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Djjgo2Lgbtvs&image=https%3A%2F%2Fi.ytimg.com%2Fvi%2Fjjgo2Lgbtvs%2Fhqdefault.jpg&key=b0d40caa4f094c68be7c29880b16f56e&type=text%2Fhtml&schema=youtube

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 ExcelClick here to open in a new browser tab https://onedrive.live.com/embed?resid=E07B6F5DD91EC58B%21261&authkey=%21AMNbD8E1w2sfb9c&em=2&wdAllowInteractivity=False&Item=%27Updated%20October%202022%27!A1%3AH39&wdHideGridlines=True&wdInConfigurator=True&wdInConfigurator=True&edesNext=true&resen=false
admin

Recent Posts

Where to get Excel Expert on Freelancing Basis

Excel freelancers are skilled professionals who can tackle a wide range of tasks, from data…

10 months ago

Announcing Python in Excel: Combining the power of Python and the flexibility of Excel

Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data,…

10 months ago

Mastering the Basics of Excel: Your Ultimate Guide

In today's digital age, proficiency in Microsoft Excel has become an essential skill in both…

10 months ago

Inventory Management In excel

Full Inventory Management in excel with automated report

10 months ago

Order Cancellation Reason Analysis

This business wanted to know the reason of order cancellation. As this food delivery service…

10 months ago