How to Crop Multiple Pictures to a 1:1 Aspect Ratio in Excel
Question details
The user needs to apply a 1:1 (square) aspect ratio to a large number of pictures (over 200) simultaneously 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.
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.
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.
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.
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.
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.
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.

Use VBA Macro for Exact Square Cropping
Use a Visual Basic for Applications (VBA) script to automatically loop through all images and apply a true crop to achieve a 1:1 aspect ratio without distorting the contents.
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. Open your file in WPS: Launch WPS Spreadsheets and open the .xlsx document containing your pictures.
- 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. Access Picture Tools: Navigate to the 'Picture Tools' tab that appears on the top ribbon when your images are selected.
- 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.

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.




