Use Excel picture annotation function to do mouse touch picture display

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.

Code fragment: Sub Add picture annotation () Dim cell On Error Resume Next For each cell in Selection Cell. AddComment Cell. Comment.Shape.Fill.UserPicture "F: Product Diagram" & cell. Value & ". jpg" Cell. Comment.Shape.Height = 120 Cell. Comment.Shape.Width = 200 Next cell End Sub

Finally, close the VBA window and save the file as a document in the Excel macro-enabled Workbook format. Now all you have to do is select all the cells you want to set, such as A4:A20, press the key combination "Alt+f8" to open the Macro window, double-click the Add picture annotation in the list to run the macro (Figure 3), and you can add pictures to the cells in batches.

(Note: The picture is saved directly in the workbook after it is set up). If the product name in the table has changed, or the picture file used for the annotation has been replaced, you can just run the "Add Picture annotation" macro to refresh.