Show pictures when Excel table clicks

Sometimes, in order to make a large and concise table, we need to add a hidden picture for the cells in the Excel table, and when the mouse points to the cell, it automatically shows the picture, moving away does not show, this mouse touch effect is not very cool?

To realize the interactive effect of the related picture when the mouse points to the cell in the Excel table, you can easily do it by adding a picture annotation feature in Excel 2007.

Below, we take the product list as an example to show the specific method of adding pictures.

mouse pointer to cell, automatically show preset picture

Single Add picture

Right-click the target cell, select Add annotation, delete all text in the annotation entry box, then move the mouse to the edge of the annotation input box, and when the pointer becomes a cross arrow, right-click to select "Format annotation" → "Color and line" → "fill effect" → "picture", and then click "Select Picture" to add a picture.

Now the mouse pointer to the target cell to display the picture, remove the mouse picture will be automatically hidden. If the picture does not automatically disappear when the mouse is moved, you can click Office in the upper-left corner of the Excel window, click Excel Options in the menu that pops up, select advanced on the left side of the Excel Options window, select Show only markers on the right, and add annotations on hover (Figure 2), The picture can be automatically hidden after the confirmation.

Bulk Add pictures

If you have many cells to add a picture annotation, setting it up is cumbersome. We can set up picture annotations by macro batch.

First of all need to use the picture file into a folder (for example: F: Product map), each picture name must be the corresponding product name in the table, with "product name. jpg" such as the format named, such as Ang Vx545hd.jpg, Ang vx757.jpg and so on. In addition, all pictures should be in the same height ratio to ensure that the pictures displayed after the uniform settings are not distorted.

Then, open the workbook in Excel 2007, press the key combination "Alt+f8" to open the Macro window, enter the macro name "Add Picture annotation", click the Create button, and edit the code in the Open VBA window.