Export an Excel Sheet to an Image: Methods and Tips

How-to basics · Updated November 20, 2026

To export an Excel sheet or selected cells as an image in Microsoft Excel for Microsoft 365 on Windows, select the range, choose Home > Copy ▼ > Copy as Picture, then paste it into Paint and save it as a PNG. Excel does not normally save a worksheet directly as a PNG or JPG, so this clipboard method is a practical way to create a sharp image. For a quick capture of what is visible on screen, use a screenshot instead.

What You’ll Need

  • An Excel workbook open in the desktop version of Microsoft Excel for Microsoft 365 on Windows.
  • Paint, which is included with Windows, or another image editor that can paste clipboard images and save PNG files.
  • A clear idea of what you want in the image: a selected range, a table, or the visible portion of a worksheet.

If you use Excel for the web, you may not see the same Copy as Picture command. You can still capture a visible area with your computer’s screenshot tool. On a Mac, use the screenshot option described below if you cannot find a picture-copy command in your Excel version.

Step-by-Step

  1. Prepare the worksheet. Open the workbook and check the cells you plan to capture. Remove temporary selections or editing cursors, confirm that headings and values are correct, and apply any number formats, borders, or fills you want shown. If the image is for sharing, consider whether hidden rows or columns contain information you do not want to reveal; a picture can expose visible data even when the workbook itself is not shared.
  2. Select the content to include. For a table or a block of cells, drag across the range. You can also click the Name Box to the left of the formula bar, type a range such as A1:F18, and press Enter. This is useful when the range is large or exact boundaries matter. To capture a whole worksheet, first decide whether you truly need every used cell: selecting a very large area can create an unwieldy image. A screenshot is better if you only need the portion currently visible.
  3. Open Copy as Picture. With the desired cells selected, go to Home > Copy ▼ > Copy as Picture. Click the small arrow beside Copy to open its menu; choosing the ordinary Copy command alone will copy cell data, not necessarily create a picture. In the Copy Picture dialog, choose As shown on screen to match the worksheet’s displayed appearance, or As shown when printed to use its print rendering. Select Picture, rather than Bitmap if both choices are available, then click OK.
  4. Paste the picture into an image editor. Open Paint and press Ctrl+V to paste the copied image. If Paint already contains another image, choose File > New first and discard the old canvas if prompted. Check the pasted image before saving: confirm that the full range is present, text is readable, and the background and cell borders look right. The copied object is an image, so you cannot edit its cell values in Paint.
  5. Crop or adjust the canvas if needed. If the pasted picture includes blank space, use Paint’s Select tool to mark the area you want and choose Crop. Avoid resizing the image too small, because spreadsheet text can become difficult to read. If you need more space around the content, increase the canvas rather than stretching the picture. Keep the original proportions when resizing so gridlines and text do not look distorted.
  6. Save as a PNG. In Paint, choose File > Save as > PNG picture, select a folder, enter a descriptive file name, and click Save. PNG is usually a good choice for spreadsheets because it preserves crisp text and straight gridlines. If you need a JPG for a particular website or app, use Paint’s Save as menu to choose JPEG instead; JPG may make small text or thin lines look less clean.
  7. Check the saved file. Open the PNG from the folder where you saved it and inspect it at a useful zoom level. Verify that the last row and column are included, values are not clipped, and text remains readable. If the image will be inserted into a document or message, check its appearance there too: some apps resize images when they are placed, so a file that looks clear on its own may appear too small in the final layout.

Mac option: If your Excel for Mac version does not offer Copy as Picture, select the cells and use a screenshot. Press Shift+Command+4, drag around the visible range, and release. macOS saves the capture as an image file, usually on the desktop. To capture a long worksheet, adjust zoom or use the Copy as Picture option if it is available; a screenshot only captures what fits on screen. Excel for the web can also be captured with the screenshot tool on Windows or Mac.

Common Mistakes

  • Copying cells instead of a picture: The regular Copy command copies cell contents for pasting into another worksheet. Use Copy as Picture when you need an image, or paste into Paint and check that the result is a graphic rather than a table of editable cells.
  • Capturing the wrong range: A missed heading or final column can make the image confusing. Before copying, confirm the selection outline covers exactly the cells you need. Using the Name Box with a precise range can prevent accidental extra or missing rows.
  • Choosing an unsuitable rendering: As shown on screen is generally best for a simple shareable image. As shown when printed can be useful when the worksheet has carefully arranged print settings, but page scaling or print layout may change how the content appears. Preview the pasted result before saving.
  • Making the image too small: Shrinking a large table to fit a narrow space can make the figures unreadable. Capture only the useful cells, increase the available display space, or use multiple images rather than compressing everything into one tiny graphic.
  • Assuming the image updates with Excel: A saved PNG is a snapshot. If the source values change, create and save a new image; the old file will not update automatically.

Tips

  • Choose a useful zoom before copying. For As shown on screen, adjust the Excel zoom so the selected range is clear and well-proportioned. This does not change the actual cell values or the workbook’s saved print scale.
  • Use formatting to improve readability. Widen columns enough to show full labels, wrap long headings, and use a consistent font size. If gridlines are hard to see, add cell borders in Excel before copying; screen gridlines and printed borders are not the same thing.
  • Keep a clean source workbook. Save your workbook before making presentation-only changes. If you temporarily alter column widths or hide unrelated data to prepare an image, restore the worksheet afterward or work on a copy.
  • Name files clearly. Include a subject and date when it helps, such as Quarterly-Sales-November.png. This makes it easier to distinguish a fresh export from an older snapshot.
  • Use a screenshot for speed, Copy as Picture for control. Screenshots are convenient for a quick view of a dashboard or a few visible cells. Copy as Picture is usually more suitable when you need a precise cell range and want to paste it into an editor before saving.

Troubleshooting

  • Copy as Picture is missing or unavailable: Confirm that you are using the desktop Excel app and have selected worksheet cells. Open the arrow beside Copy on the Home tab rather than looking only for the main Copy button. If you are in Excel for the web or the command is not offered in your build, capture the visible range with Snipping Tool on Windows or Shift+Command+4 on Mac.
  • Paint pastes cell text rather than an image: Return to Excel and repeat the Copy as Picture steps, selecting Picture in the dialog. Then open a new Paint canvas and paste again. If you used ordinary Copy, Excel may provide cell data that Paint cannot treat as the intended picture.
  • The image is blank or incomplete: Check the selected range and repeat the copy. If Excel was displaying a dialog or another window during a screen capture, close it and capture again. For an unusually large selection, try a smaller range first; this can reveal whether the issue is the selection size or the paste destination.
  • Text or borders look fuzzy: Avoid enlarging a small screenshot or repeatedly resizing a saved image. Re-copy the cells at a more suitable zoom and save as PNG. If you must use JPG, check whether its compression makes fine lines less distinct; PNG is generally preferable for text-heavy images.
  • The right side or bottom is cut off: Verify that the selected range includes the last row and column. If using a screenshot, zoom out slightly or capture the worksheet in more than one image. If using Copy as Picture, paste into a fresh canvas and check the selection before cropping.
  • The saved file opens in the wrong format: In Paint, use Save as and explicitly select PNG picture or JPEG picture, then check the file extension. Renaming a file extension alone does not convert its image format.

Frequently Asked Questions

Can Excel save a worksheet directly as a PNG?

Excel for Microsoft 365 on Windows does not normally provide a direct Save As PNG option for a worksheet. Use Copy as Picture and paste into an image editor, or take a screenshot of the visible area.

How do I export only part of a sheet?

Select the required cells by dragging or by entering a range in the Name Box, such as B2:G14. Then choose Home > Copy ▼ > Copy as Picture and paste the result into an image editor.

Should I use PNG or JPG?

Choose PNG for tables, text, and thin gridlines because it usually keeps edges crisp. Choose JPG only when a service specifically needs it or a smaller file is more important than the sharpest text.

Can I export an entire worksheet as one image?

Yes, you can select a large used range and use Copy as Picture, but the resulting image may be very tall or difficult to read. For a long sheet, consider selecting relevant sections separately or using a PDF when the goal is to preserve a multi-page layout.

Will the image change when I edit the workbook?

No. The PNG or JPG is a static snapshot and does not stay linked to the worksheet. If the data or formatting changes, repeat the export and save an updated image.

Can I use the same steps in Excel for the web?

The desktop Copy as Picture command may not be available in the web app. For a quick image, use your computer’s screenshot tool to capture the cells visible in the browser; use desktop Excel when you need more control over the copied range.

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.