How to insert picture in Excel cell, comment, header or footer

Insert an image from a computer

Inserting a picture stored on your computer into your Excel worksheet is easy. All you have to do is these 3 quick steps:

1. In your Excel spreadsheet, click where you want to put a picture.
2. Switch to the Insert tab > Illustrations group, and click Pictures.
   
3. In the Insert Picture dialog that opens, browse to the picture of interest, select it, and click Insert. This will place the picture near the selected cell, more precisely, the top left corner of the picture will align with the top left corner of the cell.

To insert several images at a time, press and hold the Ctrl key while selecting pictures, and then click Insert, like shown in the screenshot below:

Done! Now, you can re-position or resize your image, or you can lock the picture to a certain cell in a way that it resizes, moves, hides and filters together with the associated cell.

Add picture from the web, OneDrive or Facebook

In the recent versions of Excel 2016 or Excel 2013, you can also add images from web-pages by using Bing Image Search. To have it done, perform these steps:

1. On the Insert tab, click the Online Pictures button:
   
2. The following window will appear, you type what you're looking for into the search box, and hit Enter:
   
3. In search results, click on the picture you like best to select it, and then click Insert. You can also select a few images and have them inserted in your Excel sheet in one go:
   

If you are looking for something specific, you can filter the found images by size, type, color or license - just use one or more filters at the top of the search results.

Besides adding images from Bing search, you can insert a picture stored on your OneDrive, Facebook or Flickr. For this, click the Online Pictures button on the Insert tab, and then do one of the following:

• Click Browse next to OneDrive, or
• Click the Facebook or Flickr icon at the bottom of the window.
  

Paste picture in Excel from another program

The easiest way to insert a picture in Excel from another application is this:

1. Select an image in another application, for example in Microsoft Paint, Word or PowerPoint, and click Ctrl + C to copy it.
2. Switch back to Excel, select a cell where you want to put the image and press Ctrl + V to paste it. Yep, it's that easy!
   

A quick way to insert a picture in a comment

If you'd rather not waste your time on routine tasks like this, Ultimate Suite for Excel can save a few more minutes for you. Here's how:

1. Select a cell where you want to add a comment.
2. On the Ablebits Tools tab, in the Utilities group, click Comments Manager > Insert Picture.
3. Select the image you want to insert and click Open. Done!

How to copy/paste as picture in Excel

To copy Excel data as an image, select the cells, chart(s) or object(s) of interest and do the following.

1. On the Home tab, in the Clipboard group, click the little arrow next to Copy, and then click Copy as Picture…
   
2. Choose whether you want to save the copied contents As shown on screen or As shown when printed, and click OK:
   
3. On another sheet or in a different Excel document, click where you want to put the picture and press Ctrl + V.

That's it! The data from one Excel worksheet is pasted into another sheet as a static picture.

Make a dynamic picture with Camera tool

To begin with, add the Camera tool to your Excel ribbon or Quick Access Toolbar as explained here.

With the Camera button in place, perform the following steps to take a photo of any Excel data including cells, tables, charts, shapes, and the like:

1. Select a range of cells to be included in the picture. To capture a chart, select the cells surrounding it.
2. Click on the Camera icon.
3. In another worksheet, click where you want to add a picture. That's all there is to it!

Unlike the Copy as Picture option, Excel Camera creates a "live" image that synchronizes with the original data automatically.

How to copy or move picture in Excel

To move an image in Excel, select it and hover the mouse over the picture until the pointer changes into the four-headed arrow, then you can click the image and drag it anywhere you want:

To adjust the position of a picture in a cell, press and hold the Ctrl key while using the arrows keys to reposition the picture. This will move the image in small increments equal to the size of 1 screen pixel.

To move an image to a new sheet or workbook, select the image and press Ctrl + X to cut it, then open another sheet or a different Excel document and press Ctrl + V to paste the image. Depending on how far you'd like to move an image in the current sheet, it may also be easier to use this cut/paste technique.

To copy a picture to clipboard, click on it and press Ctrl + C (or right-click the picture, and then click Copy). After that, navigate to where you wish to place a copy (in the same or in a different worksheet), and press Ctrl + V to paste the picture.

How to resize picture in Excel

The easiest way to resize an image in Excel is to select it, and then drag in or out by using the sizing handles. To keep the aspect ratio intact, drag one of the corners of the image.

Another way to resize a picture in Excel is to type the desired height and width in inches in the corresponding boxes on the Picture Tools Format tab, in the Size group. This tab appears on the ribbon as soon as you select the picture. To preserve the aspect ratio, type just one measurement and let Excel change the other automatically.

How to change picture's colors and styles

Of course, Microsoft Excel does not have all the capabilities of photo editing software programs, but you may be surprised to know how many different effects you can apply to images directly in your worksheets. For this, select the picture, and navigate to the Format tab under Picture Tools:

Here is a short overview of the most useful format options:

• Remove the image background (Remove Background button in the Adjust group).
• Improve the brightness, sharpness or contrast of the picture (Corrections button in the Adjust group).
• Adjust the image colors by changing saturation, tone or do complete recoloring (Color button in the Adjust group).
• Add some artistic effects so that your image looks more like a painting or sketch (Artistic Effects button in the Adjust group).
• Apply special picture styles such as 3-D effect, shadows, and reflections (Picture Styles group).
• Add or remove the picture borders (Picture Border button in the Picture Styles group).
• Reduce the image file size (Compress Pictures button in the Adjust group).
• Crop the picture to remove unwanted areas (Crop button in the Size group)
• Rotate the picture at any angle and flip it vertically or horizontally (Rotate button in the Arrange group).
• And more!

To restore the original size and format of the image, click the Reset Picture button in the Adjust group.

How to replace picture in Excel

To replace an existing picture with a new one, right-click it, and then click Change Picture. Choose whether you want to insert a new picture from a file or online sources,
locate it, and click Insert:

The new picture will be placed exactly in the same position as the old one and will have the same formatting options. For example, if the previous picture was inserted into a cell, the new one will also be.

How to delete picture in Excel

To delete a single picture, simply select it and press the Delete button on your keyboard.

To delete several pictures, press and hold Ctrl while you select images, and then press Delete.

To delete all pictures on the current sheet, use the Go To Special feature in this way:

• Press F5 key to open the Go To dialog box.
• Click the Special… button at the bottom.
• In the Go To Special dialog, check the Object option, and click OK. This will select all pictures on the active worksheet, and you press the Delete key to delete them all.