Excel is a program that is mainly used to store data and make calculations; it contains rows and columns that make up the spreadsheet and contain cells to input data. In Microsoft Excel, users can change the color of the cells or thicken the border of the cells. But did you know that you can insert images into the cell of your Excel spreadsheets? In this tutorial, we will explain the steps on how to insert images into a cell in Microsoft Excel.
How to insert an Image into a cell in Excel
Follow the steps below on how to insert an image into a cell in Excel:
- Launch Microsoft Excel.
- Click the Insert tab, select the Illustration button, then select Picture.
- Enter what you want in the search box.
- Decrease the picture size until it is small and place it into the cell.
Launch Excel.
Click the Insert tab, select the Illustration button, then select Picture.
Click any of the options below This Device, Stock Images, or Online Images. We choose the Online Images option.
An Online Pictures dialog box will open.
Enter what you want in the search box.
Select the image you want, then click Insert.
An image will appear in the spreadsheet.
Drag the points of the image down until it is small.
Then input the picture into the cell.
If you have multiple pictures in more than one cell and you want to hide a row that contains one picture. The image will still stay visible, which will make your table disorganized; to fix this issue, right-click the picture and select Format Picture from the context menu.
A Format Picture Pane will open.
Click the Size and Properties tab.
Click the Properties section and check the option Move and size with cells.
Then close the Pane.
Try to delete or hide the row with the image. You will notice that the image will disappear along 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.
- Click File.
- Click Options in the backstage view.
- Then click the Advanced tab on the left pane.
- Under display options for this workbook, check the option All.
- 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.
- Click the File tab.
- Click Options in the backstage view.
- Then click the Advanced tab on the left pane.
- Scroll to the Cut, Copy and Paste section.
- Check the checkbox for the “Show Insert Options” button.
- Now scroll down to the section “Display options for this workbook.”
- Check the checkbox for All the “For Objects, show.”
- 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:
- Launch Excel.
- Enlarge the row where you want to place the image.
- Draw a rectangle in the enlarge cell.
- Then right-click the rectangle and select Format Shape from the context menu.
- A Format Shape dialog box will open.
- Click the Fill and Line tab.
- Click the Fill tab and choose the Picture and texture fill option.
- Then click the Insert tab.
- Click Online Images.
- Browse for the image you want then click Insert.
- Then go the Line section and click No line.
- Click the Size and Properties tab.
- Click the Properties section, then click the Move and size with cell option.
- Close the Format Shape pane
- 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?
Yes, you can insert images into an Excel cell value; it is not impossible, but you must know the right technique to do this procedure. In this article, we have explained the steps on how to insert an image into a cell in Microsoft Excel.
READ: How to Lock and Protect Cells in Excel from editing
We hope you understand how to insert images into a cell in Excel.
