How To Lock Down Images On Your Excel Worksheet

Until you know this setting in Excel, it is difficult to see how you can have great looking static images on your Excel sheets. Being able to lock down your images on a dashboarrd for example to prevent them moving or expanding if you add or delete text, row or columns is essential.

I apply this setting equally to any charts, headings, text boxes so they remain as I want them to, even if the surrounding sheet changes in some way.

Select your object- I say object as this can be a chart, image, text box or shape.

Format- this can be chart, shape or autoformat depending on what you are formatting

Select properties and then you need to select ‘Don’t move or size with cells’
This simple setting locks down your images, charts, shapes in a couple of clicks

Try this method if you are having issues with making your Excel worksheet images remaining static. Don’t forget you can use it on your charts, shapes, textboxes etc etc.