To add an image in Excel for Microsoft 365 on Windows, open the worksheet, select Insert > Pictures > This Device, choose an image file, and select Insert. Excel places it on the sheet as a movable picture; you can then resize and position it. If you want the picture contained within a cell instead, use Insert > Pictures > Place in Cell if that option is available in your Excel version.
Before you begin, save or locate the image file and decide whether it should sit over the worksheet or be stored inside a cell. That distinction affects how the image behaves when you sort, filter, or change row and column sizes.
What You’ll Need
- An Excel workbook you can edit. The steps below use Excel for Microsoft 365 on Windows.
- An image file saved somewhere you can browse to, such as a PNG or JPEG, if you are inserting a picture from your device.
- Optional: a worksheet layout with the destination cells and row or column sizes already set. This makes it easier to position the picture neatly.
Step-by-Step
- Open the workbook and choose a worksheet. Select the sheet where the image belongs. If the picture will illustrate a particular table row or group of cells, make sure that area is visible. You do not have to select a cell before inserting a picture, but selecting a nearby cell can help you orient yourself.
- Open the picture insertion options. On the ribbon, select Insert, then select Pictures. For a file on your computer, choose This Device. In some Microsoft 365 builds, the command may be labeled Picture from File or appear within a Pictures dropdown; choose the option that opens your computer’s file browser.
- Select the image file. Browse to the folder containing the image, select the file, and choose Insert in the file dialog. Excel adds the image to the worksheet. Depending on its original dimensions, it may cover several cells or appear larger or smaller than you expected.
- Move the picture into position. Click the picture so its border and sizing handles appear, then drag from the middle of the image—not from a handle—to move it. Place it over the intended area. For more precise positioning, use the arrow keys after selecting the picture; a small movement is easier to control than dragging with a mouse. Avoid dragging a handle unless you intend to change the picture’s size.
- Resize it without distorting it. Select the picture and drag a corner sizing handle inward or outward. Corner handles generally preserve the image’s proportions. Dragging a side handle can make the picture look stretched or squashed, so use that only when distortion is intentional. To enter exact dimensions, select the picture and open the Picture Format tab. Use the Height and Width boxes in the Size group. Depending on the ribbon layout, you may need to expand the Size group or open its dialog for additional options.
- Crop the image if you need a tighter frame. Select the picture, choose Picture Format > Crop, and drag the black crop handles to hide unwanted edges. Click Crop again or click outside the image to apply the crop. Cropping hides portions of the image rather than changing the original file, so you can often adjust the crop later. If you want the picture to fit a particular shape, use the options under Picture Format > Crop, such as Crop to Shape or Aspect Ratio, where available.
- Choose how it should behave with cells. A regular inserted picture floats above the grid. To control what happens when you resize or move cells, right-click the picture and choose Format Picture. In the formatting pane, open Size & Properties, then Properties. Choose Move and size with cells if the image should follow its cell and change size with it; choose Move but don’t size with cells if it should move with the cells but retain its dimensions; or choose Don’t move or size with cells if it should remain fixed on the sheet. Exact labels or pane layout can differ slightly between builds.
- Use Place in Cell when the image belongs to one cell. If your version offers it, select Insert > Pictures > Place in Cell, then choose the image source and select the file. Excel puts the picture in the selected cell rather than leaving it as a floating object. You can also be able to convert an existing floating picture by right-clicking it and choosing Place in Cell. The cell may need additional row height or column width to display the image clearly. If you do not see this command, use the regular insertion method and set the picture’s cell properties, or update Excel if your organization permits updates.
- Check the result and save. Click an empty cell to finish editing the picture. Check that it does not obscure labels, values, or buttons, and that it remains in the intended place when you adjust the worksheet. Save the workbook. If the image is important for understanding the sheet, add alternative text by right-clicking the picture and choosing View Alt Text or Edit Alt Text, depending on the available command.
To add a picture from Excel’s other sources: Open Insert > Pictures and choose an available source such as Stock Images or Online Pictures. The specific sources shown depend on your Excel version, account, and organization settings. Follow the on-screen search or selection prompts, then insert the chosen image. Only use images you have permission to use, especially in workbooks you plan to share or publish.
Common Mistakes
- Choosing a floating picture when you need a cell value. A standard inserted picture sits above the grid; it is not contained in the cell under it. If the image must travel with a record during sorting or filtering, use Place in Cell where available. Otherwise, carefully configure its cell properties and test the behavior.
- Dragging a side handle and distorting the image. Use a corner handle to keep the original proportions. If you need a specific height and width, check that the proportions are locked before changing both measurements.
- Resizing the cells but not the picture. Changing a row height or column width does not necessarily resize a floating picture. Set Move and size with cells if that behavior is wanted, or use an in-cell picture.
- Placing a large image over important data. A picture can cover cell contents without deleting them, making the worksheet appear to have missing data. Move it, resize it, or send it behind other objects where appropriate, and confirm that the data is still present.
- Assuming the picture is embedded in a cell because it lines up with one. A floating image may only appear aligned. Select it and check its properties, or use the in-cell command. Alignment alone does not determine how it behaves during sorting or row changes.
- Using a link to a file that other people cannot access. If a workbook relies on an image stored at a local or network path, a recipient may not have access to that location. Inserting the image into the workbook is usually more reliable for sharing, though it can increase the workbook’s file size.
Tips
- Set up the grid first. Decide on column widths and row heights before inserting a batch of pictures. Consistent cell sizes make product thumbnails, staff photos, or site images easier to scan.
- Use a consistent image size. For a catalog, select each picture and enter the same height and width in Picture Format. Keep the source images at similar proportions or crop them consistently so the rows look uniform.
- Keep the original image proportions. If a photo looks compressed, undo the last resize with Ctrl+Z on Windows, then resize it from a corner. On Mac, use Command+Z to undo.
- Make pictures easier to select. When an image is crowded among cells or other objects, open Home > Find & Select > Selection Pane to see a list of objects. Select the picture there and, if useful, rename it to something descriptive.
- Consider workbook size. Many large, high-resolution images can make a workbook slow to open or share. Resize or compress image files before inserting them if you do not need their full resolution. In Windows desktop Excel, select a picture and look for Picture Format > Compress Pictures; available compression options can vary by version.
- Think about accessibility. Add concise alternative text that explains the image’s useful meaning, rather than repeating nearby text. For a purely decorative image, mark it as decorative if that option is available.
Troubleshooting
The Pictures command or Place in Cell option is missing: Confirm you are in the desktop Excel app and that the workbook is not in a restricted editing state. The ribbon can collapse when the window is narrow, so maximize Excel or open the Insert tab and inspect its dropdowns. Features can vary by update channel, platform, or account; update Microsoft 365 if possible. If you are using Excel for the web or Mac, look for the equivalent picture options on the Insert tab, but expect the exact menu labels and available behaviors to differ.
The picture will not insert: Check that the file is still in the selected folder and is a supported image format. Try opening it outside Excel to confirm it is not damaged, then save a fresh copy as a common format such as PNG or JPEG and insert that copy. If the workbook is protected or opened read-only, save an editable copy or ask the owner for permission.
The picture looks blurry or has the wrong proportions: Avoid enlarging a small image far beyond its original size, because that can make it appear pixelated. Undo the resize and use a higher-resolution source. To correct stretching, resize from a corner or enter dimensions while keeping the aspect ratio locked. If only part of the image is visible, select it and inspect the crop settings.
The picture moves when you do not expect it: Right-click it, open Format Picture > Size & Properties > Properties, and choose the behavior that matches your layout. Then change a nearby row height or column width as a test. If sorting and filtering records is the priority, an in-cell picture is generally more predictable than a floating object.
The image covers cell contents or disappears behind another object: Select it through the worksheet or the Selection Pane, then move or resize it. Use the picture’s arrange options on Picture Format to change its order relative to other objects, if needed. Cell values hidden behind a picture may still be intact; click the cells or temporarily move the picture to check.
Frequently Asked Questions
How do I add an image to a specific cell in Excel?
Use Insert > Pictures > Place in Cell if your Excel version provides it, and select the image. A regular picture inserted with This Device floats above the grid, even if you position it over one cell.
How do I insert a picture in Excel without covering the text?
Resize and reposition the image so it does not overlap the text, or place it in a separate cell or column. If the text and image must share a record, use an in-cell picture when available and adjust the row and column dimensions.
Can I add more than one image at a time?
Yes. In the file browser, select multiple image files if your Excel build and file dialog allow it, then choose Insert. You can also repeat the insertion steps for each picture. Arrange and size each image afterward, and check that none hides worksheet content.
How do I keep a picture attached to a row when sorting?
Use Place in Cell for an image that belongs to a record, if available. A floating picture may not sort with the related row just because it is positioned over it. If you must use a floating picture, set its properties, test sorting on a copy of the sheet, and verify the result.
Can I add images in Excel for Mac or Excel for the web?
Yes, both offer picture insertion, although ribbon labels and options can differ from Windows desktop Excel. On Mac, use the Insert tab and its picture commands. In Excel for the web, use the available Insert picture options; if a command such as Place in Cell is absent, use a floating picture or open the workbook in a supported desktop version.
Will adding pictures make my Excel file larger?
Usually, yes: images stored in the workbook add to its file size. Use appropriately sized images, remove pictures you no longer need, and compress them when that option is available. Check that the pictures still look clear after compression.
Related
- How to Change Text to Dates in Excel
- How to Copy an Excel Spreadsheet Safely
- Undo in Excel: Reverse Your Last Action
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Strikethrough Numbers in Excel: Steps and TipsTo put a line through a number in Excel for Microsoft 365 on Windows, select the cell and…
- Excel Number Format for Lakhs With CommasTo show Indian-style comma grouping in Excel, select the cells, press Ctrl+1, choose Number > Custom, enter #,##,##0…
- Can You Make a Word Document a Fillable Form in Word?Yes. In Microsoft Word for Microsoft 365 on Windows, add content controls from the Developer tab—such as text…
- Protect an Excel Sheet Without Locking Cells: How It WorksYes. In Excel for Microsoft 365 on Windows, unlock the cells people should be able to edit, then…
- How to Delete a Page in Word for the Web Without ErrorsTo delete a page in Word for the web, select the text or other content on that page…
- How to Create Binder Labels in Word: A Step-by-Step GuideCreate binder labels in Word by choosing a label template that matches your label stock, entering the spine…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.