To realize the interactive effect of the related picture of the mouse pointing to the cell in the Excel table, you can easily do it by adding a picture annotation feature to the Excel2007.
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 highlight annotations on hover. 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 Excel2007, 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.
Sub Add picture annotation ()
On Error Resume Next
For each cell in Selection
Cell. Comment.Shape.Fill.UserPicture "F: Product Diagram" & cell. Value & ". jpg"
Cell. Comment.Shape.Height = 120
Cell. Comment.Shape.Width = 200
Finally, close the VBA window and save the file as a document in the Excel macro-enabled Workbook format. Now you just 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 "Add Picture Annotation" in the list to run the macro, you can add a picture of the cell 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.