• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Excel Tips / Insert a Picture in a Comment

Insert a Picture in a Comment

Excel was created for the use of calculating and analysing huge amounts of data. Because of this it has never been great for storing large amounts of text or pictures. Inserting images into a cell would make the spreadsheet even larger and more awkward in its daily use.

Comments are fantastic for leaving notes for other users, but they can also be used to store pictures. These pictures can then be made visible when required rather than permanently displayed on screen within a cell.

Insert a Picture in a Comment in Excel

  1. Select the cell that you want to add the comment to.
  2. Click the Review tab on the Ribbon and then click New Comment.
  3. The comment appears with text displaying the username. This text will appear on top of the picture so let’s delete it.
Insert a new comment in Excel
  1. Right mouse click on the border of the comment to bring up a menu and select Format Comment.
Colors and Lines tab of the Format Comment dialog box
  1. Select the Colors and Lines tab on the dialog box. Click the Color list arrow and select Fill Effects.
  2. Select the Picture tab and then click the Select Picture button.
Picture tab of the Format Comment dialog box
  1. Locate and select the picture you want to use. Click Ok to both dialog boxes to save your changes and close them.
  2. The picture appears within the comment box. When you click away from the comment it will disappear.
Picture in a comment in Excel

To view your comments you can simply hover your mouse over the cell containing them. You can also use the Next and Previous buttons in the Comments group of the Review tab on the Ribbon to move through your comments, or click the Show All Comments button to display them all.

Watch the Video

Related Posts:

  • Create a Picture Lookup in Excel
    Create a Picture Lookup in Excel
  • Excel IMAGE Function - Insert Images from a Cell Value
    Excel IMAGE Function - Insert Images from a Cell Value

Reader Interactions

Comments

  1. Juan says

    25 July 2013 at 11:50 am

    Excellent video, very illustrative. Thank you very much for taking the time to post it!

    Reply
  2. Graham Fowler says

    25 July 2013 at 2:36 pm

    I had been referred to your site through a friend, it has come to light that we cannot subscribe to your newsletter because our email address ([email protected]) fails the email validation, after investigating it appears this is caused by the hyphen in our domain name. Just thought you should be made aware.
    Regards,
    Graham

    Reply
    • computergaga_blog says

      25 July 2013 at 8:05 pm

      Thank you for bringing it to my attention Graham. Sorry to hear that.

      Reply
  3. Mohideen says

    26 July 2013 at 12:14 am

    what a great video, thank you very much for all your hard work, keep up the good work.

    Reply
    • computergaga_blog says

      26 July 2013 at 6:39 am

      Thanks Mohideen, no problem.

      Reply
  4. Jeff B. says

    8 October 2013 at 11:10 pm

    Very useful tip, thank you. We frequently create picture catalogs in Excel to send out to our buyers and could use this concept as well. Currently we’re using a nice add-in utility which we just recently bought that saves our company enormous amounts of time and helps us concentrate on the business rather than act as da Vinci of 21st century. It’s called Picture Manager for Excel and it automatically inserts product pictures (sized fit to cells). Check it out if you’d like, their site is Doality.com

    Reply
  5. Ong Chin Hooi says

    9 July 2017 at 10:57 am

    It’s was a great help by your continuous info on your great video lesson. Looks like I’ll not miss your class! Easy to follow well presented.

    Reply
    • computergaga says

      10 July 2017 at 12:33 pm

      Thank you. Your comments are much appreciated.

      Reply
  6. Zizi says

    17 October 2017 at 4:51 am

    Thanks a lot for your useful post. very helpful

    Reply
  7. Kanhaiyalal Newaskar. says

    16 June 2020 at 12:43 pm

    Sir, 16/6/2020.
    Very neatly and nicely you have shown the system to insert the picture in
    the comment box.
    Hope to receive such useful tips and tricks in future too.
    Thanking you.
    Kanhaiyalal Newaskar.

    Reply
    • Alan Murray says

      16 June 2020 at 1:13 pm

      You’re welcome. Thank you.

      Reply
  8. Peter says

    15 September 2020 at 10:44 am

    Hi Alan – Thanks for your videos. I’m still learning new tricks in Excel after retiring more than ten years ago. I’m using Excel 365, so I had to use a note rather than a comment.
    I found the following in Help after I’d figured it out.

    “The difference between threaded comments and notes

    Excel for Microsoft 365 has changed the way comments work. Comments are now threaded, and allow you to have discussions with other people about the data. Notes are for making notes or annotations about the data, and work like comments used to work in earlier versions of Excel.”

    Reply
    • Alan Murray says

      17 September 2020 at 9:38 pm

      Hi Peter, yes this tutorial is 5 years old and Excel has changed rather a lot in that time. Good to hear you are learning new tricks in Excel 👍

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • Moving Average in Excel
  • Excel IMAGE Function – Insert Images from a Cell Value
  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·