How to copy Excel cells as a picture
In desktop Excel for Windows, select a range, then choose Home → the arrow next to Copy → Copy as Picture. Choose an appearance and format, then press Ctrl+V where you want the image. The pasted picture is a snapshot of the selected cells and stays the same when the source changes.
Copy and paste a cell range as a picture
- For example, select A1:D6 if that is the only range you want in a report. Check that it includes the title and totals you need. On Home, open the arrow next to Copy and choose Copy as Picture.
- In the dialog, start with As shown on screen for the appearance and Picture for the format. Select OK to copy the image to the clipboard.
- Click the intended location in Word, PowerPoint, or another destination, then press Ctrl+V. For a PNG file, paste into an image editor such as Paint and save as PNG.
Microsoft’s guide to copying Excel cells as a picture
Choose screen or print appearance
Choose As shown on screen to keep the on-screen look. For a result closer to the printed appearance, choose the print option, often called As shown when printed. Paste a sample and check for details such as filter arrows and gridlines.
To leave gridlines out, turn off Gridlines on the View tab before copying. Borders added to cells are separate from gridlines and stay visible.
Choose Picture or Bitmap
Start with Picture if you will enlarge text and lines in the destination document. Microsoft recommends using As shown on screen and Picture together. The image pastes at 100% of its original size with this combination, so it can look larger than a worksheet displayed at 75% zoom.
Choose Bitmap when your workflow needs a pixel-based image. Enlarging a small bitmap can make its text and lines blurry. Check both choices at the size you will use, because the destination app and file format can affect sharpness.
Check the result before sharing and refresh it when data changes
Adjust column widths to fix clipped headings or #### and check that the range excludes any names or values you cannot share. After pasting, review the title, totals, edges, and text size. If values change in the workbook, copy the range again and replace the old image.
Use regular copy when recipients need editable cell values or formulas. In Excel, if you want a picture to update when its source cells change, copy normally and choose Linked Picture in the paste options.
Microsoft’s guide to paste options, including Linked Picture




