MacOS Excel - How can I insert an image into a cell

Question

MacOS Excel - How can I insert an image into a cell

Anonymous

It seems that this question was previously submitted and subsequently closed, but no real solution or explanation was given to the many Excel for Mac users across the internet who continue to search for their way out of this "mess"; by that, I mean the confusion caused dropping the IMAGE function since version MS Office 2021 (Version 2301 build 16026.20146).

I currently run the Microsoft® Excel for Mac Version 16.63.1 (22071301)], but I found a way to deal with the issue after many failed attempts at finding the solution across any internet forums.

Most responses to this lack of "Picture in Cell" function in Excel for Mac users since 2021, illustrate steps that refer to versions of Excel for Mac prior to the 2021 release (as explained above) or simply refers] to various versions of Excel for PC, which still contain the IMAGE function (to my recollection)

Solution to enable missing IMAGE function to place "Picture in Cell":

=@_xlfn.IMAGE(B2)

Description:

=@_xlfn.IMAGE(B2) "Formula inserted in targeted cell where image or picture will be placed"

B2 contains image URL

@_xlfn "The XLFN prefix in Excel formulas indicates that the current Microsoft Excel version does not support the given function."

Tip:

Image size is scaled by enlarging row-height and column-width accordingly (Image ratio is fixed by default)

Hope this helps! 😉

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

By the way, I have just downloaded and installed the latest version of MS Office of Mac, dated December 12, 2023, Version 16.80 (23121017) and the IMAGE function is brought back - see my updated screenshot for confirmation.

Thanks to all concerned for your prompt responses and valuable input 😉

0 comments

6 additional answers

Answer 1

I'm sorry, but I don't belief my Excel for Mac Version 16.63.1 (22071301) includes the IMAGE function, as explained before - see my the screenshot as I attempt to enter the "=IMAGE" function into cell C2, below.

The IMAGE function was discontinued with version MS Office 2021 (Version 2301 build 16026.20146).

Answer 2

The question is titled "MacOS Excel - How can I insert an image into a cell" and meant for users who work offline using Excel for Mac (or MacOS Excel)

Although fully subscribed to Office 365 to stay current as retail versions update, I prefer to work in Excel for Mac. As mentioned, most forums are not clear on why or how to overcome the problem for those who work offline.

The solution I found after endless days for searching for a solution, perfectly addresses the issue.

Thanks for sharing your thoughts.

Answer 3

Rory Archibald 18,885 Volunteer Moderator

Most 365 subscriptions include the desktop software, which I assume is what you mean by offline Excel for Mac. That includes the IMAGE function as Bob said.

0 comments

Answer 4

I'm not sure I understand your question...The Insert Picture in Cell feature has been added to Excel but may only be available in the Subscription software. I believe it was added after the release of Office 2021 [Retail License]. The Retail [or one time purchase] editions do not receive enhancements:

Neither has the IMAGE function been eliminated from the program:

Both screen shots are from Mac Office Excel v16.81 Microsoft 365 Subscription.

Share via

MacOS Excel - How can I insert an image into a cell

6 additional answers