How to Insert Pictures Into Excel Cells (Quick and Easy)

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

One of the frequently asked questions in Excel is how to insert a picture into a cell.

As you may know, Excel has many uses and in some cases, it would really help if you could put pictures into certain cells.

In this article, you’ll learn how to insert images into Excel cells quickly and easily. 😊

Kasper Langmann, Co-founder of Spreadsheeto

Let’s get started!

*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you can still follow the exact same steps.

Get your FREE exercise file

Before you start:

Throughout this guide, you need a data set to practice.

I’ve included one for you (for free).

Download it right below!

Download the FREE Exercise File

Download exercise file

How to insert a picture into a cell in Excel

Unlike with some other platforms, you simply can’t copy and paste a picture into an Excel cell.

But we assure you that the process isn’t difficult.

In fact, the image shown below took only 30 seconds to do.

How an inserted picture in Excel looks like

To start, follow these steps:

  • Make sure you’re on the ‘Insert’ tab
  • Click the ‘Pictures’ button found on the ‘Illustrations’ group
  • Select the picture or pictures you would like to insert
How to insert pictures into Excel cells

Depending on the size of your pictures, you may have to resize them to fit the cells. Move the pictures to the cells where you want to put them.

Kasper Langmann, Co-founder of Spreadsheeto

After resizing them to fit the cells, there’s one problem left:

Resizing the columns or rows where the images reside does not affect them.

Here’s what I mean:

How to resize images in Excel to fit in a cell

To solve that, you have to lock the pictures into the cells.

How to lock an image into a cell

For the image to resize when you resize the columns or rows, you will have to change its properties.

To do so, simply right-click on the image and select ‘Format Picture…’

How to format a picture in Excel

This will open a right-hand pane where you can change the format of the picture.

Go into the ‘Size & Properties’ tab and tick ‘Move and size with cells’ on the ‘Properties’.

How to lock pictures in Excel

That’s it! All the images are now locked into their respective cells. 😊

Wrapping things up…

As you can see, inserting pictures into Excel cells can be done quickly and easily. There’s a button for inserting pictures that’s usually not noticed by most users.

For those who knew how to insert pictures into Excel cells, the challenge is actually on making sure that the image moves and resizes with the cell. That can be achieved by locking the image into the cell.

If you’re still confused, feel free to download the exercise file. There’s already one image in there so all you need to do is supply the other two. 😊

Kasper Langmann, Co-founder of Spreadsheeto