In Word, Leticia notes that you can paste a picture into a comment. She's tried to do this in Excel, but without success. She wonders if there is a way to paste a picture into an Excel comment.
There is no way to paste a picture into a comment (as you do in Word), but there is a way to make a picture appear within a comment. This may sound like a confusing contradiction, but Excel allows you to actually format the comment, independent of the text contained in the comment, so that it is "filled" with a picture.
Note that Microsoft changed the way comments work in Excel in Office 365. Comments are now threaded allowing users to have discussions with each other regarding the data. Notes work like comments in earlier versions of Excel. The following steps apply both to earlier versions of Excel using comments and to Excel for Office 365 using notes:
Figure 1. The Colors and Lines tab of the Format Comment dialog box.
Figure 2. The Picture tab of the Fill Effects dialog box.
Remember that these steps don't actually insert a picture in the comment or note, but instead use the picture as the fill color for the comment or note. This means that you can still add any text in the comment or note you want and it will overlay the picture you just inserted. You can, if desired, also delete any text in the comment or note so that it appears the only thing in the comment or note is the picture.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13280) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
When you insert a shape into a worksheet, Excel does some preliminary formatting on that shape. You can subsequently make ...
Discover MoreGraphics can really add pizzazz to a worksheet, but they can also present some drawbacks. If you want to get rid of all ...
Discover MoreWhen you add multiple graphic objects in a worksheet, it can often be beneficial to group those objects together. Here's ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-01-22 15:39:52
Margaret Messick
Hello. Thanks for this tip. But I want to take this further - I have a spreadsheet with the photos in the comments and want to publish it to a website. I can open the file in my browser (from the file stored on OneDrive) and open the note but the picture doesn't show. Is there any way to make the photo show in the note when it is on the web???
Thanks,
Margaret
2020-07-19 21:23:58
Louie E
wow i have to do this process for like 3000 times! though i was looking for a way that you can insert multiple pictures in a comment...
2020-07-13 12:43:54
Where do you see the context menu?
2019-06-13 06:46:40
Ron West
I failed to mention that this is in the Excel 2019 Version for Mac
Ron
2019-06-12 18:56:15
Ron West
Hi,
It appears that Microsoft have removed the ability to insert a picture/image in the way above. It may have something to do with copyright/creative commons/licensing, cheers.
Ron
2019-03-31 06:13:38
Chanchea
hi,
when i click to insert a picture into comment, it request me to update inter explorer, i try to update but nothing happen
2014-10-22 13:16:04
Leticia Marquez
Thank you for the tip.
2014-10-20 13:08:12
Kim Carlton
Very cool. Thanks for this one.
2014-10-20 12:28:59
Brooke
I've found a problem with this method. After saving the file and subsequently opening and closing it a few times, I will get an error stating that there is some problem with the file and that the offending data has been "scrubbed." The next time the file is opened, the pictures that were in the comments are now gone. Haven't been able to figure out how to stop this from happening as it is very irritating after taking the time to add multiple photos to comments in a large file. Apparently this is a known issue as I have found some discussion of the problem in online Excel forums.
2014-10-20 09:08:16
Nice!
Now if MS would only make this in-line with how it's done in Word.
First, if you add text to the Comment it sits on top of the picture.
Second, I don't see a way to simplify this process, i.e. create a macro that would eliminate all of the navigation through the dialogues. Recording a macro showed no hint and the object model seems to hide how this is structured.
I'm afraid that trying to teach some of my users how to do this would make their eyes roll all the way back in their heads.
2014-10-18 11:58:05
COOL !!
2014-10-18 09:41:14
Sharon Hammond
Loved this tip. Just goes to show you can never know enough about Excel :)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments