Chart & Visualization Issues

How to Show Pictures When Hovering Over Cells in Excel

Adam DavisAdam Davis Nov 3, 2026 874 views

Question details

The user wants to display specific reference images dynamically when hovering over or selecting a cell, rather than keeping all images permanently visible on the spreadsheet.

How to Show Pictures When Hovering Over or Selecting Cells in Excel
Product
Excel
Device & OS
not provided
Scenario
Creating a clean spreadsheet, such as a plant catalog, where images are kept hidden to avoid clutter and only appear when interacting with a specific row.
Observed behavior
The goal is to trigger the image display selectively based on mouse hover or cell selection.
Before you start

Ensure your images are saved locally on your computer and appropriately compressed, as embedding multiple large images can significantly increase your spreadsheet file size.

Solution 1Recommended

Insert Pictures into Cell Notes (Hover Effect)

The easiest method without using macros or code is to format an Excel Note's background with your desired image. This creates a pop-up effect when you hover over the cell.

This built-in feature keeps your spreadsheet clean. By hiding the note by default, the image will only appear when your cursor hovers over the cell containing the red note indicator.

1
Insert a New Note

Right-click the target cell and select 'New Note' (or 'Insert Comment' in older versions of Excel). Delete any default text inside the box.

2
Access Format Options

Right-click the exact border of the note box (not inside the text area) and select 'Format Comment' from the context menu.

3
Navigate to Fill Effects

In the Format Comment dialog box, go to the 'Colors and Lines' tab. Click the 'Color' dropdown under the Fill section, and choose 'Fill Effects'.

4
Select Your Image

Go to the 'Picture' tab within the Fill Effects window, click 'Select Picture', browse your computer to find the image, and click 'Insert'.

5
Confirm and Test

Click 'OK' twice to apply the settings. Deselect the cell to hide the note, then hover your mouse over the cell to see the image pop up.

Insert Pictures into Cell Notes (Hover Effect)
Adjustment Tip: You can resize the pop-up image by right-clicking the cell, selecting 'Edit Note', and dragging the sizing handles on the corners of the note box.
Efficient Spreadsheet Management

Create Dynamic Hover Images easily with WPS Spreadsheet

WPS Spreadsheet allows you to intuitively insert background pictures into cell comments, keeping your catalogs and data lists clean and interactive. It offers full compatibility with Microsoft Excel formats in a lightweight package.

  1. 1. Insert a Comment: Open your spreadsheet in WPS Office, right-click the target cell, and select 'Insert Comment'.
  2. 2. Access Fill Effects: Right-click the comment border, choose 'Format Comment', navigate to 'Colors and Lines', and select 'Fill Effects' from the Color dropdown.
  3. 3. Upload the Picture: Switch to the 'Picture' tab, click 'Select Picture', upload your desired image, and click 'OK' to apply the hover effect.
Easily format cell comments with background images for interactive hover effects.Fully compatible with Microsoft Excel (.xlsx) files and features.Lightweight software that handles large sheets with multiple images smoothly.Free and user-friendly interface for effortless data visualization.
microsoft office alternative - wps office

Frequently Asked Questions

Can I resize the picture that appears when hovering over a cell?

Yes. When you are in editing mode for the comment or note (Right-click > Edit Note), you can click and drag the sizing handles on the corners or edges of the box to adjust the dimensions of the displayed image.

Why is the picture not showing when I hover over the cell?

Ensure that comments or notes are not set to 'Show All' in your spreadsheet settings. The note must be hidden by default for the hover effect to work. Check the 'Review' tab and ensure 'Show All Comments' is toggled off.

Is it possible to add hover pictures to hundreds of rows automatically?

Doing this manually for hundreds of rows is time-consuming. For large datasets, you can use VBA (Visual Basic for Applications) macros to loop through a column of file paths and automatically insert the corresponding images into cell notes.

Will adding pictures to comments increase my Excel file size?

Yes, embedding multiple high-resolution pictures into cell comments will increase the file size. To prevent performance issues, it is highly recommended to compress and resize your images before inserting them into the spreadsheet.