By default, images in Excel float on the worksheet. This means that you can move it freely, but you can't fix the image within a specific cell. In this guide, we’re going to show you how to insert picture into cell in Excel.
Before start
Let's start by inserting a picture.
- Select the cell where you want to insert your picture (this is optional).
- Activate the Insert tab in the Ribbon.
- Click Pictures in the Illustrations group and select the approach you want for inserting your picture.
If you followed the steps above, including the first step, Excel will snap your picture to the top left corner of the selected cell.
How to fit picture into cell
You can simply resize the picture by holding and dragging the circles on the image border area. Activate Snap to Grid to resize the image by referencing cell borders. You can find this option under Align options in the contextual picture tab. You should select an image to see this tab.
The following example demonstrates resizing the image, first without using Snap to Grid, and then with Snap to Grid. You can see that Excel doesn't allow the image to be sized smaller than target cell.
Once you've inserted a picture into the cell, let's now take a look at how the picture behaves with the cell.
- Right-click on the picture and select Format Picture.
- Open Size & Properties
- You will see 3 options under Properties. Select either Move and size with cells or Move but don't size with cells options to ensure that picture stays in the cells.
Now that can insert picture into cell, let's review the difference between the two options: