Slider

How to Lock Inserted Pictures to Excel Cells

Date:2019-10-7 Author:Cordelia

When you use Excel to make a products list or personnel information table, inserting pictures can make it more informative. But if the inserted pictures can’t be locked to the cells, they’ll stay the same even when you make changes to the cells, which is quite frustrating. So, can we just lock the images to the cells so that they can be moved or resized together?

Luckily you can do it very simply with the Size and Properties. Let’s see the steps:

1. First, inserting a picture to the Excel file, of course.

How to Lock Inserted Pictures to Excel Cells

2. Place it around the cell. Hold your [Alt] key while dragging the four edges of the picture to make it fit the cells quickly.

How to Lock Inserted Pictures to Excel Cells

3. Right-click the image and choose Size and Properties… in the menu.

How to Lock Inserted Pictures to Excel Cells

4. It will enable the Format Picture panel on the right. Clicks Properties to expand the menu.

How to Lock Inserted Pictures to Excel Cells

5. Check Move and size with cells, or Move but don’t size with cells if needed.

How to Lock Inserted Pictures to Excel Cells

6. Then you can have a try on changing the column width or row height. The picture will also be moved or resized accordingly.

If you find our content useful, donations are always welcom. we'll keep going and hold more giveaways in the future.

Windows 10: Run Troubleshooter to Fix Network Connection Problems
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *