How to Automatically Change All Pictures to Move and Size with Cells in Excel?

It is not very frequently that we are required to manipulate photographs or images within Excel, yet, judging by the volume of Google searches for this issue, it is evident that people are interested in learning more about how to do so. When you try to insert an image in Excel, you may have noticed that the image will not align with the cells in Excel. This tutorial will help you understand how we can automatically change all pictures to move and resize within cells in Excel.

Automatically Change All Pictures to Move and Size with Cells

Here, we will first create a VBA module and then run it to complete our task. Let's take a look at an easy way to change the size and position of all images in Excel using cells. We will be using the help of a VB.NET application to complete our process, as this cannot be done directly in Excel.

Step 1

Let us consider an Excel sheet where the sheet contains the set of images shown in the below image.

Now, to open the VBA application, right-click on the sheet name and select View Code. Then click on Insert, select Module, and enter the below-mentioned programme into the text box as shown in the below image.

Example

Sub MoveAndSizeWithCells()
   'Updated By Nirmal
   Dim xPic As Picture
   On Error Resume Next
   Application.ScreenUpdating = False
   For Each xPic In ActiveSheet.Pictures
      xPic.Placement = xlMoveAndSize
   Next
   Application.ScreenUpdating = True
End Sub

Step 2

Now save the sheet as a macro-enabled workbook and press F5 to run the code and auto-arrange the pictures as shown in the below image. From now on, when you increase the size of the cell, the image will be enlarged automatically.

Conclusion

In this tutorial, we used a simple example to demonstrate how we can automatically change all pictures to move and enlarge within cells in Excel.

Updated on: 10-Jan-2023

554 Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements