Formatting Issues

How to Crop Multiple Pictures to a 1:1 Aspect Ratio in Excel

Algirdas JasaitisAlgirdas Jasaitis Nov 4, 2026 869 views

Question details

The user needs to apply a 1:1 (square) aspect ratio to a large number of pictures (over 200) simultaneously in Excel.

How to Crop Multiple Pictures to a 1:1 Aspect Ratio in Excel
Product
Excel
Device & OS
not provided
Scenario
Standardizing the dimensions of hundreds of inserted images within a spreadsheet to ensure they all share an identical 1:1 square format.
Observed behavior
Excel does not offer a standard batch-crop feature to apply specific aspect ratios to multiple selected images at once, requiring manual workarounds or macros.
Before you start

Ensure all the images you intend to modify are inserted into the active worksheet. If you plan to use a VBA macro for batch cropping, save a backup copy of your workbook first, as macro actions cannot be undone.

Solution 1Recommended

Batch Resize Pictures to Exact Dimensions

While Excel cannot natively batch-crop images to a new aspect ratio, you can select multiple images and force them into a square dimension by disabling the aspect ratio lock and applying fixed measurements.

This method resizes the images into a 1:1 square. Note that if your original images are rectangular, forcing a 1:1 dimension without cropping will distort (stretch or squeeze) the pictures.

1
Select Multiple Pictures

Hold down the 'Shift' or 'Ctrl' key while clicking each picture to select them. Alternatively, press 'Ctrl + G', click 'Special', select 'Objects', and hit 'OK' to select all images in the sheet.

2
Open Size and Properties

Right-click on one of the selected images and choose 'Size and Properties' from the context menu, or navigate to the 'Picture Format' tab on the ribbon.

3
Unlock the Aspect Ratio

In the Format Picture pane under the Size section, ensure the 'Lock aspect ratio' checkbox is unchecked so you can manipulate width and height independently.

4
Apply a 1:1 Measurement

Enter the exact same value in both the 'Height' and 'Width' boxes (for example, 2 inches by 2 inches) and press Enter. All selected pictures will instantly snap to these square dimensions.

Batch Resize Pictures to Exact Dimensions
True Cropping Limitation: If avoiding image distortion is critical, you must either crop each image individually to a 1:1 ratio before resizing, or use a VBA macro to perform the crop.
Manage Images in WPS Spreadsheets

How to Batch Format Pictures in WPS Office

Handling hundreds of images in a spreadsheet can slow down your workflow. WPS Spreadsheets offers a lightweight, highly compatible environment to easily select, resize, and manage multiple objects simultaneously without lagging.

  1. 1. Open your file in WPS: Launch WPS Spreadsheets and open the .xlsx document containing your pictures.
  2. 2. Select all images: Go to the 'Home' tab, click 'Find and Replace', choose 'Select Objects', and drag a box over your images to select them all at once.
  3. 3. Access Picture Tools: Navigate to the 'Picture Tools' tab that appears on the top ribbon when your images are selected.
  4. 4. Adjust to a 1:1 Size: Uncheck 'Lock Aspect Ratio' in the size settings, then type identical values into the Height and Width boxes to apply a uniform square shape to all pictures.
Select multiple images easily using advanced object selection tools.Adjust height and width uniformly via the intuitive Picture Tools tab.Seamless compatibility with Microsoft Excel (.xlsx) formats and picture properties.Lightweight software ensures smooth performance even with 200+ images.
microsoft office alternative - wps office

Frequently Asked Questions

Can I select all pictures in Excel at once instead of clicking them one by one?

Yes. Press 'F5' to open the 'Go To' dialog box, click 'Special', select 'Objects', and click 'OK'. This will highlight all pictures, shapes, and charts on the current worksheet simultaneously.

Why does my picture stretch when I change the dimensions?

If you uncheck 'Lock aspect ratio' and change the height and width to form a square (1:1), Excel will squash or stretch the rectangular image to fit those dimensions. To prevent stretching, the image must be cropped rather than simply resized.

Are there add-ins that can batch crop pictures in Excel?

Yes, third-party add-ins like Kutools for Excel offer enhanced batch-processing features. These tools often include dedicated utilities to batch resize, crop, or export hundreds of images with just a few clicks.