How to Insert Pictures at a Predetermined Size in WPS Office Spreadsheets
Question details
The user wants to insert spreadsheet pictures at an exact, predetermined size instead of manually resizing an oversized image.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is adding images to a WPS Spreadsheets workbook and needs precise image dimensions for layout or reporting.
- Observed behavior
- Inserted pictures may initially appear very large and require manual resizing, but size controls and the IMAGE function can define dimensions.
Before you start, confirm whether your WPS Office version supports the IMAGE function if you plan to place pictures inside cells, and have the image file path or URL ready.
Set Exact Picture Dimensions with the Picture Format Tab
Use this after inserting a picture when you need precise height and width control instead of manual dragging.
Inserted pictures may inherit their original pixel dimensions or large default scaling, which makes them appear oversized. The Picture Format tab exposes numeric Height and Width fields so you can set a predetermined size exactly.
In WPS Office Spreadsheets, open your workbook and click Insert > Pictures on the ribbon.
Choose the picture from your computer or network location, then click Open or Insert.
With the picture selected, open the Picture Format tab, locate the Size group, and type the desired values into the Height and Width boxes.
Press Enter or click outside the picture to apply the new dimensions. Use the cropping or position tools if needed.

Use the IMAGE Function to Display a Picture in a Cell with Fixed Dimensions
Use this method when your version supports the IMAGE function and you want the image stored inside a cell with controlled sizing.
Set Picture Dimensions in WPS Office Spreadsheets
Use WPS Office Spreadsheets to insert an image, enter exact height and width on the Picture Format tab, and save the workbook as a standard .xlsx file for Microsoft Excel compatibility.
- 1. Open or create a workbook: Launch WPS Office Spreadsheets and open an existing workbook or create a new spreadsheet.
- 2. Insert a picture: Click Insert > Pictures, choose the image file, and click Open or Insert.
- 3. Set a predetermined size: Select the picture, go to the Picture Format tab, and enter the exact Height and Width under Size.
- 4. Save in Excel format: Click Menu > Save As and choose Excel Workbook (*.xlsx) to preserve compatibility with Microsoft Excel.

Frequently Asked Questions
Why does my inserted picture appear much larger than expected in WPS Spreadsheets?
The inserted image keeps its original dimensions or default scaling. Select the picture, open the Picture Format tab, and enter the desired Height and Width values in the Size group.
Can I insert a picture directly into a cell at a fixed size?
If your WPS Office version supports the IMAGE function, use =IMAGE(source,[alt_text],[sizing],[height],[width]) in the target cell. Otherwise insert it as a floating picture and resize it to match the cell.
How do I keep the aspect ratio when resizing a picture?
Use the Size group on the Picture Format tab and enable the lock aspect ratio option, or hold Shift while dragging a corner handle.
Does WPS Office save image sizing changes in Microsoft Excel files?
Yes. Save the workbook as .xlsx; the picture and its size settings are retained when the file is opened in Microsoft Excel.




