Contextures News

Add a popup picture on an Excel worksheet, separate
dates in an Excel table, and other tips for you, in this week's Excel
news from Contextures.

Add a Popup Picture in an Excel Comment

Did you know that instead of text, an Excel comment can contain a picture? With this trick, you can add pictures in an Excel worksheet to help explain the data. For example, if you're selling garden products, you could add pictures of the plants and garden tools.

To add a picture that is tied to a specific cell, you can insert a picture in an Excel comment. The pictures will be hidden until the user wants to see them, so the pictures won't clutter up the worksheet.

Point to a cell that has a comment (marked with a red triangle), and the picture will pop up on the worksheet.