How to Lock Image in Excel Cell (2 Methods)

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


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.

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 Insert an Image into a Cell with Excel VBA (2 Methods)


Similar Readings


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: Insert Pictures in Excel Automatically Size to Fit Cells


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

Aung

Aung

I'm Aung. Recently I've earned my B.Sc. Degree in Electrical and Electronic Engineering. From now on, I will be working in Microsoft Excel and other useful software, and I’ll upload articles related to them. My current goal is to write technical contents for anybody and everybody that will make the learning process of new software and features a happy journey.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo