Why Excel IMAGE Function Does Not Display a Hover Preview
Question details
The user wants to view a larger picture preview by hovering over a cell that contains the Excel IMAGE function, but the popup preview does not appear.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Inserting an image into a spreadsheet cell using the =IMAGE() formula and attempting to preview it at a larger size.
- Observed behavior
- The image successfully loads inside the cell boundaries, but no large popup or hover preview is generated when placing the mouse cursor over the cell.
Ensure that your device is connected to the internet, as the IMAGE function requires an active network connection to fetch and display pictures from external URLs.
Understand Expected Behavior and Verify the Formula
Confirm that your IMAGE formula is functioning correctly, keeping in mind that the lack of a hover preview is the intended behavior in the current release of Excel.
The popup or hover preview feature for the IMAGE function was not included in the official release of Excel and is not mentioned in the official Microsoft documentation. Because this is not a workbook error or bug, there are no settings to toggle a hover preview on.
Instead of troubleshooting a missing feature, the best approach is to verify that your formula is correctly formatted to fetch and display the image within the standard cell boundaries.
Click on the specific cell where you want the image to be displayed.
Type =IMAGE("your_image_url") into the formula bar. Ensure you replace "your_image_url" with a valid, publicly accessible HTTPS image link enclosed in quotation marks.
Press the Enter key. Wait a few moments for the application to download and render the image inside the cell.
Since hovering will not enlarge the picture, click and drag the row boundary down and the column boundary to the right to increase the cell size. The image will scale automatically.

Use WPS Spreadsheet for Better Cell Picture Management
If you are frustrated by the limitations of formula-based images, WPS Spreadsheet offers an intuitive "Insert Picture in Cell" feature. This allows you to embed local images directly into your grid without relying on URLs, making your workflow smoother and your files easier to manage.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your existing spreadsheet or create a new one.
- 2. Navigate to the Insert tab: Click on 'Insert' in the top ribbon menu, then click the 'Picture' icon.
- 3. Choose Insert Picture in Cell: Select 'Insert Picture in Cell' from the dropdown menu to ensure the image behaves as part of the grid data.
- 4. Select your local image: Browse your computer for the desired image, select it, and click 'Open'. The image will automatically embed and conform to the cell size.

Frequently Asked Questions
Can I use VBA to create an image hover preview in Excel?
Yes, advanced users can write a VBA (Visual Basic for Applications) macro to display a larger image or a UserForm when a specific cell is clicked or selected. However, this requires custom coding and cannot be achieved using the standard IMAGE function alone.
Why does my Excel IMAGE function return a #VALUE! error?
A #VALUE! error typically occurs if the provided URL is invalid, does not point directly to an image file (like .png or .jpg), or does not use the HTTPS protocol. Verify your link in a web browser to ensure it directly loads an image.
How can I make the image bigger without a hover preview?
To see the image more clearly, manually adjust the row height and column width. By default, the IMAGE function scales the picture to fit the cell while maintaining its aspect ratio, so expanding the cell will enlarge the image.
Does WPS Office support the IMAGE function?
WPS Spreadsheet continually updates its function library to maintain high compatibility with modern spreadsheet features. For the most robust experience with images, users can also utilize WPS Office's native 'Insert Picture to Cell' functionality for local files.




