Insert a Picture into a Cell in Excel

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

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.

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.

Excel VBA Tutorial Course Online

Excel VBA Course (Beginner To Advanced)

If you want to be a master at Excel VBA Programming language for Excel 2007, then our Excel VBA macros tutorials will make it easier for you to access it in applications such as Microsoft Office. Come create your own Macros and rule in excel.

How can you Insert and filter the picture in Excel?

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

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

Well, here you can see the logos of the Popular Companies. Dominos, Starbucks, Pizza Hut etc. Now, whenever you’ll be applying 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 with 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’.

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

Recommended Courses

Learn how to insert image into cells in Excel or you can learn such more tricks. Learn More

Create Dynamic Graphs & Excel Presentation. Also, Learn how to create Data Analytic Chart & Graph. Learn More

Testimonial by spreadsheet guru

Steps to Insert a Picture into a Cell in Excel?

  1. First, open your Spreadsheet in Excel
  2. Select the cell into which you wish to Paste the Picture
  3. Go to the Insert tab
  4. Click on the Pictures in the illustrations Sections of the Ribbon, present at the top of the Windows
  5. Browse through the images you wish to add to your Data sheet
  6. Select those images & Click on Insert
    Go to Insert Tab Select Pictureselect the images you want to insert
  7. Re-size the picture/image in the cell manually so it can fit perfectly within theAdjust Height and Width of the image in the cell
  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.

In the Recent versions of Excel, insert picture in Excel Cell 2013, insert 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:

  • In the Insert Tab, select Online Pictures
    Select image and click Insert
  • Select the image that you liked best
  • Click Insert
  • Select few images and in one click you’ll find them on your Excel Sheet.
  • 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.

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.

Recommend

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.

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

Select Format Picture by right-clicking on the Picture

Click on format cell to lock picture

  • 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

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.

Wish to Download the Example File? Do it now.

Downlaods

This is one of the most helpful tricks when you’ve got a list of products, backed up with their images. You wish to filter and arrange these Categories by their names and along with their Product images. The same trick can be applied while you’re working on Creating effective Dashboards.

Uploaded an amazing blog on degree symbol in Excel last week. Don’t give it a miss.

Click on the link and check it out now: CLICK HERE

Related Tutorials

How to use AVERAGEIFS FUNCTION in Excel
December 10, 2018
How to use AVERAGEIF FUNCTION
December 10, 2018
How to use ABS Function in Excel
December 10, 2018
How to use AND Function in Excel
December 10, 2018
Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Split Cells in Excel using Text to Column
June 7, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018
5 Powerful Tricks to Format cells in Excel
May 31, 2018
What is ISFORMULA Function and FORMULATEXT Function
May 21, 2018
How to Use SUBSTITUTE Function
May 21, 2018