Prevent Images and Shapes from Resizing or Moving in Excel

Add to Favorites
Author: | Edits: don

How to stop Images and Shapes from resizing in Excel when you change the size of rows and columns.

This will allow you to keep the dimensions of your images and shapes while allowing them to move with the spreadsheet when you change its size, or to freeze them in place.

Steps to Prevent Images and Shapes from Changing Size or Moving

  1. Right-click the image or shape and then click Size and Properties...
    73f2e76a43ee2e3e751fedbeae22c1c9.jpg
  2. In the window that opens, go to the Properties section from the left hand menu. Then look to the top of the window.
    Select one of these two options:
    Move but don't size with cells: the items will NOT be resized but they will move in the spreadsheet when you change column and row sizes.
    Don't move or size with cells: the items will essentially freeze within the spreadsheet and will not move or resize unless you specifically resize or move them using the mouse.
    c59c7480f54df9888c489e0bf3203540.jpg
  3. Hit close and that's it!

Before we selected the option not to resize, we could have ended up with a spreadsheet that looked like this when we went to resize columns and rows:

c22d963663a357a0b21bb5f721034d19.jpg

Notes

This is a simple but important tip to keep in mind when you are building your spreadsheets, especially when they get large and complex.

It is easy to forget to select these options for images in the spreadsheet but it is very important because when you resize a column or row it can mess-up an image or shape that is not currently visible.

Download the workbook attached to this tutorial to test this out in Excel.


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
5 Simple Tips for Making BETTER Macros in Excel!
Tutorial: 5 ways to make better Macros in Excel - fewer errors, smoother coding, less fuss! These 5...
Filter Data to Display the Results that Begin With Specified Text or Words in Excel - AutoFilter
Macro: This Excel macro automatically filters a set of data based on the words or text that are c...
Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter
Macro: Extract whole words from a cell or sentence in Excel with this UDF. This allows you to spe...
Filter Data to Show the Top 10 Items from a Data Set in Excel - AutoFilter
Macro: This Excel macro filters data in Excel in order to display the top 10 items from the data ...
Sort Data Alphabetically or Numerically in Excel 2007 and Later
Tutorial: This Excel tip shows you how to Sort Data Alphabetically and Numerically in Excel 2007. T...
Copy and Paste Data using Macro VBA in Excel
Tutorial: How to copy and paste data using a Macro in Excel. I'll show you multiple ways to do this,...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course