How to insert images into the Excel comment box

On the Excel spreadsheet or on Word, to clarify certain information and content that users do not want to write directly, they can insert notes. This note will help viewers better understand the information. And in the process of working, users can hide, show Excel notes easily to compact spreadsheets.

For those who manage human resources and records in Excel, in addition to manipulating notes with other necessary information, they will add images to the notes box. If you follow the way to add images to Excel cells, it will be unprofessional. The following article will guide you how to insert a note frame image in Excel.

1. Instructions for inserting notes in the footer in Word
2. How to insert content annotations on Word
3. How to insert text into images in Excel

Instructions for adding photos to Excel notes

Step 1:

Open the statistics table in Excel and add notes as usual. How to add a note to the box above E xcel you read the article Add captions to spreadsheet on Excel.

How to insert images into the Excel comment box Picture 1

Step 2:

After inserting notes into the content on Excel, the user continues to right click on the frame outside the note and select Format Comment . Note, if the user right-click in the comment box and select Format Comment, only the text formatting editing interface will be displayed in the comment box.

How to insert images into the Excel comment box Picture 2

Step 3:

Display the new interface, click on Colors and Lines .

How to insert images into the Excel comment box Picture 3

Next, in the Color section, click on the drop-down arrow and select Fill Effects .

How to insert images into the Excel comment box Picture 4

Step 4:

The Fill Effects dialog box appears so that users can change the notes content. Click on the Picture tab to upload the image, click on Select Picture .

How to insert images into the Excel comment box Picture 5

Step 5:

In the Insert Picture interface, we are given a choice of where to get the image we want to insert into the comment box. Can get photos from OneDrive (OneDrive - Personal) if users install and sync OneDrive on computers, photos from computers (From a file) and online images (Bing Image Search).

The options for taking photos will only be available on Excel 2010 version onwards. From Excel 2007 and below, the folder on the computer will be displayed immediately to retrieve the image.

Users click Browse at From a file to select images from the computer.

How to insert images into the Excel comment box Picture 6

The selected image will display as shown below. Click Ok to save.

How to insert images into the Excel comment box Picture 7

Step 6:

Go back to the Format Comment interface and click the Size item to resize the image. Here we can resize the image if desired. Click Ok to save.

How to insert images into the Excel comment box Picture 8

The resulting image will be displayed in the insertion frame as shown below.

How to insert images into the Excel comment box Picture 9

Users can change the note frame to match the size of the image.

How to insert images into the Excel comment box Picture 10

When you click on the note frame, the image will be blurred, the content of the note will be displayed more clearly. Here you enter additional notes if you want.

How to insert images into the Excel comment box Picture 11

Besides, you can reformat the note content if you have one, like changing colors, etc. to highlight notes.

How to insert images into the Excel comment box Picture 12

The operation of inserting images into Excel comment and comment frames is very simple and easy to implement. Users do not need to resize the image before, because when finished inserting it can shrink the image. Thumbnail images will not be broken or blurry images because Excel automatically adjusts image quality according to the note frame.

See more:

1. How to create an Excel table, insert a table in Excel
2. Instructions on how to set a password to protect the Excel file safely
3. How to create a password protection for Excel sheets

I wish you all success!