ExcelTutorials

Insert a Picture into a Cell in Excel

4 Mins read

Supposedly, you wish to fit in the logos of the Companies in your Excel Sheet. How are you going to do this? You need to know, how to insert a Picture into a Cell in Excel. To show pictures in the adjacent cell or any other cell, instructed in a column you must know how to insert an image in Excel Cell.

Excel Vlookup formula – Picture Guidebook

Excel Vlookup Formula

Bored of downloading text heavy / copy-pasted eBooks?

If Yes, you will enjoy this picture-based guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.

Learn how to insert a Picture into a Cell in Excel?

Now imagine, you’ve written the name of the Companies and you wish to add its logo in the adjacent cell. When the logo is added in the cell adjacent to its name. This is to be locked in a way that when you resize the cell, the logo should also resize.

You even want to filter the Logos as and when you filter the name of the Companies.

How can you Insert and filter the picture in Excel?

It is easy to insert a picture into Excel in a way that allows you to move, resize, and filter the Cell. As you do this the picture will automatically move.

For instance, have a look at the example given below:

Well, here you can see the logos of Popular Companies. Dominos, Starbucks, Pizza Hut, etc. Now, whenever you’ll be applying a filter to these cells the logos will automatically get filtered.

Filter picture in Excel

This tutorial will be very helpful for you if your task is centered on Products/SKUs and the images.

Problem: You’ll get stuck once you add an image in Excel. This image isn’t linked to the cells and wouldn’t move, hide, filter, or resize with the cells.

Solution: This tutorial will show you how to move, hide, filter, and resize an image in Excel’.

  • The first step, Insert a Picture into a Cell in Excel
  • The second step, lock the Picture in the cell so it becomes easy for it to move, resize, and filter along with the cells.

Steps to Insert a Picture into a Cell in Excel?

Step 1: First, open your Spreadsheet in Excel

Step 2: Select the cell into which you wish to Paste the Picture

Step 3: Go to the Insert tab

Step 4: Click on the Pictures in the illustrations Sections of the Ribbon, present at the top of the Windows

Step 5: Browse through the images you wish to add to your Datasheet

Step 6: Select those images & Click on Insert

Go to Insert Tab Select Picture
select the images you want to insert

Step 7: Re-size the picture/image in the cell manually so it can fit perfectly within the

Adjust Height and Width of the image in the cell

Step 8: Place the picture in the cell.

Important: There is an interesting way to do this. Press the ALT key, drag and move the picture with the mouse. When the Picture will come close to the Border, it will automatically snap and arrange itself.

Excel Vlookup formula – Picture Guidebook

Excel Vlookup Formula

Bored of downloading text heavy / copy-pasted eBooks?

If Yes, you will enjoy this picture-based guidebook on ‘Excel Vlookup Formulas’ – VLOOKUP, HLOOKUP, MATCH & INDEX.

In the recent versions of Excel, insert a picture in Excel Cell 2013, insert a picture in Excel Cell 2016. You get to add images from the Web-pages with the help of the Bing Image Search. This will let you insert an image in Excel. Let’s look at the steps:

  • Step 1: In the Insert Tab, select Online Pictures
Select image and click Insert
  • Step 2: Select the image that you liked best
  • Step 3: Click Insert
  • Step 4: Select a few images and in one click you’ll find them on your Excel Sheet.
  • Step 5: Click on the picture in the search results that you’d like the best to select, and then click Insert. You can also select a few images and have them inserted in your Excel sheet in one go:

Note: While you insert images from Online make sure that the images are not having the Copyright and you can use these images legally.

You can even select multiple images at once. You just have to select and enter all the images at once.

15 Excel Data Cleaning Tricks Guidebook

Bored of downloading text heavy / copy-pasted eBooks? If Yes, you will enjoy this guidebook (43 pages) 

Insert Multiple images into Excel

Select and drag the edges to resize the images. To keep the ratio of the images intact, use the corner of the images to resize it. When you want to insert a logo or any product image, it is advisable to keep the aspect ratio of the image.

If an image is added in a cell, following the above-mentioned steps. The image will not stick into the cell, the size of the image will not change when you resize the cell. Also, you won’t be able to apply Filter or hide the cells. If you want your picture to stick to a cell, you must Lock the Image in the Cell it is placed in.

How to select several images in Excel?

If you wish to select several images in Excel at a time, press and hold the ctrl key while selecting Pictures. And then, Click Insert.

select several images and insert

How to Lock image in Excel Cell?

To lock the Picture in Excel Cell, you need to follow these steps:

Learning how to lock the image in Excel Cell is very important when you’re done inserting an image in Excel Cell. After inserting an image into the Worksheet, resize it in a way it fits within a cell. Now, place the resized image in the cell. Lock the cell to ensure that it moves, filters and hides within the Cell.

Steps to Lock a Picture in an Excel Cell

Let’s look at the steps on How to Lock a Picture in an Excel Cell:

Step 1: Select Format Picture by right-clicking on the Picture

Click on format cell to lock picture

Step 2: Select Size & Properties in the Format Picture Pane. From the Options available in Properties, select ‘Move and size with cells’.

Click on Size and properties to lock images in cell

Step 3: You’re good to go now.

Note: Learning how to lock the image in Excel Cell is a very important step. If you don’t lock the picture in an Excel Cell then when you’ll try to hover or drag over your image its size will change. Excel will resize the image and your Excel Sheet will look distorted.

With this tutorial, you’ll be able to insert an image in Excel Automatically. You’ll be able to Move Cells, filter it, hide it and the picture will automatically move/filter/hide. Also, you’ll be able to insert an image in Excel Automatically.

Pivot Tables – Guidebook for Pros

15 Pivot Table tricks to make your Excel data analysis smarter! 5,600+ downloads. Most Popular Tricks are #3, #7 & #12

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…