To export an Excel table as an image in Microsoft Excel for Microsoft 365 on Windows, select the cells, choose Home > Copy ▼ > Copy as Picture, then paste the result into Paint or PowerPoint and save it as a PNG. This creates a portable, non-editable snapshot you can add to a report, presentation, email, or website. Check the copied image before sharing it, because its appearance depends on the selected cells and the copy settings.
What You’ll Need
- An Excel workbook with the table or cell range you want to capture.
- Excel for Microsoft 365 on Windows for the Copy as Picture steps below. The feature may appear differently in other desktop versions.
- Paint, PowerPoint, or another graphics app that can accept a pasted image and save it in an image format such as PNG or JPEG.
- A clear idea of which rows, columns, headers, and totals should appear in the final image. If the table is wide, decide whether you want a wide image or a smaller, scaled version.
Step-by-Step
-
Prepare the table. Open the workbook and make sure the table is in the state you want people to see. Apply any needed number formats, column widths, borders, fills, and text wrapping. If you want the image to show the current filtered results, check which rows are visible. Remove selection highlights by clicking a blank cell before copying, and consider saving the workbook so you can return to this layout later.
-
Select the cells to include. Drag across the table, or click the first cell and Shift-click the last cell. Include the header row if the image needs labels, and include a totals row only if it belongs in the result. Avoid selecting entire worksheet columns or extra blank cells: that can produce an unnecessarily large image with small-looking content. If only visible cells should appear, use Home > Find & Select > Go To Special > Visible cells only before copying, then check the pasted result carefully.
-
Open Copy as Picture. On the Home tab, find the Clipboard group and click the arrow beside Copy. Choose Copy as Picture from the menu. Do not choose the ordinary Copy command if you specifically need a picture; ordinary copying usually places cell data on the clipboard, which may paste as editable cells rather than as a single image.
-
Choose how Excel should capture the selection. In the Copy Picture dialog, select As shown on screen to match the worksheet’s current display, including its visible formatting. Choose As shown when printed if you want the capture to follow the print-oriented appearance; first check print settings such as page orientation and scaling if those matter. Under Format, choose Picture for a typical image object or Bitmap if a destination program has trouble with the picture format. Click OK.
-
Paste the picture into an app. Open Paint or a blank PowerPoint slide and press Ctrl+V. In Paint, the pasted selection should appear on the canvas. In PowerPoint, it should appear as a picture object that you can move or resize. If Excel seems to have pasted ordinary cells instead, return to the workbook and repeat the Copy as Picture command, then paste again.
-
Save the image file. In Paint, choose File > Save as and select PNG picture, JPEG picture, or another available image type. Give the file a descriptive name, choose a folder, and save it. In PowerPoint, right-click the pasted picture and choose Save as Picture; select a file type such as PNG and a location. PNG is usually a good choice for tables with text, gridlines, and sharp edges. JPEG can be useful for smaller files but may blur fine text.
-
Review the saved file. Open the image outside Excel and inspect its edges, text, numbers, and overall size. Confirm that the first and last columns are present, the headings are readable, and no unwanted worksheet area was included. If something is clipped or too small, adjust the selection, column widths, or copy settings, then repeat the export. Keep the original workbook if you may need to edit the table later; the image itself is a static snapshot.
Common Mistakes
Copying cells instead of copying a picture: Ctrl+C or Home > Copy copies cell content and formatting for spreadsheet use. It does not necessarily create a standalone image. Use Copy as Picture first, then paste into an image-capable app. If the destination shows a table with editable cells, undo the paste and repeat the picture-specific command.
Selecting too much or too little: Including empty rows and columns creates extra white space and can make the useful table look tiny. Leaving out a header or total may make the image hard to interpret. Check the selection border before copying and include only the content the reader needs.
Expecting the image to remain linked to Excel: A saved PNG or JPEG will not update when the worksheet changes. Export it again whenever the source values or formatting change. Also avoid resizing the image repeatedly in different apps, since that can soften text or make it look stretched.
Tips
Choose the image format for the job. PNG generally preserves crisp text, cell borders, and solid colors. JPEG compresses the picture and can create fuzzy edges around small lettering, so use it only when smaller file size matters more than sharpness. If an app cannot open the saved type, export again in a format it supports.
Make the table readable before capturing it. Widen columns enough to show full headings and values, use a consistent font size, and avoid excessive colors. If you have to shrink the final image substantially to fit a slide or page, consider splitting a very wide table into two images or redesigning the layout instead of reducing the text until it is difficult to read.
Use print layout when a printed appearance is important. As shown when printed can be useful when you have already set a suitable print area, page orientation, and scaling. It is not a general guarantee of higher image quality; check the output because print settings can alter the displayed layout or scale.
Keep a clean source and a useful filename. Save the workbook before making layout changes, and use a filename that identifies the table and date when appropriate. That makes it easier to replace an outdated image and to find the source data if someone asks for an updated version.
Troubleshooting
The Copy as Picture option is missing. Confirm that you are using the desktop Excel app and that the Home tab is open. Look in the arrow menu beside Copy in the Clipboard group. Excel for the web may not offer the same desktop command. If it is unavailable, use the Windows Snipping Tool to capture the visible table, or open the workbook in desktop Excel. A screen capture is convenient, but its quality depends on display size and zoom.
The pasted result is blank or not a picture. Return to Excel, select the range again, choose Copy as Picture, and confirm the dialog with OK before switching apps and pasting. If the clipboard has been replaced by another copy operation, repeat the copy. You can also try the Bitmap format in the Copy Picture dialog if the receiving app does not handle the default picture format correctly.
Text looks too small or the image is blurry. Do not enlarge a tiny screenshot and expect the letters to become sharper. Increase the worksheet zoom only if you are using a screen capture, or reduce unnecessary columns and rows in the selection. For a copied picture, try the Picture format and save as PNG, then view the image at its intended display size. If the table is still too wide, make separate images for logical sections.
Rows or columns are missing or the image has unexpected gaps. Review whether those cells were hidden or filtered, and check the selected range. Decide whether the goal is to capture the visible filtered result or the full table. For visible-only content, use Go To Special > Visible cells only before copying. If the output does not match what you need, clear filters or unhide the relevant rows and columns, select the intended range again, and recopy.
The image has a large border or is cut off in Paint. The selected range may include extra cells, or Paint’s canvas may be larger or smaller than the pasted picture. In Paint, use the canvas handles to remove unused space, or start with a fresh canvas and paste again. In Excel, make a tighter selection and verify the saved file after exporting; do not assume that the canvas boundary and image boundary are identical.
Frequently Asked Questions
Can I export an Excel table directly as a PNG?
Excel’s Copy as Picture command copies the selected range to the clipboard; it does not by itself create a PNG file. Paste the picture into Paint and save as a PNG, or paste it into PowerPoint and use Save as Picture.
Can I export only the visible rows after filtering?
Yes. Select the relevant range, use Home > Find & Select > Go To Special > Visible cells only, then use Copy as Picture. Check the pasted image to confirm that it contains the filtered rows you intended.
Can I do this in Excel for Mac?
Ribbon labels and available copy-picture commands can differ by Excel for Mac version. If you see a Copy as Picture option, use it and paste into an image app. If not, use the macOS screenshot shortcut Shift+Command+4 to capture a selected area, or paste the range into PowerPoint and save it as a picture if that option is available.
How do I export a table in Excel for the web?
The web app may not provide the same Copy as Picture command as desktop Excel. You can use your browser or operating system’s screenshot tool to capture the visible range, or open the workbook in Excel for Microsoft 365 on Windows and follow the desktop steps. A screenshot may include surrounding interface elements, so crop it before sharing.
Will the image change when I update the table?
No. A saved image is a snapshot and does not update with the workbook. Make a fresh copy and replace the old file whenever the table’s data or formatting changes.
Related
- Forecast Sheet in Excel 2007: What You Can Do Instead
- How to Enable Merge and Center in Excel: Quick Fixes
- Forecast Sheet in Excel: Enable It and Build a Forecast
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can Excel Slicers Connect to Multiple Tables Directly?In Excel, a slicer added to a regular Table filters that Table; it does not directly control other…
- Excel Merge Cells in Each Row Without Losing ValuesTo merge cells horizontally in every row of a selected range in Excel for Microsoft 365 on Windows,…
- Google Sheets Auto Sum: How to Total a Column AutomaticallyTo auto sum a column in Google Sheets, select the cell where you want the total, choose the…
- Insert a Row in a QuickBooks Journal Entry CorrectlyTo insert a row in a QuickBooks journal entry, open the entry and add a line: in QuickBooks…
- Track Changes in Word: How to Review and Accept EditsTo use Track Changes in Microsoft Word for Microsoft 365 on Windows, open the document, select Review >…
- How to Freeze Top Row and First Column in ExcelFreeze the top row and first column together in Excel with Freeze Panes, plus fixes for common issues…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.