How to Insert a Picture into Excel to Automatically Fit Cells

Do you want to add an image or logo to your Excel spreadsheet to make the content more visually appealing? While there’s no automatic setting to resize images inside cells, you can do it yourself with just a few clicks. This wikiHow teaches you how to insert pictures into Excel and resize them to fit cells.

Steps

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/47/12969546-1.jpg/v4-460px-12969546-1.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/4/47/12969546-1.jpg/v4-728px-12969546-1.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Open the project in Microsoft Excel. You can do this by going to File > Open right in Excel, or right-clicking on the project file and selecting Open with > Excel .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2d/12969546-2.jpg/v4-460px-12969546-2.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/2/2d/12969546-2.jpg/v4-728px-12969546-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Insert photos. To do this, go to Insert > Pictures > select a picture > Insert .

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9a/12969546-3.jpg/v4-460px-12969546-3.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/9/9a/12969546-3.jpg/v4-728px-12969546-3.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Resize. Once the image is selected, a group of “Size” options will appear below the “Format” and “Picture Tops” sections.

Change the Height and Width parameters, or drag and drop the corners on the image to adjust the size.

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d5/12969546-4.jpg/v4-460px-12969546-4.jpg”,”bigUrl”:”https:// www.wikihow.com/images/thumb/d/d5/12969546-4.jpg/v4-728px-12969546-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,” bigHeight”:546,”licensing”:”<div class=”mw-parser-output”></div>”}

Lock the photo to the box. By default, photos you’ve added will “float” to the top and won’t resize to the cells. To fix this problem, you need to lock the photo or cell.

Right-click the image and select Format Picture . Then, click the “Size & Properties” tab (the green square icon and the multi-directional arrows inside) and then select Move and size with cells . cells).

Alt + F11

Insert > Module

 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

Steps

Related Posts