How to insert Image into a cell in Excel

Excel is a program that’s primarily used to retailer information and make calculations; it comprises rows and columns that make up the spreadsheet and include cells to enter information. In Microsoft Excel, customers can change the colour of the cells or thicken the border of the cells. However do you know that you could insert photos into the cell of your Excel spreadsheets? On this tutorial, we are going to clarify the steps on how to insert photos into a cell in Microsoft Excel.

How to insert an Image into a cell in Excel

Observe the steps under on how to insert a picture into a cell in Excel:

1. Launch Microsoft Excel.
2. Click on the Insert tab, choose the Illustration button, then choose Image.
3. Enter what you need in the search field.
4. Lower the image measurement till it’s small and place it into the cell.

Launch Excel.

Click on the Insert tab, choose the Illustration button, then choose Image.

Click on any of the choices under This System, Inventory Photos, or On-line Photos.  We select the On-line Photos choice.

An On-line Photos dialog field will open.

Enter what you need in the search field.

Choose the picture you need, then click on Insert.

A picture will seem in the spreadsheet.

Drag the factors of the picture down till it’s small.

Then enter the image into the cell.

When you’ve got a number of footage in multiple cell and also you need to conceal a row that comprises one image. The picture will nonetheless keep seen, which is able to make your desk disorganized; to repair this difficulty, right-click the image and choose Format Image from the context menu.

A Format Image Pane will open.

Click on the Measurement and Properties tab.

Click on the Properties part and examine the choice Transfer and measurement with cells.

Then shut the Pane.

Strive to delete or conceal the row with the picture. You’ll discover that the picture will disappear together with the row.

Why can’t I insert a picture into an Excel cell?

If you notice that the buttons for inserting images in Excel are greyed out, it can actually mean that the objects are hidden; follow the steps below to fix this issue.

1. Click File.
2. Click Options in the backstage view.
3. Then click the Advanced tab on the left pane.
4. Under display options for this workbook, check the option All.
5. Then click OK.

How do you unlock the Insert tab in Excel

The Insert tab in Excel contains commands which allow users to add Pictures, Charts, SmartArt, and more. Follow the steps below on how to allow enable insert.

1. Click the File tab.
2. Click Options in the backstage view.
3. Then click the Advanced tab on the left pane.
4. Scroll to the Cut, Copy and Paste section.
5. Check the checkbox for the “Show Insert Options” button.
6. Now scroll down to the section “Display options for this workbook.”
7. Check the checkbox for All the “For Objects, show.”
8. Then click OK.

How do I put an image behind text in Excel?

Follow the steps below on how to place an image behind a text in Excel:

1. Launch Excel.
2. Enlarge the row where you want to place the image.
3. Draw a rectangle in the enlarge cell.
4. Then right-click the rectangle and select Format Shape from the context menu.
5. A Format Shape dialog box will open.
6. Click the Fill and Line tab.
7. Click the Fill tab and choose the Picture and texture fill option.
8. Then click the Insert tab.
9. Click Online Images.
10. Browse for the image you want then click Insert.
11. Then go the Line section and click No line.
12. Click the Size and Properties tab.
13. Click the Properties section, then click the Move and size with cell option.
14. Close the Format Shape pane
15. Then start to type on the picture within the cell. You will notice that the text is in front of the picture.

READ: How to insert a picture into a comment in Excel

How can I add an image to a cell value?

Sure, you’ll be able to insert photos into an Excel cell worth; it’s not unimaginable, however you could know the precise method to do that process. On this article, we have now defined the steps on how to insert a picture into a cell in Microsoft Excel.

READ: How to Lock and Defend Cells in Excel from modifying

We hope you perceive how to insert photos into a cell in Excel.