How to Insert a Picture Into a Cell in Excel 2010

While Microsoft Excel is typically used as a way to store, sort and manipulate text and numbers, it is also a helpful way to store images along with that data. For example, you might have a spreadsheet of products and SKUs that you send to customers, and including an extra column of data with an image of the product provides a simple way for them to see all of the relevant information in one place. So if you are looking for a way to insert a picture into a cell on your Excel 2010 spreadsheet, check out our tutorial below.

 

How to Add an Image to an Excel Cell

Before you follow the steps below, it’s important that you have the image on your computer already, and that you know where it is. You will need to browse to it during the tutorial.

 

Step 1: Open your spreadsheet in Excel 2010.

 

Step 2: Select the cell into which you want to paste the picture.

 

Step 3: Click the Insert tab at the top of the window.

click the insert tab

 

 

Step 4: Click the Picture button in the Illustrations section of the ribbon at the top of the window.

how to insert a picture into a cell in Excel 2010

 

 

Step 5: Browse to the picture that you want to add to your spreadsheet, select it, then click the Insert button.

browse to and select the picture

 

 

Step 6 (optional): Manually resize the cell so that the picture is contained within it. You can do this by clicking the right border of the column letter at the top of the spreadsheet, then dragging it so that the cell is wide enough for the image. You can then repeat this with the row number. Your finished cell and image will look something like the image below.

resize the row and column so that the picture fits in the cell

 

 

Have you been looking for a good Excel resource where you can learn more about using the program? The Excel 2010 Bible has excellent reviews on Amazon and covers topics ranging from beginner to advanced.

If you want to lock the image to a cell in Excel 2010, then you need to follow a couple of other steps. This will allow you to cut and paste the columns in your spreadsheet and include the picture along with the cells.

Step 1: Position the image so that it is contained entirely within the cell.

position the image within the cell

 

 

Step 2: Right-click the image, then click Size and Properties.

right click, then select size and position

 

 

Step 3: Click Properties in the column at the left side of the Format Picture window.

click the properties option

 

 

Step 4: Check the option to the left of Move and size with cells, then click the Close button.

select to move and size with cells

 

 

Do you need to add a bunch of consecutive numbers to a column? You can automatically number columns in Excel to save yourself some time and frustration.

 

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.