In Microsoft Excel, adding visual elements such as company logos, instruction callouts, dashboard buttons, and charts elevates reports and user-facing models. However, by default, Excel ties the geometry of graphic objects to the cells beneath them. Whenever a user sorts a table, inserts a new row, filters records, or auto-fits column widths, floating shapes frequently warp, stretch into distorted proportions, or shift completely out of alignment. Understanding how to configure object properties and lock shapes prevents unwanted distortion and preserves clean dashboard layouts.
Understanding Object Positioning Properties in Excel
Excel categorises every inserted shape, image, chart, and icon under one of three positioning rules within its object formatting properties:
- Move and size with cells (Default): The object expands, shrinks, and travels whenever the underlying rows and columns are resized, inserted, or sorted. This causes visual stretching when adjusting column widths.
- Move but don’t size with cells: The shape relocates when rows or columns are added above or to the left of it, but its physical height and width remain locked.
- Don’t move or size with cells: The object becomes entirely anchored to its spatial coordinate on the screen. Adjusting column widths, row heights, sorting data, or filtering tables has zero effect on the object’s dimensions or position.
How to Lock a Shape or Image from Moving and Sizing
To lock the geometry and placement of an individual shape, image, or chart:
- Click the shape, image, or chart in your Excel worksheet to select it.
- Right-click the selected object and choose Format Shape (or Format Picture / Format Chart Area depending on the object type).
- In the Format Shape pane that opens on the right side of the window, click the Size & Properties icon (represented by a green square with dimension markers).
- Click to expand the Properties category.
- Select the radio button labelled Don’t move or size with cells.
- Close the formatting pane. You can now resize adjacent columns, hide rows, or filter table data without affecting the shape.
Locking Multiple Shapes Simultaneously
If your workbook dashboard contains numerous buttons, icons, and cards, modifying them individually is inefficient:
- Hold down the
Ctrlkey and click each shape you wish to configure. - Alternatively, on the Home tab, click Find & Select > Selection Pane… in the Editing group. In the Selection Pane, hold
Ctrland click all target object names in the list. - Right-click any of the selected shapes on your sheet and choose Size and Properties….
- Under the Properties section, select Don’t move or size with cells. The setting is applied across all highlighted elements in a single action.
Preventing Users from Editing or Selecting Shapes (Sheet Protection)
While “Don’t move or size with cells” protects shapes against cell manipulation, users can still click and manually drag objects around the sheet. To completely immobilise shapes against mouse dragging:
- Ensure all shapes are set to Locked:
- Select the shape and right-click to open Format Shape > Size & Properties > Properties.
- Confirm the Locked checkbox is checked.
- Unlock data entry cells: If users need to input numbers into specific cells, highlight those cells, press
Ctrl + 1, switch to the Protection tab, uncheck Locked, and click OK. - Navigate to the Review tab on the Excel ribbon.
- Click Protect Sheet.
- In the dialogue box, leave Select unlocked cells checked, but ensure Edit objects is unchecked. (Optionally enter a password).
- Click OK. Users can now enter data into unlocked cells, but all shapes, logos, and charts are completely unclickable and immovably locked in place.
Preventing Shapes from Printing
If your workbook includes navigation buttons (such as macros that jump to specific tabs) that should be visible on screen but excluded from paper printouts or PDF exports:
- Right-click the button or shape and select Format Shape.
- Navigate to Size & Properties > Properties.
- Uncheck the box labelled Print object. The button remains fully operational on screen but disappears automatically when generating prints or exporting PDF summaries.