Excel Workbook Image: Insert, Copy, or Export Pictures

An Excel workbook is not itself an image: it is a file that can contain worksheets, data, charts, and pictures. In Microsoft Excel for Microsoft 365 on Windows, use Insert > Pictures to add a picture, or select cells and choose Home > Copy > Copy as Picture to turn a worksheet range into an image you can paste elsewhere.

What “Excel workbook image” can mean

The phrase can refer to several different tasks, and the best method depends on what you want to do with the result. You might want a photograph or logo inside a workbook, a picture of a table to share in an email, or an image file of an entire worksheet. Those are not the same operation.

Excel stores workbook content in an editable spreadsheet file, usually with an .xlsx extension. A picture inserted into a sheet is an object or cell value within that workbook; it does not turn the whole workbook into a picture. Likewise, copying a selected range as a picture captures the displayed cells, not formulas, hidden data, or the rest of the workbook.

Add a picture to a worksheet: insert an image file or another available picture source.
Share a table as an image: copy the selected cells as a picture and paste them into another program.
Share a full sheet or workbook: usually export to PDF for a multipage document, or capture the screen if you specifically need a raster image.

How to insert a picture into a worksheet

To add an image from your computer in Excel for Microsoft 365 on Windows, first select the worksheet and approximate location where you want it. Choose Insert > Pictures > This Device, select the image file, and choose Insert. Excel places the picture on the sheet, where you can resize it and move it with the mouse. Depending on the current ribbon layout, the Pictures command may appear directly on the Insert tab rather than inside a labeled Illustrations group.

Excel may also offer sources such as stock or online pictures, depending on the account, app version, and connected services. Use those options only when you have permission to use the image for your purpose. For a company logo, product photo, or chart illustration, inserting a locally stored file is often the most predictable choice.

After insertion, click the picture to display the contextual Picture Format tab. Drag a corner handle to resize while maintaining its proportions; dragging a side handle can distort it. To crop, choose Picture Format > Crop, adjust the crop handles, then click outside the picture or press Enter. Cropping hides part of the image in the sheet; it does not necessarily remove those pixels from the workbook file.

Pictures in cells versus pictures over cells

A picture can sit over the worksheet grid as a floating object, or, in supported Microsoft 365 versions, be placed inside a cell. A floating picture covers the cells beneath it visually but remains a separate object. This is useful for a logo or a decorative image that should stay in a particular area of a report.

For a picture that belongs to a row of records—such as a product thumbnail beside its product name—an in-cell picture is often easier to manage. Select the picture and choose Picture Format > Place in Cell if the command is available. You can also use the picture’s context menu in supported builds. To add a picture directly as cell content, use the in-cell option offered from Insert > Pictures, where available.

In-cell pictures behave more like cell contents when rows or columns are sorted, filtered, or resized. Floating objects have separate positioning behavior. For an existing floating image, Excel may offer Place over Cells as the reverse command. Feature availability can vary by update channel and platform, so if these choices are missing, update Microsoft 365 or use floating pictures and set their properties instead.

Make a picture follow a cell or stay fixed

Floating pictures can move or resize with worksheet cells, or remain independent of cell changes. This matters when the picture is attached to a row that users sort or when column widths may change. Right-click the picture, choose Format Picture, and open Size & Properties. Under Properties, select the behavior that fits the sheet: move and size with cells, move but don’t size with cells, or don’t move or size with cells. The exact pane labels can vary slightly between builds.

For example, a product thumbnail should generally move with its product row; otherwise sorting the product list may separate the image from the matching item. A page header logo, on the other hand, may be better positioned so ordinary row-height changes do not stretch it. Test the behavior by changing a relevant row height or sorting a small sample before applying the layout to a large table.

Use the worksheet’s Selection Pane when pictures overlap or are hard to click. It lists objects so you can select, hide, show, or rename them. Descriptive object names are useful in a workbook with many images, though they do not replace adding alternative text for accessibility.

Copy worksheet cells as an image

To make a shareable picture of a table, select the cell range, then choose Home > Copy (the arrow beside Copy) > Copy as Picture. In the dialog, choose whether the image should look as shown on screen or as it will appear when printed, and select the picture format if that choice is offered. Click OK, then paste into a destination such as PowerPoint, Word, Paint, or an image editor.

The selected range should be formatted before you copy it: set column widths, number formats, borders, fills, and zoom as needed. “As shown on screen” captures the visible worksheet appearance, while “as shown when printed” is intended to reflect print presentation. The resulting image is a snapshot, not a live connection to the cells. If you later change a value, the copied picture does not update.

This method is particularly useful for sharing a compact summary without exposing every sheet in a workbook. It can also preserve a table’s visual arrangement in a document. However, it is not a substitute for sending the original workbook when the recipient needs to sort data, inspect formulas, or edit values.

Save a worksheet or workbook as an image

Excel does not provide a single standard command that exports an entire workbook directly as a PNG or JPEG image. For a selected table, use Copy as Picture and paste it into an image editor, then save it in the desired format. If the destination program accepts a pasted picture, you may not need a separate image file at all.

For a whole worksheet intended for reading or printing, PDF is usually a better fit than one giant image. Choose File > Export or File > Save As and select PDF, then check the print area, page orientation, scaling, and page breaks before exporting. A workbook with several sheets can produce several PDF pages; choose the relevant sheet or sheets in the print settings if you do not want the entire workbook included.

If you truly need a raster image of a full sheet, first arrange the sheet at a readable zoom and capture the visible area with a screen-capture tool. A screenshot only records what is on screen, so it may omit rows and columns outside the window and can become difficult to read when enlarged. For a large report, divide the content into sensible sections or use a PDF rather than shrinking everything into one image.

Image quality, workbook size, and accessibility

Large photos can make an .xlsx file slow to open or cumbersome to email. Resize an image to roughly the dimensions it will appear at before inserting it when practical. Excel also provides picture compression: select a picture and choose Picture Format > Compress Pictures. Depending on the dialog options in your version, you can apply compression to selected pictures or all pictures and choose an output resolution. Compression can reduce file size, but it may permanently reduce image detail in the workbook, so keep an original copy if quality matters.

Use a suitable source image rather than enlarging a tiny thumbnail. A low-resolution picture can look blurred when stretched, while an unnecessarily large photograph can add many megabytes without improving its on-sheet appearance. For logos and diagrams with sharp edges, PNG or a supported vector format may preserve crisp lines; photographs are commonly supplied as JPEG files. The best format depends on the image and the programs that need to open it.

For accessibility, add alternative text that explains the image’s purpose. Right-click the image and choose View Alt Text or the equivalent command available in your build, then enter concise descriptive text in the pane. For a purely decorative image, mark it as decorative if that option is offered. Avoid using a picture as the only place where essential figures appear: keep important information in actual worksheet cells so it can be searched, calculated, and read by assistive technology.

Common problems and practical fixes

The picture covers cells or text: move it, resize it, use the Selection Pane to select overlapping objects, or place it in a cell if that feature is available.
The image no longer matches its row: check its cell-position properties, or use an in-cell picture for record-based images.
The picture looks stretched: resize from a corner handle or use the crop controls instead of pulling a side handle.
The workbook is unexpectedly large: remove unused images, crop or resize source files, and consider Compress Pictures. Save a backup before applying quality-reducing compression.
Copy as Picture is missing: open the Copy dropdown on the Home tab after selecting cells. If the command is unavailable in your app, try desktop Excel; Excel for the web and other platforms can have different command coverage.

One frequent misunderstanding is that hiding rows or cropping a photo makes the underlying content disappear from the file. Hiding worksheet rows is not the same as deleting data, and cropping can leave recoverable picture content in the workbook. If you are preparing a workbook for external sharing, remove information that should not be shared rather than relying on visual concealment.

Windows, Mac, and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. Excel for Mac has similar picture insertion, formatting, and copying tools, but ribbon placement and available commands can differ. Keyboard shortcuts also vary between Windows and Mac, so the ribbon command is the clearest route when you are following instructions across platforms. Excel for the web supports many common picture and worksheet tasks, but advanced formatting, object handling, and copy-as-picture options may be limited or arranged differently.

If you are collaborating with people using different versions, test the workbook in the version they will use. In-cell images and other newer features may not behave identically in older desktop editions or third-party spreadsheet applications. A PDF is often the safer option when recipients only need to view a fixed report; an .xlsx file is preferable when they need working spreadsheet data.

Frequently Asked Questions

Can I make an entire Excel workbook into one image?
Excel does not directly export a complete multi-sheet workbook as one image. Copy a selected range as a picture for a specific area, export sheets to PDF for a readable document, or use screen capture for the visible portion of a sheet.

How do I put a picture inside an Excel cell?
In supported Microsoft 365 versions, select the picture and choose Picture Format > Place in Cell, or use the in-cell choice when inserting a picture. If the command is not present, that feature may not be available in your version; a floating picture is the alternative.

Can I copy an Excel table as a picture into Word?
Yes. Select the cells, choose Home > Copy > Copy as Picture, confirm the appearance options, then paste in Word. The pasted result is a static image rather than an editable table linked to the workbook.

Why does my picture move when I change a row or column?
It is likely a floating object whose properties make it move or resize with cells. Right-click it, open Format Picture > Size & Properties, and select a different cell-position behavior, or use an in-cell picture where supported.

Does adding pictures make an Excel file larger?
Usually, yes. Embedded image data contributes to workbook size, especially for high-resolution photos. Resize images before inserting them or use Compress Pictures, and retain an uncompressed original if you may need the full image quality later.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.