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.
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.
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 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.
Learn how to insert an image into cells in Excel or you can learn many more tricks. Learn More
Create Dynamic Graphs & Excel Presentation. Also, learn how to create Data Analytic Chart & Graph. Learn More
Steps to Insert a Picture into a Cell in Excel?
- First, open your Spreadsheet in Excel
- Select the cell into which you wish to Paste the Picture
- Go to the Insert tab
- Click on the Pictures in the illustrations Sections of the Ribbon, present at the top of the Windows
- Browse through the images you wish to add to your Data sheet
- Select those images & Click on Insert
- Re-size the picture/image in the cell manually so it can fit perfectly within the
- 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 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:
- In the Insert Tab, select Online Pictures
- 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:
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.
- 250+ Excel Formula & Excel Function List
- How to become 4x Faster at Excel
- How to remove password from Excel
- Learn Advanced Excel Courses for $99
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 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. Want more tips & tricks of basic & advanced excel? then join our Online Excel Ninja Course
Wish to Download the Example File? Do it now.
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