How to Control the Excel IMAGE Function and Reduce Workbook Size
Question details
The user needs to manage workbook size and display behavior when the IMAGE function is used to display pictures from Microsoft Forms data.

- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is displaying Microsoft Forms photo responses in a workbook through the IMAGE function and wants to limit the effect on file size and performance.
- Observed behavior
- All IMAGE function results are displayed by default, which increases workbook rendering load and makes large form datasets harder to manage.
Make sure the workbook with IMAGE formulas is open in WPS Spreadsheets and identify a spare cell that can be used as the show/hide switch.
Add a control cell and wrap the IMAGE formula in an IF condition
Use this method when you want to show or hide IMAGE function images on demand and reduce the workbook display load without deleting the formulas.
The IMAGE function displays an image from a URL and does not provide the same manual compression controls as inserted pictures. Returning an empty string from the formula stops that image from being displayed until you turn the control back on.
Open WPS Office and load the Excel workbook that contains the IMAGE function formulas.
Select an empty cell such as B1, type 1, and press Enter. This cell will act as the show/hide switch.
Select the cell that contains the IMAGE formula, click the formula bar, and change it from =IMAGE(...) to =IF($B$1=1,IMAGE(...),"").
Press Enter, then change B1 to 0. The formula should return a blank result and the image should disappear; change B1 back to 1 to display it again.

Control the Excel IMAGE Function in WPS Spreadsheets
Use WPS Spreadsheets to add a show/hide control to IMAGE formulas so you can display Microsoft Forms images only when needed, reduce visual clutter, and keep the workbook easier to work with.
- 1. Install and open WPS Office: Download WPS Office, open WPS Spreadsheets, and load the Excel workbook that contains the IMAGE formulas.
- 2. Create a show/hide switch: Select a blank cell, type 1, and press Enter to use it as the image display control.
- 3. Modify the IMAGE formula: Click the first IMAGE formula cell, then wrap the formula in an IF condition: =IF($B$1=1,IMAGE(...),"").
- 4. Copy the formula to other image cells: If multiple rows use IMAGE, drag the fill handle or copy the formula down so every image responds to the same control cell.
- 5. Save and toggle as needed: Save the workbook in WPS Spreadsheets. Change the control cell to 0 to hide images or 1 to show them.

Frequently Asked Questions
Can the IMAGE function compress pictures like manually inserted images?
No. The IMAGE function displays the image from a URL and does not have the same compression controls as pictures inserted through Insert > Picture. Use a control cell or link to smaller image versions to limit the display load.
How do I hide all IMAGE function images without deleting the formulas?
Add a cell such as B1 and type 1 or 0 as a switch. Then wrap each IMAGE formula in =IF($B$1=1,IMAGE(...),""). When B1 is 0, the formula returns an empty string and the image is not displayed.
Does this method work when images come from Microsoft Forms?
Yes. As long as the IMAGE formula uses the image URL from the Forms response, the IF wrapper controls whether that URL is passed to the IMAGE function.
Will hiding IMAGE results reduce file size?
It mainly reduces visible image rendering load while the workbook is open. For file size, also review inserted pictures and other linked objects, because the IMAGE function itself does not have compression controls.
Can I use a different control value instead of 1 and 0?
Yes. You can use TRUE/FALSE, text such as "Show" or "Hide", or a data validation list, and update the IF condition to match the control value.




