See all Microsoft Excel tips
Strategy: Add a pop-up picture to the cell. By hovering the mouse over an item #, the picture will appear. Follow these steps.
1) Select cell A4. From the menu, select Insert – Comment. The default comment will have your name as the default text, as shown in Fig. 1182.
2) Backspace to clear out the text in the comment.
3) Using the mouse, click on the diagonal-lines border in order to change the border to a series of dots, as shown in Fig. 1183.
4) Right-click the dotted border and select Format Comment, as shown in Fig. 1184.
5) There are eight tabs in the Format Comment dialog. Go to the Colors and Lines tab. In the Fill Color dropdown, choose Fill Effects…, as shown in Fig. 1185.
6) There are four tabs in the Fill Effects dialog. Choose the Picture tab and then choose the Select Picture… button, as shown in Fig. 1186.
7) Browse to the location where you have product pictures stored. IV Select a digital image of the item. Choose Insert, as shown in Fig. 1187.
8) On the Fill Effects tab, select OK, as shown in Fig. 1188. As you return to the Format Comment dialog, a squished version of the image will appear in the Color dropdown. Don’t worry – the actual comment will look better.
9) Choose OK to close the Format Comment tab.
10) Use the lower right handle to resize the comment, as shown in Fig. 1189.
A red triangle appears in cell A4, as shown in Fig. 1190.
As promised, a picture of the product appears when you hover the mouse icon over the cell, as shown in Fig. 1191.
11) Repeat these steps for each item in the catalog.
Summary: Everyone thinks of Excel as being strictly for numbers. Adding pop-up pictures is a great trick to make your spreadsheets more of a sales tool.
Commands Discussed: Insert Comment; Format Comment
See all Microsoft Excel tips