How to Insert a Picture into Excel to Automatically Fit Cells

X

This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.

The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.

This article has been viewed 26,760 times.

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-728px-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-728px-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-728px-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-728px-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