Tom’s Tutorials for Excel: Putting a picture in a comment

by Tom Urtis 1 Comment ↓

Tom’s Tutorials for Excel: Putting a picture in a comment

Show comment.
Select comment and right click its edge.
Select Format Comment > Colors and Lines tab.
Click drop-down arrow of Color field in Fill section.
Select Fill Effects > Picture tab.
Click Select Picture button, navigate to your picture, click Insert > OK > OK.
Size comment as desired.

‹ Tom’s Tutorials for Excel: Automatically Dismiss a Message Box

Tom’s Tutorials for Excel: How to Create or Replace a Worksheet ›

Posted in Tom's Tutorials for Excel
Tags: Analytics, Big Data, Business Intelligence, Comments / Screen Tips, Data Science, Excel Expert, Excel Guru, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Pictures Shapes Graphics, Tom Urtis

One comment on “Tom’s Tutorials for Excel: Putting a picture in a comment”

1. Raghav Dayal says:

   November 12, 2020 at 1:58 am

   Hi Tom,
   This article was a good read and learn. I have inserted images as comments with names while I was preparing Data in sheet 1 for the ID cards for my college. Now I want to perform lookup from sheet 2 on sheet 1 to create the ID card. All other details I have managed to lookup like roll number, name, father’s name, class, section, phone number, address with city name and zip code. These details were present in various columns on sheet 1. What I am not able to pull/lookup in sheet2 is the images which were inserted as comments in Sheet1. Can you help me with that.

   Reply