Microsoft Excel popup image for a worksheet cell

I recommend

I was working on a Microsoft Excel 2007 spreadsheet and I wanted an image to popup for a cell. I found a number of sites listing a solution, but they only explained it in text so I thought I’d do it with some images and a video to make it clear. It is a bit confusing.

The first step is to add a comment for a cell.

Excel Insert Comment

Delete out the comment text.

Excel Delete Comment Text

Right click on the comment border and select the Format Comment… menu item.

Excel Format Comment Right Click

On the Format Comment dialog choose the Colors and Lines tab. Then from the Color drop down list choose the Fill Effects drop list item.

Excel Format Comment Dialog

From the Fill Effects dialog choose the Picture tab and click the Select Picture… button.

Excel Format Comment Fill Effects Picture Tab

Choose the image file you want to use as the cell comment background and click the Insert button.

Excel Select Picture Dialog

Now click OK on the remaining open dialogs and when done you should see the comment background showing the image you chose.

Excel Image Popup For A Cell

Please be mindful of the image file size as this image will make your Excel spreadsheet that much bigger.

I’ve created a video tutorial about how to add a popup image as well.

I hope this helps :-)

Technical Nontechnical March 1, 2010


Comments