How to Insert Image in Excel Cell (Correctly)

How to Insert Image in Excel Cell

In this tutorial, you’ll learn how to insert an image in an Excel cell, in the right way. Each image inserted in the Excel sheet will be placed nice and neat within its target cell. In addition, we’ll learn to set the right formatting, so that the image could move and change size along with the cell. This comes quite handy when you need to hide or filter rows or you’re planning some further operations with the row or cell that contains the inserted the image.

Sounds like there’s a lot ahead of us, so let’s start!

See the video tutorial and transcription below:

See this video on YouTube:
https://www.youtube.com/watch?v=_lv7r8JVxW8

To insert an image into a spreadsheet, go to the tab ‘Insert’, then, in the section ‘Illustrations’, select ‘Pictures’.

How to Insert Image in Excel Cell

This pop-up window appears where you can browse and select pictures from your computer. You can choose one or more pictures at once and insert them into the spreadsheet area through the ‘Insert’ button.

How to Insert Image in Excel Cell - select pictures you want to insert

Click anywhere into the blank part of the worksheet area and then on the picture again. The inserted image can now be moved or resized using these little circles on its sides.

How to Insert Image in Excel Cell - inserting image into Excel
How to Insert Image in Excel Cell - how to add picture n Excel table

And here’s a small tip to make it all easier.

If you need to adjust the image size to the size of the cell spot on, keep the button Alt pressed while dragging the image around. It’ll help you fit the picture into one of the cell corners and align it with its borders with more accuracy.

How to Insert Image in Excel Cell - adding pictures into Excel table
How to Insert Image in Excel Cell - put picture into Excel table

Repeat the steps above to insert the rest of the pictures into the cells, and we’re gonna have a look at one important thing regarding the picture formatting.

Imagine that now you need to hide a row. Hiding the row itself is not the problem. But if the row contains an inserted image, you’ll see that the picture usually stays visible, which means it gets in your view and covers important data in the spreadsheet. This can make your work disorganised and complicated not only when it comes to hiding rows, but also with filtering or other operations.

How to Insert Image in Excel Cell - how to hide picture inserted in Excel

The question is: how to deal with that?

Let’s undo the last changes and we’re gonna go through it together.

Right-click on the image and choose ‘Format Picture’.

How to Insert Image in Excel Cell - hide row with picture in Excel

On the right-hand side, a task pane with multiple options appears. Switch to ‘Size and Properties’ tab. Go to ‘Properties’ and select the option ‘Move and size with cells’. This will ensure that the image will move with the target cell. We can check it together right away.

How to Insert Image in Excel Cell - how to move and size picture with cell

Let’s hide row number 3, which contains the image.

How to Insert Image in Excel Cell - how to hide picture while hiding row in excel

You can see that the picture has also disappeared along with the whole row. Nothing now stands in the way of a neat spreadsheet with all important data well organised.

How to Insert Image in Excel Cell - hiding row with picture in Excel

Are you wondering :

If you found this tutorial helpful, give us a like and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers!

Thanks for watching and I’ll see you in the next tutorial!

Comments

Add comment

Your email address will not be published. Required fields are marked *

Your personal information will only be used for the purpose of processing this comment.