Export an Excel Table as a Picture: Step-by-Step

How-to basics · Updated November 20, 2026

To export an Excel table as a picture in Microsoft Excel for Microsoft 365 on Windows, select the cells, choose Home > Copy > Copy as Picture, set the appearance and format, then paste the result. To create an image file, paste the picture into Excel or another app and save it as a PNG or other available image format. This gives you a visual copy you can place in a report, email, presentation, or web page without sharing an editable spreadsheet.

The picture is a snapshot, not a live table: changing the original cells will not update the exported image. The instructions below apply to desktop Excel for Microsoft 365 on Windows. Mac and web notes are included where the controls differ.

What You’ll Need

  • A desktop version of Excel and a workbook containing the table or cell range you want to capture. Save the workbook first if you have made changes.
  • A destination for the image, such as a blank worksheet, PowerPoint, Word, Paint, or another app that can accept pasted images.
  • If you need a standalone image file, an image format supported by your destination. PNG is usually a good choice for tables because it keeps text and lines crisp.

Step-by-Step

  1. Prepare the table. Open the workbook and navigate to the worksheet. Make sure the values, headings, number formats, fills, borders, and column widths look the way you want in the picture. Remove temporary selections or editing highlights by clicking a cell outside the area, if needed. If the table has filter arrows, decide whether you want them visible; they are part of the displayed table and may appear in the picture.

    For a particularly wide table, consider whether the whole range will be readable at the size you plan to use. You can adjust column widths or use a smaller range before copying. Avoid changing the original layout just to make an image if the workbook needs to retain its current design; instead, copy the desired cells to a temporary worksheet and format that copy.

  2. Select the exact cells. Drag across the table, including its headings and any total row you want in the image. You can also click the first cell, hold Shift, and click the last cell. For a formal Excel Table, selecting its data and header cells captures the visible cell contents and formatting; the picture itself will not retain sorting, filtering, formulas, or table behavior.

    If you only want a portion of the table, select only that range. Check that you have not included extra blank rows or columns, because they can create unwanted white space in the resulting image. If you need nonadjacent areas, capture them as separate pictures or arrange them together in a temporary range first.

  3. Open Copy as Picture. On the ribbon, go to Home > Copy and click the small arrow next to Copy to open its menu. Choose Copy as Picture. Do not choose the regular Copy command for this step: regular Copy is designed to paste cells, while Copy as Picture places a rendered image on the clipboard.

    In some ribbon layouts, the Copy arrow is in the Clipboard group and may be small. If you cannot see it, widen the Excel window or expand the ribbon. Excel for Mac also has a Copy as Picture command, though the ribbon arrangement and exact location can differ by release. If you cannot find it on Mac, look under the Home tab’s Copy menu or the Edit menu.

  4. Choose how the picture should look. In the Copy Picture dialog box, select As shown on screen to capture the cells as they appear in the worksheet. This is generally the right choice for a table intended for a slide, document, or message. Choose As printed if the image should follow the worksheet’s print appearance, such as its page setup and print formatting.

    Think about the destination when choosing. A displayed worksheet may be easier to read than a print layout with scaling, while a print-oriented image can be useful when you are reproducing a page from a report. If you are unsure, use As shown on screen and inspect the pasted result before sharing it.

  5. Choose the picture format and confirm. Select Picture for a normal picture format, which is usually suitable for resizing and pasting into Office apps. Select Bitmap if another application has trouble accepting the standard picture format. Bitmap images can look less sharp if enlarged substantially, so avoid scaling them up after pasting.

    Click OK to copy the selected cells as a picture. Excel does not necessarily display a confirmation message. The picture is now on the clipboard, ready to paste. If you copy something else before pasting, that new clipboard content replaces the image.

  6. Paste the image where you need it. Click the destination in Excel, Word, PowerPoint, an email, or another compatible app, then paste. On Windows, press Ctrl+V. On Mac, press Command+V. In a workbook, click an open area away from the selected table before pasting so the picture does not cover important cells.

    For a standalone file, one reliable workflow is to paste the picture into a blank area of a worksheet. Click the pasted image to select it, right-click it, and choose Save as Picture. Choose the destination folder, enter a file name, select an available image type, and save. The command applies to the pasted picture, not to the original cells.

  7. Use a fallback if Save as Picture is unavailable. Paste the copied image into PowerPoint or Word, right-click the image, and look for Save as Picture. If the app you are using does not offer that command, paste the image into Paint on Windows and use Paint’s save options to create a PNG or another supported file. On Mac, paste into an image-editing app that can export image files.

    Use PNG for tables with small text, thin borders, and solid colors. JPEG is more useful for photographic content, but its compression can make fine text or lines look fuzzy. The image-format choices vary by app, so select a format that the person or system receiving the file can open.

  8. Check the saved result. Open the image file or view the pasted picture at its intended size. Confirm that the first and last rows and columns are present, the headings are readable, and no important content has been cropped. If the picture will be printed, check it at the expected print size; a table that looks clear when zoomed in may be too small on a printed page.

    Keep the original workbook as the source of truth. If a number or label changes later, update the cells, create a new picture, and replace the old image. A picture does not refresh when the worksheet changes.

Common Mistakes

  • Using regular Copy instead of Copy as Picture. Regular Copy usually pastes editable cells, not an image. If the destination shows separate cells or formulas, return to Excel and use Home > Copy > Copy as Picture.

  • Selecting too much or too little. Extra blank cells can add empty margins, while an omitted header or total row can make the image confusing. Check the selection before opening the Copy Picture dialog. If you need a neat capture, make a deliberate rectangular selection of the cells to include.

  • Expecting the image to update automatically. A pasted picture is static. It will not reflect recalculated formulas, new rows, or edits to the table. Re-export the picture after changes, or share the workbook as well when recipients need current or interactive data.

  • Choosing a print appearance without checking page setup. As printed can reflect page scaling and other print settings. If the worksheet is set to fit a large range onto one page, text may look tiny in the resulting picture. Use As shown on screen for a display-oriented image, or adjust and preview print settings before capturing a print-oriented version.

  • Enlarging a low-resolution image. A bitmap or compressed image may blur when scaled up. Start with the largest useful cell range at a readable zoom, choose Picture when appropriate, and avoid enlarging the saved image far beyond its original size.

Tips

  • Make a clean version before exporting. If filter arrows, notes, or temporary formatting distract from the data, copy the relevant cells to a spare worksheet and adjust that copy. In an Excel Table, the Table Design tab includes table style options such as Filter Button; turning that off affects the table display, so use a temporary copy if you do not want to change the original.

  • Think about legibility, not just how much fits. A very wide table may become unreadable when squeezed into a narrow slide or document. You can capture a smaller set of useful columns, create two related images, or place the picture on a landscape page. Keep text large enough for the recipient’s likely viewing size.

  • Preserve a copy of the source. Save the workbook separately from the image. The workbook retains the data and formatting needed to make corrections; the image is convenient for display but cannot be used to sort or calculate values.

  • Use a useful file name. Include a subject and date when the image is likely to be revised, such as Sales-summary-Nov-2026.png. This helps prevent someone from inserting an older snapshot into a report.

  • Review sensitive information. The picture contains whatever is visible in the selected cells, including names, figures, and possibly filter indicators. Check the selection and the final image before sending it, especially when the workbook contains confidential or personal information.

Troubleshooting

  • Copy as Picture is missing or disabled. Confirm that you have selected cells in a worksheet rather than editing text inside a cell or another object. Expand the ribbon and check the arrow beside Home > Copy. If you are using Excel for the web and cannot find the desktop command, open the workbook in the desktop Excel app if available. Otherwise, use a screen capture as a last resort and crop it carefully; a screenshot can include unrelated interface elements and may be less crisp.

  • Nothing happens when you paste. Return to the source worksheet, select the range again, run Copy as Picture, and paste immediately. Another copy operation can replace the clipboard contents. If the destination app still will not accept it, paste into Excel or PowerPoint first, then save or copy the image from there. Check whether the destination app blocks clipboard access.

  • The picture is cropped or incomplete. Recheck the selected range and make sure the destination object is not clipped by a text box, slide edge, or page boundary. Paste it into an open area first, then resize it using a corner handle so its proportions stay intact. If content is missing inside the image, repeat the copy with the correct cells selected.

  • Text looks blurry or too small. Avoid enlarging the picture, and try copying again with Picture rather than Bitmap. If you used As printed, check whether print scaling shrank the worksheet. For a wide range, capture fewer columns at a time or increase the cell text size on a temporary copy before exporting.

  • Colors or gridlines differ from what you expected. The copied appearance depends on the selected Copy Picture option and the worksheet’s displayed or print formatting. Try the other appearance option and paste a fresh copy to compare. If gridlines are important, make sure the desired lines are actual cell borders; worksheet gridlines and borders are not the same thing and may not appear identically in every destination.

  • You cannot find Save as Picture. First click the pasted image itself and right-click its edge, rather than right-clicking a cell. If the command is still not available, paste into PowerPoint or Paint and save from there. In Excel for Mac, use an app that supports exporting pasted images if the context menu does not provide a save option.

Frequently Asked Questions

Can I export an Excel table directly to a PNG file?
Excel’s Copy as Picture command copies the selected cells to the clipboard; it does not by itself create a file. Paste the picture into Excel or an image-capable app, then use Save as Picture or that app’s save or export command to create a PNG.

Will the picture stay connected to the table?
No. Copy as Picture makes a static snapshot. Edits to the cells do not change the picture. Create and save a replacement image whenever the table changes, or share the workbook if the recipient needs live data.

Can I copy only part of an Excel Table?
Yes. Select the specific rectangular range of cells you want, then use Copy as Picture. Include the table headings or row labels if readers need context. The image contains the selected cells, not the rest of the table.

Is a screenshot the same as Copy as Picture?
No. Copy as Picture captures the selected cells as an image, while a screenshot captures a portion of the screen and may include Excel’s ribbon, row and column headings, or other windows. Use a screenshot only when you need screen details that are not part of the cell range.

Does this work in Excel for Mac?
Excel for Mac has a Copy as Picture option, but the ribbon and menu layout can differ from Windows. Check the Home tab’s Copy menu or the Edit menu. Paste with Command+V, then save the pasted image through Excel or another app that supports image export.

Can I export a table as an editable image or spreadsheet?
An image is not editable as a table: its text and numbers are pixels or picture content, not cells. Keep or share the workbook when someone must edit, filter, or calculate from the data. You can still place the picture in a document and resize or crop it as an image.

Related

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.