Formatting Issues

How to Stop Excel from Rotating Pictures Placed in Cells

Muhammad Talha Oct 9, 2026 873 views

Question details

The user needs a way to prevent Excel from automatically rotating images, especially portrait-oriented ones, when inserting them directly into cells.

How to Stop Excel from Automatically Rotating Pictures Placed in Cells

Product: Excel
Device & OS: not provided
Scenario: Inserting multiple portrait images into spreadsheet cells for data tracking or visual catalogs.
Observed behavior: Excel incorrectly rotates portrait images to landscape or places them in neighboring cells when using the Place in Cell feature.

Before you start

Before importing multiple images into your workbook, check the EXIF metadata of your original photos in your file explorer, as Excel often reads this orientation data incorrectly during insertion.

Solution 1Recommended

Insert Image Over Cells and Apply Manual Rotation

The most reliable workaround for individual images is to insert the picture over the grid, correct the rotation manually, and then embed it into the cell.

While Excel's Place in Cell feature is convenient, it can misinterpret portrait layouts. By floating the image first, you regain control over its rotation before locking it into the spreadsheet grid.

Insert Over Cells

Go to the Insert tab, select Pictures, and choose to insert the image over the cells rather than directly inside a cell.

Rotate the Image

Click on the inserted image and use the circular rotation handle located at the top center of the image to rotate it to the correct portrait orientation.

Position Over the Target Cell

Drag the correctly oriented image so that it hovers directly over your intended target cell.

Place the Image in the Cell

Right-click the image to open the context menu, or use the picture formatting options, and select Place in Cell to lock the image inside the grid.

Insert Image Over Cells and Apply Manual Rotation

Neighboring Cell Placement: If the picture is accidentally placed in a neighboring cell during this process, simply select the cell containing the image, cut it (Ctrl+X), and paste it (Ctrl+V) into the correct cell.

Solution 2

Pre-process Image Orientation Before Inserting

For large batches of photos, it is much more efficient to permanently fix the orientation in the source files before importing them into Excel.

Solution 3

Use the Resize Trick to Restore Orientation

A quick community-tested workaround involves temporarily changing the image size to force Excel to recalculate its original layout.

Efficient Image Handling

Manage Spreadsheet Images Effortlessly with WPS Office

WPS Office Spreadsheet provides excellent image formatting controls, allowing you to insert, embed, and manage pictures within cells without struggling with unexpected rotation or severe file bloat.

1. Open Your Workbook: Launch WPS Spreadsheet and open the document where you need to insert your image catalog.
2. Insert the Picture: Navigate to the Insert tab on the top ribbon and click the Picture button to browse for your source files.
3. Adjust Image Properties: Select the inserted images to access the right-hand properties pane, where you can easily lock the aspect ratio, correct rotation, and align images perfectly within the grid.

Precise image placement and scaling inside spreadsheet cellsHighly compatible with Microsoft Excel (.xlsx) file formatsLightweight application that handles large image catalogs smoothlyFree to download and use for your daily office tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel automatically rotate my portrait photos sideways?

Excel reads the EXIF metadata stored in your photos by your camera or phone. If the default orientation metadata conflicts with the visual aspect ratio, Excel automatically falls back to a landscape alignment when utilizing the Place in Cell feature.

Will inserting many photos slow down my Excel workbook?

Yes, inserting dozens or hundreds of high-resolution images can significantly increase the file size, causing lag and potential crashes. It is highly recommended to compress your images or reduce their resolution before inserting them into spreadsheet cells.

Can I lock a floating image to a cell so it moves when I filter data?

Yes. If you choose not to use the Place in Cell feature, you can still link the image to a cell. Right-click the floating image, select Size and Properties, and under the Properties section, check 'Move and size with cells'. This ensures the picture stays aligned with its row during sorting and filtering.

Document & File Issues