Formatting Issues

How to Insert Pictures at a Predetermined Size in WPS Office Spreadsheets

Rana GarciaRana Garcia Nov 13, 2026 870 views

Question details

The user wants to insert spreadsheet pictures at an exact, predetermined size instead of manually resizing an oversized image.

How to Insert Pictures at a Predetermined Size in WPS Office Spreadsheets
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

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.

Solution 1Recommended

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.

1
Open the Insert Picture dialog

In WPS Office Spreadsheets, open your workbook and click Insert > Pictures on the ribbon.

2
Select and insert the image

Choose the picture from your computer or network location, then click Open or Insert.

3
Enter exact height and width

With the picture selected, open the Picture Format tab, locate the Size group, and type the desired values into the Height and Width boxes.

4
Confirm the resized picture

Press Enter or click outside the picture to apply the new dimensions. Use the cropping or position tools if needed.

Set Exact Picture Dimensions with the Picture Format Tab
Picture resized to a predetermined size: The selected image is now set to the exact height and width you specified without dragging the corner handles.

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. 1. Open or create a workbook: Launch WPS Office Spreadsheets and open an existing workbook or create a new spreadsheet.
  2. 2. Insert a picture: Click Insert > Pictures, choose the image file, and click Open or Insert.
  3. 3. Set a predetermined size: Select the picture, go to the Picture Format tab, and enter the exact Height and Width under Size.
  4. 4. Save in Excel format: Click Menu > Save As and choose Excel Workbook (*.xlsx) to preserve compatibility with Microsoft Excel.
Insert and precisely resize pictures with familiar ribbon size controlsUse the IMAGE function where supported to place images in cellsFull Microsoft Excel .xlsx format compatibilityFree to download and use with a familiar Office-style interface
microsoft office alternative - wps office

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.