Yes, you can insert an image into an Excel cell as follows. Paste an image into Excel, then resize the image and drag and drop it. Inserting an image into an Excel 2013 worksheet normally puts the image on a separate layer, which floats above the worksheet independently from the cells. If you'd rather have an image inside a cell, just change the image's formatting options. Another way to insert a picture directly inside a cell is to put it in a comment.

Related Articles

• 1 Paste From PDF Format to Excel
• 2 Working With Word & Excel Together
• 3 Place a Spreadsheet Over a Graphic & Make It Transparent
• 4 Copy From the Internet and Paste Into Excel

When most people think of Microsoft Excel, they think of organizational charts, budgets and quantitative formulas. However, there is much more to Excel than data manipulation. Adding multimedia images directly into an Excel spreadsheet enhances a program often used purely for calculations.

Besides enhancement, inserting an image in Excel can revitalize users’ interest in the program. For instance, adding imagery into Excel could complement an otherwise boring executive budget meeting. At the same time, a restauranteur might include images of food products and supplies into an inventory list to streamline production. By employing the subsequent methods, users open up possibilities for multimedia to change the way they traditionally see the calculation-based software.

Adding Images From Computer Into Excel Spreadsheet

It is possible to enter an image from a user’s computer into any version of Microsoft Excel. In Excel 2013 and Excel 2016, users can add pictures from various websites and online storage sites as well. The following method covers adding an image saved directly to a computer’s hard drive.

To insert the image:

• Click where the image should go in the Excel spreadsheet.
• Click the “Insert tab,” then the “Illustrations group,” and then click “Pictures.”
• A dialog box opens.
• Locate the desired image and highlight it.
• Click “Insert.'

Once completed, the image selected for upload should populate the desired cell.

Tip

• To insert multiple images at a time, press and hold the “Control” key, while selecting images from the pop-up dialog box. After highlighting the various files, click “Insert” in the same way. All images will upload to the previously selected location in the Excel spreadsheet.

Inserting an Image From an Online Source

As previously mentioned, Excel makes uploading images from various sources possible. To do this, go to the “Insert” tab in the toolbar. Then select“Online Pictures.” Different options appear depending on the user’s version of Excel. Bing Image Search is the default option for online images through insert picture Excel online.

After typing the keyword into the online search:

• Select the desired image wanted for insertion (users can select multiple documents at one time).

• Once selected, click Insert.

• Selected images migrate into the previously selected cell(s).

Inserting an Image Into a Header or Footer

Adding an image into a header or footer helps spreadsheet data remain consistent across multiple sheets. To achieve consistency when re-sizing, please follow the steps below:

• Go to the “View” tab.
• Click in the header or footer section (whichever one has the image)
• Select the image by clicking on it.
• On the “Design” tab under “Header & Footer Tools,” click “Format Picture” in the “Header & Footer Elements.”
• On the Size tab, adjust the size of the image to fit inside the header or footer containing the image.
• ClickOK.

The image should now fit properly and remain unaltered regarding its’ proportions.

Inserting an Image Into a Single Cell

Before embedding the image into the cell, be sure it will fit with the correct dimensions. This procedure may require merging several cells.

Once the user merges cells, to embed an image:

• Click on the image floating on the layer above the cells.
• Right Click the selected image.
• Select “Move and Size with Cells.”
• Make sure the “Print Object” and “Locked” checkboxes are checked to ensure picture lock.

Locking the image is important to link it to the other data in the table and spreadsheet. Otherwise, it may accidentally get lost or reformatted. When those items are checked off, you now have an embedded image that will act like data.

Sorting Images as Data

When including multimedia items into single cells of a table, Excel recognizes the images as data when sorting the table.

The steps below allow for the sorting to take place properly:

• Ensure the graphics included in each cell of the table fit entirely into the cell.
• Users must select the column that contains the images when employing any sorting function.
• Check the properties of the inserted images by using the Format Picture menu.
• Select “Format Picture.”
• Click “Properties.”
• Select “Move” (_Double-check the options “_Don’t Move” or “Size With Cells” are not selected).
• Be sure to lock image.

After completing the steps above, Excel should allow for image-sorting to occur as data in the table.

Inserting Data From Another Spreadsheet as an Image

This technique helps when working on a summary report. It is also beneficial when assembling data from several worksheets for printing. Before doing either of the below methods; first select the cells that you would like to “frame” the image in Excel.

Inserting a Picture Into a Cell

There are two methods to insert Excel data as a picture:

Copy as picture

This option allows copying/pasting information from another sheet as a static image. In many ways, this route is similar to inserting a screenshot of the data. To Copy as Picture:

• Go to the “Home” tab, select “Copy,” then “Copy as Picture.”
• Select “As Show On Screen.'
• Choose “Format.”
• Select “Picture.”
• Click “OK.”

Camera tool

The camera tool inserts data from selected cells and automatically updates them when the original data changes. To use the camera tool to insert an image:

• Go to the “Quick Access Toolbar.”
• Select the Camera Icon.
• Select the placement cell (where the new image goes).
• The image should populate automatically.

Inserting data as a picture into cell is a dynamic way to include images into data sets used over long periods.

Resizing Embedded Images

If an image fits improperly or needs to be rotated or moved in any way, users don’t need to worry. Resizing embedded images requires just a few simple steps:

• Click on the image in Excel.
• Right-click while the image is still selected.
• Go down to the “Format Picture” option.
• Click the radio button labeled “Move and Size with Cells.”

It is also possible to resize the image using the corner bullets while the image is selected. Hold down the “Shift” key while clicking and dragging on any corner of the image to keep the aspect ratio accurate while making it smaller or larger.

Deleting an Image From an Excel Spreadsheet

Deleting elements embedded in a document often causes formatting complications. However, properly removing an image in Excel doesn’t have to complicate a user’s life. Here’s how to remove an embedded image within Excel:

Deleting one multimedia element

• Select the preferred image for deletion.
• Press the “Delete” button on the keyboard

It is also possible to right-click, and then select “Delete” on the drop-down menu.

Deleting many images at once

• Press and hold the “Control” button on the keyboard while selecting images
• Next, press “Delete.”

Deleting all pictures on the current sheet

• Press F5 to open the “Go To” dialog box.
• Click “Special… “(the button at the bottom)
• In the “Go To Special”dialog box, check the “Object” option.
• Click “OK” (This sequence selects all pictures in the active worksheet).
• Now, press “Delete” to finish the job

The above methods for deleting images also apply to anything with picture lock (lock image) and any other model in Excel.

In the end, embedded images in Excel make data more dynamic for users. Following these tips and techniques to include images will surely make otherwise static spreadsheets, and tables come to life.

About the Author

Nicky is a business writer with nearly two decades of hands-on and publishing experience. She's been published in several business publications, including The Employment Times, Web Hosting Sun and WOW! Women on Writing. She also studied business in college.

Choose Citation Style

How to lock picture/image to or inside cell in Excel?

In some cases, you may need to lock a picture to a cell in order to make the picture moved with the cell when you adjust the cell size. This article will show you how to achieve it in details.

Lock picture to/inside cell with formatting picture properties
Easily insert picture automatically sized to fit cells with an amazing tool

Lock picture to/inside cell with formatting picture properties

It is easy to lock picture to a cell with the Move and size with cells build-in function in Excel. Password stealer usb tool for mac.

1. After inserting a picture, please right clicking it and select Size and Properties from the right-clicking menu. See screenshot:

2. Then the Format Picture pane displays on the right of the worksheet, then click Size and Properties icon, please select the Move and size with cells option under the Properties tab, and then close the Format Picture pane.

Now the picture is locked to cell. And when you adjusting the cell size, the picture will be moved together.

Easily insert picture automatically sized to fit cells with an amazing tool

In this section, we are talking about inserting pictures and automatically sized to fit cells with the Import Pictures utility of Kutools for Excel.

Before applying Kutools for Excel, please download and install it firstly.

1. Click Kutools Plus > Import & Export > Import Pictures. See screenshot: Deck design app for mac computer.

2. In the Import Pictures dialog box, you need to:

• 2.1 Select Fill vertically cell after cell or Fill horizontally cell after cell in the Import order drop-down list as you need.
• 2.2 Click Add > File or Folder based on your need.
• 2.3 In the Open dialog box, select the pictures or folder with pictures, and then click the Open button. See screenshot:
  
• 2.4 The pictures are listed in the Import Pictures dialog box. Now please click the Import size button, check the Matching cell size option and then click the OK button.
  
• 2.5 Click the Import button in the Import Pictures dialog box.

3. In the popping up Import Pictures dialog box, select the first cell of the range you will import pictures to, then click the OK button. Now the selected pictures are inserted into cells and sized to fit these cells automatically.

If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps.

Demo: Insert picture automatically sized to fit cells with Kutools for Excel

Related articles:

• Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails..
• Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range..
• Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.. Prevent Duplicate Cells; Compare Ranges..
• Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select..
• Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more..
• Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments..
• Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic..
• Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF..
• More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.

• Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
• Open and create multiple documents in new tabs of the same window, rather than in new windows.
• Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

• To post as a guest, your comment is unpublished.
  i have a problems while printing excel document, the images somehow block whole columns from top to the bottom though the image is only cover few columns.
  i try to sent to back or sen backward but it wont work, can anyone help me?
• To post as a guest, your comment is unpublished.
  Will anything that gets made or used with Kutools Excel be fully viewable to people who do not have (or would not be able to obtain the toolbox). The image anchoring algorithm seems usable for me, but I understand that others would not be able to make similar modifications.
• To post as a guest, your comment is unpublished.
  I routinely use excel to make my available products visible to my customers. I want to insert pictures and lock them in position, alos so lock the size of the cells holding these pictures, I need to ad or remove rows of data and want the pictures and cells to move up or down accordingly. can this be done?