How to Lock Image in Excel Cell (2 Methods)

Get FREE Advanced Excel Exercises with Solutions!

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.

lock image in excel cell


How to Lock Image in Excel Cell: 2 Methods

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.

STEPS:

  • First, go to Insert ➤ Illustrations ➤ Pictures ➤ This Device.

  • Consequently, the Insert Picture window will pop out. Select the picture you want and press Insert.

Lock Image in Cell with Excel Format Picture Feature

  • 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.

Lock Image in Cell with Excel Format Picture Feature

  • 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.

Lock Image in Cell with Excel Format Picture Feature

  • 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.

Lock Image in Cell with Excel Format Picture Feature

Read More: How to Link Picture to Cell Value in Excel


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.

STEPS:

  • Firstly, select the picture. Then, right-click on the mouse.
  • Next, select Size and Properties.

Use Size and Properties Feature to Lock Image in Excel Cell

  • 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.

Use Size and Properties Feature to Lock Image in Excel Cell

  • 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: How to Insert Image in Excel Cell as Attachment


Download Practice Workbook

Download the following workbook to practice by yourself.


Conclusion

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.


Related Articles


<< Go Back to Excel Insert Pictures | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Aung Shine
Aung Shine

Aung Shine completed his bachelor’s in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. It has been almost 2 years since he joined SOFTEKO and actively working on the ExcelDemy project. Currently he works as a Team Leader where he guides his team members to create technical content. He has published 150+ articles and reviewed 50+ articles. He has also solved various user problems before. He has interests in Data Analysis, Power Query, Advanced Excel,... Read Full Bio

2 Comments
  1. 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.

  2. Hello Kane,

    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.

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo