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 – Guidebook
Bored of downloading text heavy / copy-pasted eBooks?
If Yes, you will enjoy this 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.
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
Step 7: Re-size the picture/image in the cell manually so it can fit perfectly within the
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 – Guidebook
Bored of downloading text heavy / copy-pasted eBooks?
If Yes, you will enjoy this 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
- 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.
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
Step 2: Select Size & Properties in the Format Picture Pane. From the Options available in Properties, select ‘Move and size with cells’.
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.
15 Pivot Tables Tricks for Pros
15 Pivot Table tricks to make your Excel data analysis smarter! 5,600+ downloads.
Most Popular Tricks are #3, #7 & #12