Sometimes, we may need to insert images in our Excel worksheet to visualize the products or services. But, when we move or resize the cell ranges, the images associated with it don’t get changed. It is necessary to lock the images so that the changes affect them too. In this article, we’ll show you the effective ways to Lock an Image in an Excel Cell.
To illustrate, we’re going to use a sample dataset as an example. For instance, the following dataset represents the ID, Product, and Images of the products.
Download Practice Workbook
Download the following workbook to practice by yourself.
2 Methods to Lock Image in Excel Cell
1. Lock Image in Cell with Excel Format Picture Feature
Excel provides numerous Features and we use them to perform various operations. In our first method, we’ll use the ‘Format Picture’ feature. This feature helps us to edit the inserted picture and we can make as many changes as we want. But first, we’ll show you how to Insert the picture. Therefore, follow the steps below to Insert and Lock the Image in Excel Cell with the ‘Format Picture’ feature.
- First, go to Insert ➤ Illustrations ➤ Pictures ➤ This Device.
- Consequently, the Insert Picture window will pop out. Select the picture you want and press Insert.
- Now, resize the picture to fit it in the destination cell.
- Next, repeat the process to add other images as well.
- Again, select the picture and right-click on the mouse.
- Then, select Format Picture.
- As a result, the Format Picture pane will open up on the right side of the worksheet.
- After that, under the Size & Properties tab, select Properties. There, check the circle for Move and size with cells.
- Now, select other pictures as well and check the circle.
- Next, close the Format Picture pane.
- To see the changes, move row 5 to the 10th row.
- Finally, you’ll see the contents of the 5th row now in the 10th row including the picture.
Read More: How to Insert an Image into a Cell with Excel VBA (2 Methods)
2. Use Size and Properties Feature to Lock Image in Excel Cell
In the previous method, we accessed the ‘Size & Properties’ through the ‘Format Picture’ feature. But here, we’ll access it directly. So, follow the below procedure to perform the task.
- Firstly, select the picture. Then, right-click on the mouse.
- Next, select Size and Properties.
- Consequently, the Format Picture pane will appear on the right side of the worksheet.
- Afterward, check the circle for Move and size with cells from the Properties.
- Subsequently, select other pictures and check the circle for them too.
- After that, close the pane. To observe the changes, move any row. In this example, move the 7th row.
- Eventually, you’ll see the cell contents of the 7th row including the picture in the 10th row.
- But, if we didn’t check the circle for Move and size with cells, the picture would remain where it was. The following picture shows the proof.
Read More: Insert Pictures in Excel Automatically Size to Fit Cells
Henceforth, you will be able to Lock an Image in Excel Cell with the above-described methods. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.
I clicked the “Move and size with cells” circle but when I went to sort my data by a particular column the pictures didnt move with the data. In the Properties menu I have move and size checked and print object checked but nothing else. Please advise.
You need to put the picture in one cell. Just resize it and put the image in a single cell then apply the sorting. I think you will get your desired result.
1. First, change the row height of the cell to adjust the image in the cell or resize it to adjust it in a single cell.
2. Then, select the range of cells. Go to the Data tab and select your preferred sorting.
3. Finally, you will see the image is also changing its place while sorting.