How to insert picture in excel cell | Complete Guide
In this article, we’ll learn how to insert pictures into excel, fit the picture in excel cell and do much more with it.
Generally we use excel for calculations & data analysis but there could be situations where you would want to insert picture in excel. For example, you work in E-commerce and you’re maintaining a database of all products and its various SKUs. You might want to add images for each product so that you can differentiate between different variants & SKUs.
Below is an example of dataset having excel pictures.
The process of adding excel images is pretty straightforward, there are essentially two main parts. One if embedding image in excel cell and other is locking the picture in cell so it can resize and filter with cells.
Insert Picture in Excel
- Go to Insert Select ‘Pictures’ option.
- A dialog box will appear. Find the images to insert into cell in Excel. Select them and click Insert
- Now under Picture Tools Format tab, you can go and resize these images first as per your requirements.
- Now we’ll place the images in excel cell. Select the image hold ALT key and move the picture with mouse. It’ll arrange itself within cell border.
You can embed excel images one by one in each cell or you can just add all images together and then place them in cells.
When resizing the images by dragging make sure you try to keep the aspect ratio intact by dragging from only the corners of the images in excel cells.
Although we have inserted pictures into excel, it will not stick with the cells in case we resize or filter cells. We need to lock images in cell first. Let’s see how to do this.
Excel Lock Picture in Cell
- Right click on the image and select Format Picture.
- Under Format Picture pane, select Size & Properties and choose ‘Move and size with cells’
Now you can move cell containing pictures in Excel and also filter, hide and do much more with it just like normal cells.
Paste Image into Excel Cell
Now let’s look at some other quick methods of pasting pictures in excel.
- Simply find the image to insert in excel, select it and copy it or press CTRL + C.
- In excel, select the cell where you’ll want to insert the image and press CTRL + V or paste it.
This is the fastest way to paste image into excel cell.
How to insert pictures into Excel Header & Footer
- Go to Insert tab, click Header & Footer.
- Select area inside header or footer where you want to insert the picture. This will take you to Design tab.
- In Design tab, under Header & Footer Elements group select Picture.
- The Insert Pictures dialog box will appear, select the picture and click insert. The text ‘&[Picture]’ will appear in header/footer box. As soon as you click anywhere else outside of the box the image will appear.
How to replace picture in Excel
To replace an existing image, right click and select Change Picture. A dialog box will appear, browse & select your new image and hit Insert.
The new updated picture will be in the same position as old one and will have same formatting options. If the previous picture was locked then this new one will be too.
How to delete picture in Excel
To delete a single picture, just select it and press Delete button on your keyboard.
To delete multiple images, press & hold CTRL to select all images and press Delete button.
Now let’s say you have a sheet containing hundreds of images. Now you can go and select each one as it’s a tedious & time taking process. Follow the below steps to make the process easier:
- Press F5 to open Go To dialog box. Select Special
- In the dialog box, check on Object option and hit OK.
- All images on excel worksheet are now selected.
You can now just press Delete button to delete them all.
Do note: That while selecting Object option, it’ll also select all objects including images, shapes, WordArt etc. So be careful when you use this option to delete objects.
That was all about how to insert pictures into Excel.
I hope this article was helpful to you and explained you how to create spreadsheet with pictures and work with excel images.
If you have any questions or tips, I’d love to hear them in the comment section below.
Advanced Excel Course
Learn Vlookup, Pivot tables, What IF, Macro Automation, Power Query and much more.
- 10+Hrs of Learning Content
- 50+ Practical Exercises
- Doubt Resolution