The basic way to add an image to an Excel sheet
To add an image to Excel, go to the Insert tab at the top of the ribbon, click Pictures, then choose This Device to browse your computer for a file. Select the image and click Insert. The image will appear on your sheet at whatever size it imports at — usually larger than you need.
Once the image is on the sheet, you can resize it by dragging the corner handles outward or inward. Drag from a corner (not a side) to keep the image proportions correct. You can move the image anywhere on the sheet by clicking and dragging it to a new location.
If you want to insert an image from the web instead of your computer, click Insert, then Pictures, then Online Pictures. Type a search term and choose from the results. This method works the same way as inserting from your device once you select an image.
Key Takeaways
- Images are inserted through the Insert tab on the ribbon, and you can choose between files on your computer or images from the web.
- Resize images by dragging the corner handles, and move them by clicking and dragging to a new location on the sheet.
- Right-click an image to access formatting options like cropping, rotating, and adjusting brightness or contrast.
- Images sit on top of cells rather than inside them, so they will move or resize if you add or delete rows and columns nearby.
Resizing and cropping images
When you first insert an image, it often takes up too much space. Grab one of the corner handles (the small squares at the corners of the image) and drag inward to make it smaller, or outward to make it larger. Always drag from a corner to avoid stretching the image out of proportion.
If you want to crop the image — cut away parts you do not need — right-click the image and select Crop. A frame with handles will appear around the image. Drag the handles inward to remove the parts you do not want, then click elsewhere on the sheet to finish. Cropping is useful when an image has extra space or background you want to remove.
Anchoring images to cells
By default, images float on top of your sheet. If you insert rows or columns near the image, it may move in unexpected ways. To keep an image tied to a specific cell, right-click it and look for Move and Size or Properties (the exact name varies by Excel version). In the dialog that opens, find the option to anchor the image to a cell.
Anchoring is most useful when you are building a template or report that other people will edit. If someone adds rows above an image, an anchored image will move down with those rows instead of staying in a fixed position on the page.
Adjusting image appearance
Right-click any image on your sheet to see formatting options. You can adjust brightness and contrast, change the color mode (to grayscale or sepia, for example), or add a border or shadow. These options let you make an image fit better with your sheet's design without editing the original file.
You can also rotate an image by right-clicking and selecting Rotate, or by clicking the image once and using the rotation handle (a small circle above the image). Drag the rotation handle in a circular motion to turn the image to any angle.
Organizing multiple images
If your sheet contains several images, you can arrange them using the alignment and grouping tools. Select multiple images by clicking one, then holding Ctrl and clicking the others. Right-click and choose Align to line them up horizontally or vertically, or choose Group to lock them together so they move as one unit.
Grouping is helpful when you have a set of images that should always stay in the same positions relative to each other. Once grouped, you can move or resize all of them at once. To ungroup them later, right-click the group and select Ungroup.
Saving sheets with images
When you save an Excel file that contains images, the images are stored inside the file itself. This means the file size will be larger, but you can share the file with others and the images will travel with it. If you later delete an image from the sheet, the file size does not shrink — you would need to save the file again to reduce it.
If you are working with very large images or many images, consider compressing them before you insert them. You can compress an image in Excel by right-clicking it, selecting Compress Pictures, and choosing a resolution. Lower resolution reduces file size but may make the image look less sharp on screen.
Frequently Asked Questions
Can I put an image inside a cell instead of on top of it?
No. Images in Excel always float on top of cells rather than inside them. You can position an image so it appears to cover a single cell, but it is technically a separate object. If you need an image to be part of a cell's content, you would need to use a different tool like Word or a design program.
Why does my image look blurry after I insert it?
Images often look blurry if they are stretched larger than their original size. Excel displays the image at whatever resolution it was saved at, so enlarging it beyond that makes it appear fuzzy. Try cropping the image instead of enlarging it, or use a higher-resolution version of the image if you have one.
How do I remove an image from my sheet?
Click the image once to select it, then press the Delete key. The image will disappear immediately. If you delete it by mistake, press Ctrl+Z to undo and bring it back.
Can I link an image to a cell so it updates automatically?
No. Images in Excel are static objects — they do not update based on cell values or formulas. If you need an image to change based on data, you would need to use a macro or a more advanced tool. For most sheets, inserting images manually is the standard approach.