Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

For a visible range, use Home > Copy > Copy as Picture. If the worksheet is longer or wider than the screen, first set its print layout and scaling in Page Layout > Page Setup, preview it, and print to a file. Excel does not provide a single command that exports an unlimited worksheet directly as one image; the best method depends on whether you need a clipboard picture of selected cells or a complete, print-scaled worksheet.

Choose the method that matches the result you need

Excel’s picture command is selection-based. It captures the cells, chart, or object you select, not an automatically detected “whole sheet”. A worksheet that extends beyond the screen therefore needs a print-layout workflow.

Method What it captures Output Best use
Copy as Picture Any selected cell range, chart, or object Picture on the clipboard A quick image for a document, message, or another workbook
Page Setup and print to file The worksheet as laid out for printing, including multiple pages when necessary A print file such as PDF; convert pages to raster images separately if required A sheet larger than the screen or a repeatable, page-sized result
Operating-system screen capture Only the pixels currently visible on screen PNG or another screen-capture format A small region when Excel’s picture command is unavailable; not a full worksheet

For Microsoft 365, Excel 2024, and Excel 2021, Microsoft’s support instructions describe Copy as Picture. Its separate Page Setup and printing guidance covers Excel 2016 through Microsoft 365.

Capture a selected worksheet range with Copy as Picture

  1. Select the complete range. Drag across the cells you need, or click the first cell and use the appropriate keyboard selection to reach the last populated cell. Include every row and column intended for the image; Excel will not infer the worksheet’s used area for you.
  2. Hide gridlines if the image should look like a clean report. Open View > Show and clear Gridlines. This changes the worksheet view before the copy operation.
  3. Open the picture command. Choose Home > Copy > Copy as Picture.
  4. Set the copy options. In the Copy Picture dialog, choose As shown on screen for appearance and Picture for format. Microsoft recommends that combination for the best picture quality. The copied content retains its original size even if you reduced the worksheet’s zoom; resize it after pasting if the destination is smaller.
  5. Paste the result. Use Ctrl+V (Windows) or the normal paste command in Word, PowerPoint, another worksheet, an email, or an image editor. The result is a static picture, not editable cells.

What this method can and cannot do

  • It can copy a bounded range, a chart, or another worksheet object.
  • It does not create an automatic image of every populated cell on a very large sheet.
  • If the range is extremely wide or tall, pasting at its original size can produce an image that is difficult to view. Use print scaling instead when page-sized readability matters.

Capture a worksheet that is larger than the screen

When the goal is the entire worksheet, treat it as a print-layout problem. Excel can scale the sheet to a selected number of pages, show the result in print preview, and print it to a file. This gives you a complete layout, but it may produce several pages rather than one very tall bitmap.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
#1 Best Overall
Sale
Epson Workforce ES-50 Compact & Lightweight Mobile Document Scanner
  • PORTABLE SCANNER FOR USE ON-THE-GO — The fastest and lightest mobile single-sheet-fed compact document scanner in its class¹
  • QUICK DOCUMENT SCANNING ― This Epson ultra-fast scanner scans a single page as quickly as 5.5 seconds²; Windows and Mac compatible
  • VERSATILE PAPER HANDLING ― Portable scanner scans documents up to 8.5 x 72 in; Also easily digitizes receipts and ID cards to make accounting, bookkeeping, and organizing simpler
  • INTUITIVE, HIGH-SPEED SOFTWARE — Epson ScanSmart Software³ is a smart tool allowing you to easily scan, review, and save; Stay organized easily with the help of this Epson scanner
  • EASY SETUP — USB-powered connect to your computer for quick and simple scanning; No batteries or external power supply required to operate portable document scanner; Standard Connectivity: USB 2.0
  1. Open Page Setup. Go to Page Layout > Page Setup. Set orientation (portrait or landscape) and the paper size appropriate for the final document.
  2. Choose a scaling strategy. Use the scaling controls to fit the worksheet to a specified number of pages wide and tall. Fitting one page wide can keep columns together, while allowing several pages tall usually preserves more readable text than forcing the entire sheet onto one page.
  3. Inspect print preview. Open Excel’s print view and check page breaks, clipped columns, row headings, and text size. Change orientation, margins, or the page count until the important content is legible.
  4. Check the print area. A previously defined print area can restrict output to only part of the sheet. In the print settings, select Ignore print area when the complete worksheet is intended. If a specific print area is deliberate, leave it enabled and verify that it contains everything required.
  5. Print to a file. Use Excel’s print command and select an available file printer, such as a PDF printer on systems that provide one. Save the resulting file and review every page.
  6. Convert to images only if needed. Excel’s documented whole-sheet route ends with a print file. If your recipient specifically requires PNG, JPEG, or WebP, open the PDF in an image editor or a PDF-to-image utility and export the required page(s). Check the exported resolution and text at 100% zoom.

One page versus several pages

Forcing a large worksheet onto one page technically produces a single page, but the scaling can make labels unreadable. A multi-page PDF or a set of page images is often the more useful representation. If a single continuous image is mandatory, you can combine the page images afterward in an image editor; inspect seams and repeated headings before sharing it.

Prevent common omissions and visual surprises

Gridlines and borders

Gridlines are a view setting, not the same thing as cell borders. Clear View > Show > Gridlines before using Copy as Picture when you want a white, border-free background. Deliberate borders applied to cells remain part of the copied or printed content.

Print areas

Print settings honor a defined print area unless you choose Ignore print area. If a supposedly full-sheet PDF stops at an unexpected row or column, inspect the print-area setting first.

Rank #2
Sale
Brother DS-640 Compact Mobile Document Scanner, (Model: DS640)
  • FAST SPEEDS - Scans color and black and white documents a blazing speed up to 16ppm (1). Color scanning won’t slow you down as the color scan speed is the same as the black and white scan speed.
  • ULTRA COMPACT – At less than 1 foot in length and only about 1. 5lbs in weight you can fit this device virtually anywhere (a bag, a purse, even a pocket).
  • READY WHENEVER YOU ARE – The DS-640 mobile scanner is powered via an included micro USB 3. 0 cable allowing you to use it even where there is no outlet available. Plug it into you PC or laptop and you are ready to scan.
  • WORKS YOUR WAY – Use the Brother free iPrint&Scan desktop app for scanning to multiple “Scan-to” destinations like PC, Network, cloud services, Email and OCR. (2) Supports Windows, Mac and Linux and TWAIN/WIA for PC/ICA for Mac/SANE drivers. (3)
  • OPTIMIZE IMAGES AND TEXT – Automatic color detection/adjustment, image rotation (PC only), bleed through prevention/background removal, text enhancement, color drop to enhance scans. Software suite includes document management and OCR software. (4)

Sheet backgrounds

An image added through Excel’s sheet-background feature is for on-screen display and is not printed. Do not use a sheet background as a way to add a logo or other content to a printable image. Put printable artwork in cells, headers, or another object that appears in print preview.

What’s actually slowing this PC down?

Pick the symptom - the matching free tool is one click away.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Appearance and quality

Copy as Picture offers screen and print appearance choices. For the highest quality in the documented workflow, select As shown on screen and Picture, then resize the pasted picture in its destination rather than shrinking the worksheet before copying.

A practical decision checklist

  • Need a quick snapshot of a known range? Select the range and use Copy as Picture.
  • Need every populated row and column beyond the viewport? Configure Page Layout > Page Setup, preview, and print to a file.
  • Need a clean visual? Turn off gridlines and verify that no old print area is limiting the output.
  • Need a document rather than a bitmap? Keep the PDF produced by the print workflow; it preserves the page layout without an extra raster-conversion step.
  • Need one continuous bitmap? Export the printed pages to images and combine them, accepting that text may become smaller as the image grows.

Troubleshooting

The picture contains only part of the worksheet

Cause: Only the selected cells were copied, or a print area limited the print job. Fix: Reselect the full intended range for Copy as Picture. For printing, choose Ignore print area and confirm the page range in preview.

Rank #3
Sale
Epson Workforce ES-400 II High-Speed Color Duplex Desktop Document Scanner
  • FAST DOCUMENT SCANNING — Document scanner with feeder allows you to speed through stacks with a 50-sheet Auto Document Feeder (ADF); Efficient office scanner to help you scan more productively
  • INTUITIVE, HIGH-SPEED SOFTWARE — Quickly scan with this desktop document scanner; Epson ScanSmart Software lets you easily preview scans, email files, upload to the cloud, and more; Plus, automatic file naming saves even more time
  • SEAMLESS INTEGRATION — Easily incorporate your data into most document management software with the included TWAIN driver; Office document scanner integrates seamlessly with business workflows
  • EASY SHARING — Duplex scanner allows you to scan straight to email or popular cloud storage2 services like Dropbox, Evernote, Google Drive, and OneDrive for simple storage and sharing
  • SIMPLE FILE MANAGEMENT — Scanner allows the creation of searchable PDFs with Optical Character Recognition (OCR) and convert scans to editable Word or Excel files effortlessly; Designed for home and office document scanning

The pasted image is blurry or unexpectedly small

Cause: The image was scaled aggressively after copying, or the print workflow fitted too much content onto too few pages. Fix: Use As shown on screen and Picture, paste at or near the original size, or allow additional printed pages so labels remain legible.

Gridlines appear when they should not

Cause: Gridlines were still enabled when the range was copied. Fix: Clear View > Show > Gridlines, then run Copy as Picture again.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

The full worksheet is split in an awkward way

Cause: Orientation, margins, or fit-to-page counts do not match the sheet’s proportions. Fix: Return to Page Layout > Page Setup, try landscape for wide data, adjust the pages-wide/pages-tall settings, and recheck print preview.

Rank #4
Canon Canoscan Lide 300 Scanner (PDF, AUTOSCAN, Copy, Send)
  • Scanner type: Document
  • Connectivity technology: USB
  • With Auto Scan Mode, the scanner automatically detects what you're scanning
  • Digitize documents and images

A logo or background is missing from the printed result

Cause: It was inserted as a sheet background, which is display-only and does not print. Fix: Place the visual in printable worksheet content or a header/footer, then verify it in preview.

The file has several pages but I expected one image

Cause: Print scaling creates page-sized output rather than an automatic continuous bitmap. Fix: Keep the multi-page file for readability, or export the pages to images and stitch them in an image editor if a single canvas is a hard requirement.

Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Or skip the browser setup

If the worksheet is published inside a web page that ScreenshotNeo can reach by URL, ScreenshotNeo can capture that page instead of making you configure a browser. It is a website screenshot API, so it does not read a private .xlsx file directly; first make the worksheet available through an accessible page. You can then use full-page capture, a chosen viewport or device preset, retina scale, custom CSS to hide controls, waits for content, and PDF output when those are useful for the web version.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Best Value
Sale
ScanSnap iX2500 Wireless or USB High-Speed Document Scanner, Black
  • OUR MOST ADVANCED SCANSNAP. Large touchscreen, fast 45ppm double-sided scanning, 100-sheet document feeder, Wi-Fi and USB connectivity, automatic optimizations, and support for cloud services. Upgraded replacement for the discontinued iX1600
  • CUSTOMIZABLE. SHARABLE. Select personalized profiles from the touchscreen. Send to PC, Mac, mobile devices, and clouds. QUICK MENU lets you quickly scan-drag-drop to your favorite computer apps
  • STABLE WIRELESS OR USB CONNECTION. Built-in Wi-Fi 6 for the fastest and most secure scanning. Connect to smart devices or cloud services without a computer. USB-C connection also available
  • PHOTO AND DOCUMENT ORGANIZATION MADE EFFORTLESS. Easily manage, edit, and use scanned data from documents, receipts, photos, and business cards. Automatically optimize, name, and sort files
  • AVOIDS PAPER JAMS AND DAMAGE. Features a brake roller system to feed paper smoothly, a multi-feed sensor that detects pages stuck together, and skew detection to prevent paper damage and data loss

The service accepts cookie and consent banners before capture and removes more than 60 known consent platforms, newsletter popups, and chat widgets; each cleanup step can be disabled. Bot checks or CAPTCHAs, blank pages, timeouts, failed loads, and cache hits are not billed, and response headers identify the page verdict and whether it was billed. An MCP server provides take_screenshot, get_page_info, and capture_pdf tools for Claude, Cursor, and other MCP clients.

See the ScreenshotNeo documentation for authentication and options. These runnable examples use the service’s GET endpoint; replace the example URL with the public URL that renders your worksheet.

cURL

curl -G "https://api.screenshotneo.com/v1/shot" -d access_key=YOUR_API_KEY --data-urlencode url=https://screenshotneo.com -o shot.webp

Python

import requests
r = requests.get("https://api.screenshotneo.com/v1/shot", params={"access_key": "YOUR_API_KEY", "url": "https://screenshotneo.com"}, timeout=90)
open("shot.webp", "wb").write(r.content)

Node.js

const q = new URLSearchParams({ access_key: 'YOUR_API_KEY', url: 'https://screenshotneo.com' });
const res = await fetch(`https://api.screenshotneo.com/v1/shot?${q}`);

ScreenshotNeo has a free allowance of 1,000 shots per month without a card. Paid plans start at $5 for 3,000 shots; higher published tiers are $15 for 15,000, $39 for 60,000, $99 for 250,000, and $249 for 1,000,000, with two months free on yearly billing. Every feature is included on every plan. Create a free ScreenshotNeo account when your worksheet is available as a web page.

Final recommendation

Use Copy as Picture for a defined range and select As shown on screen plus Picture. For a worksheet that extends past the viewport, set orientation and fit-to-page scaling in Page Setup, remove unintended print-area limits, inspect preview, and print to a file. Convert the resulting pages to raster images only when the recipient specifically requires an image format.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Frequently Asked Questions

Which Excel editions include the documented Copy as Picture workflow?

Microsoft’s support guidance for this command applies to Microsoft 365, Excel 2024, and Excel 2021. The separate Page Setup and worksheet-printing guidance covers Excel 2016 through Microsoft 365.

Does Excel export a complete worksheet directly to one PNG or JPEG?

The documented commands provide a clipboard picture for a selected range and a print-to-file route for a full worksheet. A single PNG or JPEG requires an additional image-export or page-combination step after printing.

Quick Recap

Bestseller No. 4
Canon Canoscan Lide 300 Scanner (PDF, AUTOSCAN, Copy, Send)
Canon Canoscan Lide 300 Scanner (PDF, AUTOSCAN, Copy, Send)
Scanner type: Document; Connectivity technology: USB; With Auto Scan Mode, the scanner automatically detects what you're scanning
$75.00

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.