How to Insert Pictures in Excel That Automatically Size to Fit Cells

Download Article

Automate image sizes to fit in cells

Co-authored by Rain Kengly Reviewed by Stan Kats

Last Updated: April 21, 2025 Fact Checked

Download Article

• Using the Insert Menu
|
• Using a VBA Code
|
• Video
|
• Q&A

|Show more |Show less

Do you have an image or logo that you want to add to your Excel sheet to make it more visually appealing? You can easily use the Insert menu or a VBA formula to automatically resize your images when you add them to a cell. Here's how to insert pictures in Excel that automatically size to fit cells using your Windows or Mac computer.

Sizing Pictures to Fit Cells in Excel

To add a picture that automatically fits cells in Excel, click Insert > Pictures > Place in Cell > This Device > select a picture. If you decide to resize the cell, the picture will resize with it.

Steps

Method 1

Method 1 of 2:

Using the Insert Menu

Download Article

1. 
   1
   Click Insert. This is the tab at the top, between Home and Page Layout.
2. 
   2
   Click Pictures. You can find this in the Illustrations section.

   • If you don't see the menu, click the Illustrations icon first, or expand your Excel window.
   Advertisement
3. 
   3
   Hover over "Place in Cell". This is the option that allows pictures to follow the size of the cell.

   • You can skip this step if you are using the web browser version of Excel.
4. 
   4
   Click This Device…. Alternatively, you can select Stock Images to browse Microsoft's images or Online Pictures to search the web via Bing.

   • If you don't see this option, select Picture from File... instead.
5. 
   5
   Select a picture and click Insert. The picture will be added to the cell. It will automatically fit the current size of the cell.

   • If you change the cell size, the picture will become bigger or smaller with it.
Advertisement

Method 2

Method 2 of 2:

Using a VBA Code

Download Article

1. 
   1
   Press Alt+F11. This opens the VBA (Visual Basic for Applications) menu.

   1. If you inserted a picture and it isn't resizing automatically, you can use this code instead.
2. 
   2
   Click Insert. This is in the top toolbar.
3. 
   3
   Click Module. You can find this in the drop-down menu. A new window will open.
4. 
   4
   Copy and paste the code. Use 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
   

   1. Press F5 to run the code and repeat this process until all the images in your sheet fit into cells.
Advertisement

Community Q&A

Search

Add New Question

• Question

  When I resize a picture to a smaller cell and then restore it, I lose the detail. How can I avoid this?

  

  CJ89483

  Community Answer

  When you resize an image to a smaller size and then restore it to its original size, the image may lose some of its detail and sharpness. To avoid this, it is best to start with the original high-resolution image and use good-quality resizing software that includes bicubic interpolation. Bicubic interpolation is a resizing method that helps preserve detail and sharpness in the image. It is also important to avoid resizing the image too much and to save a copy of the original image. By following these tips, you can help ensure that your images retain their detail and quality when resized.

  Thanks! We're glad this was helpful.
  Thank you for your feedback.
  If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow

  Yes No

  Not Helpful 5 Helpful 7

Ask a Question

200 characters left

Include your email address to get a message when this question is answered.

Submit

Advertisement

Video

Tips

Submit a Tip

All tip submissions are carefully reviewed before being published

Name

Please provide your name and last initial

Submit

Thanks for submitting a tip for review!