Share this article

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Microsoft’s latest Excel update enables pictures to act as cell values

2 min. read

Published onJuly 19, 2023

published onJuly 19, 2023

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

In this article

Toggle

According toMicrosoft, they have introduced a new feature in Excel that allows pictures to become the actual cell value, remaining attached to the data even when the sheet’s layout is modified. This feature enables users to use images in tables, sort, filter, and include them in formulas.

Recently, Microsoft launched theIMAGE function, allowing users to place web pictures in cells using URLs based on valuable user feedback. Now, they have implemented the ability to insert local pictures directly into cells from devices or stock image libraries.

Here’s how it works

Switch between picture types

Users can select an existing picture inserted using the “Place over Cells” command and click the “Place in Cell” button next to the image to switch between picture types. The “Place in Cell” command can also be found in the right-click context menu or the Picture Format contextual tab.

Paste a picture from the clipboard into a cell

For those who prefer to paste a picture from the clipboard directly into a cell, use thePaste > Paste Picture in Celloption on the Home tab or in the right-click context menu. The default Paste command will paste the picture over cells, not into a cell.

These capabilities are currently available to Insiders running:

Soon, these features will be available in Excel for the web, in Excel for iOS, and in Excel for Android.

Excel is a part of the Microsoft 365 bundle, and Microsoft is set to launchaffordable Windows 365.

Davesh Beri

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Davesh Beri

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Microsoft’s latest Excel update enables pictures to act as cell values#

Here’s how it works#

Switch between picture types#

Paste a picture from the clipboard into a cell#