Analyst Toolbox

Add a Picture to MS Excel Comments (Pop-Up)

Product: MS Excel

A MS Excel comment is a pop-up box that appears when you hover over the cell with your mouse.

Cells containing comments are indicated by a red triangle in the upper right corner.

Right-click the cell where you want to add the comment/photo and select "Insert Comment".

Make sure the comment block is blank (i.e. contains no text).

With the blank comment block added to the cell, right-click the cell again and select "Show Comment". This will keep the comment block open.

Click on the comment block and then right-click on the border of the comment block, and select "Format Comment".

On the "Format Comment" pop-up select the "Colors and Lines" tab.

On that tab, select "Fill" and "Color", and then in that pallet select "Fill Effects" (at the bottom).

On the "Fill Effects" pop-up select the "Picture" tab. Now use the "Select Picture" button to choose the picture you want to add to the comment block in your cell. Click "OK" to add picture.

Finally go back to the cell (on the MS Excel spreadsheet) that you selected for the photo and right-click and select "Hide Comment".

Now when you hover over this cell with your mouse the picture you selected will pop-up.

Adding picture pop-ups to your MS Excel worksheet allows you to include (for example) individual photos with identification information, or property photos with an inventory list.

Author: Michael Chesbro, CCIA
Updated 9/21/2009

View all toolbox tips | Send to a colleague