How To Insert Pictures In Excel That Automatically Size To Fit Cells

Change the Height and Width to adjust the size of your image. Instead, you can drag and drop the corners of the image to re-adjust the size.

Right-click your picture and click Format Picture. Then click the “Size & Properties” tab (a symbol with a green square with arrows around it) and select Move and size with cells. You can also use a VBA code after you’ve inserted some pictures. Insert the images and press Alt + F11 to open the VBA window. Click Insert > Module and paste the following code: Public Sub FitPic() On Error GoTo NOT_SHAPE Dim PicWtoHRatio As Single Dim CellWtoHRatio As Single With Selection PicWtoHRatio = . Width / . Height End With With Selection. TopLeftCell CellWtoHRatio = . Width / . RowHeight End With Select Case PicWtoHRatio / CellWtoHRatio Case Is > 1 With Selection . Width = . TopLeftCell. Width . Height = . Width / PicWtoHRatio End With Case Else With Selection . Height = . TopLeftCell. RowHeight . Width = . Height * PicWtoHRatio End With End Select With Selection . Top = . TopLeftCell. Top . Left = . TopLeftCell. Left End With Exit Sub NOT_SHAPE: MsgBox “Select a picture before running this macro. " End Sub Press F5 to run the code and repeat this process until all the images in your sheet fit into cells.