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.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Worksheets can contain more than just text and numbers. Here's the low-down on the different types of pictures you can ...
Discover MoreExcel allows you to set up graphics so that they are associated with cells and even stay with the cells when the cells ...
Discover MoreExcel is great at printing numbers on a piece of paper, but terrible at printing watermarks. This is apparently by ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
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