How to Insert Images into the Excel Comment Box

This article examines Creating Excel notes and explains the main developments, practical implications, and context readers should understand.

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.

• Instructions for inserting notes in the footer in Word
• How to insert content annotations on Word
• 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.

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.

Step 3:

Display the new interface, click on Colors and Lines.

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

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.

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.

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

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.

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

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

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.

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

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.

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

I wish you all success!