Chart & Visualization Issues

How to Keep Excel Labels and Images Aligned When Zooming or Sorting

Olivia Miller Oct 21, 2026 868 views

Question details

Find a reliable way to keep grade labels, images, and other visual elements perfectly aligned with their corresponding Excel rows when zooming in or sorting table data.

How to Keep Labels and Images Aligned When Zooming or Sorting in Excel

Product: Excel
Device & OS: not provided
Scenario: A user is sorting table rows or adjusting the worksheet zoom level, but the images and labels are placed as floating objects over the grid.
Observed behavior: Floating visual elements detach from their intended rows and become misaligned when the worksheet zoom level is changed or the table data is sorted.

Before you start

Verify that your images fit entirely inside their respective cell boundaries before attempting to lock their properties, as objects overlapping multiple cells may still behave unpredictably during sorting.

Solution 1Recommended

Lock Object Properties to Move and Size with Cells

Change the properties of floating images and labels so they are anchored to the cells underneath them, ensuring they move alongside the data during sorting.

By default, Excel often sets inserted objects to 'Move but don't size with cells' or 'Don't move or size with cells'. This causes images to float independently when table rows are rearranged. Adjusting this property binds the object directly to the cell layout.

Select the visual elements

Click on the image or label you want to lock. To select multiple objects at once, hold down the Ctrl key while clicking each item.

Open the Size and Properties pane

Right-click the selected object(s) and choose 'Size and Properties' from the context menu.

Adjust the object positioning

In the Format Picture pane, expand the 'Properties' section and select the 'Move and size with cells' option.

Test the alignment

Sort your table data by a different column or change the zoom level to confirm the images remain locked to their corresponding rows.

Lock Object Properties to Move and Size with Cells

Sizing Requirement: Ensure the image is resized to fit completely within the borders of a single cell for this feature to work flawlessly during sorting.

Solution 2

Embed Images Using the IMAGE Function

Use a formula to insert an image directly inside a cell from a URL, turning the image into an actual cell value rather than a floating object.

Seamless Image Management

Easily Lock Images to Cells with WPS Spreadsheet

WPS Office provides highly intuitive tools to format, insert, and anchor images within your spreadsheets. You can easily lock labels and pictures to specific cells, ensuring your visual elements never get misaligned when organizing or scaling your data.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open the spreadsheet containing your table and images.
2. Insert your images: Navigate to the 'Insert' tab and select 'Picture' to place your images over the desired rows.
3. Resize to fit the cell: Drag the corners of the image so that it fits entirely within the borders of its corresponding cell.
4. Access Object Properties: Right-click the image, click 'Format Object', and navigate to the 'Properties' tab in the right-hand panel.
5. Lock the image: Check 'Move and size with cells'. You can now sort your rows or adjust the zoom level without disrupting your layout.

Intuitive right-click menu to instantly lock images to cellsFully compatible with Microsoft Excel formats (.xlsx, .xls)Lightweight, fast performance even with image-heavy tablesFree and user-friendly alternative for everyday spreadsheet tasks

microsoft office alternative - wps office

Frequently Asked Questions

Why do images shift when I zoom in or out in my spreadsheet?

When objects are set to float over the grid instead of being anchored, rendering differences between zoom levels can cause their relative positions to shift. Setting the property to 'Move and size with cells' forces the application to scale the image proportionally with the cell grid.

Can I lock multiple images to their cells at the same time?

Yes. Hold down the Ctrl key (or Cmd on Mac) and click each image to select them simultaneously. Then, right-click any selected image, go to 'Size and Properties', and choose 'Move and size with cells' to apply the setting to all of them at once.

Does the IMAGE function work with local files stored on my computer?

No, the standard Excel IMAGE function is designed to work with valid, accessible web URLs starting with https://. If you need to use local files, you must manually insert them into the worksheet and use the object properties menu to anchor them to the cells.

Excel & Data Problems