You need to paste an Excel table into an email, presentation, or document while keeping its exact formatting. Pasting as a regular table often loses cell shading, borders, or font styles. Excel can copy a selected range as a static picture. This article shows the steps to copy your table as an image for use in any other application.
Key Takeaways: Copy Excel Tables as Images
- Copy as Picture dialog (Home > Copy > Copy as Picture): Creates a static image you can paste into PowerPoint, Word, or Outlook.
- Paste Special > Picture (Enhanced Metafile): Pastes a vector-based image into another Office app for better quality when resizing.
- Windows Snipping Tool or Snip & Sketch: Captures any screen area as a PNG image when you need a quick, simple screenshot.
Overview of Excel’s Copy as Picture Feature
The Copy as Picture command converts your selected cells into a graphical object. This picture is a snapshot of how the table looks on your screen at that moment. The copied image includes all visible formatting, such as gridlines, colors, and cell alignment. You do not need any special add-ins or software to use this feature.
Excel offers two main output formats for the picture. The Bitmap format creates a pixel-based image like a standard screenshot. The Picture format creates a vector-based image known as an Enhanced Metafile. The vector format often provides sharper results when you resize the image after pasting it into another program.
Prerequisites for a Clean Image
Before copying, adjust your Excel view for the best result. Ensure all columns and rows you want are visible. Zoom to 100% for a standard resolution image. Check that cell borders and shading are turned on if you want them included. The copied picture will only capture what is currently displayed in the selected cell range.
Steps to Copy a Table as a Picture
Use the ribbon command for the most control over the image format and appearance.
- Select your table range
Click and drag your mouse to highlight all the cells you want to include in the picture. - Open the Copy as Picture dialog
Go to the Home tab on the ribbon. Click the small arrow under the Copy button in the Clipboard group. Select Copy as Picture from the dropdown menu. - Choose your appearance and format
In the dialog box that appears, you will see two options. Under Appearance, select As shown on screen. Under Format, choose either Picture for a vector image or Bitmap for a pixel image. Click OK. - Paste the image into your target app
Switch to your other application, like PowerPoint or Outlook. Click where you want the image. Press Ctrl+V to paste. The table will appear as a single, non-editable picture.
Using Paste Special for Enhanced Quality
After copying the cells as a picture, you can use Paste Special within another Microsoft Office app for more options.
- Copy your table range normally
Select your cells in Excel and press Ctrl+C. - Use Paste Special in the destination app
In Word or PowerPoint, go to the Home tab. Click the Paste dropdown and select Paste Special. In the dialog, choose Picture (Enhanced Metafile) and click OK. This often gives a cleaner image than a standard paste.
Common Mistakes and Things to Avoid
Copied Picture Appears Blurry or Pixelated
This usually happens when you copy as a Bitmap and then enlarge the image. Bitmaps have a fixed resolution. To fix this, copy the table again using the Picture format in the Copy as Picture dialog. The vector-based Picture format scales better. Also, avoid copying while Excel is zoomed to a very small view, as this reduces detail.
Image Does Not Include Cell Borders or Gridlines
The Copy as Picture feature only captures what is visible. If your gridlines are hidden, they will not appear. To include them, go to the View tab and check the Gridlines box before copying. For custom borders, ensure they are applied to the cell range.
Cannot Edit the Data After Pasting as a Picture
This is the intended behavior. A pasted picture is a static image. You cannot double-click it to edit the numbers or text. If you need to edit the data later, keep the original Excel file. You can also paste a second copy as a linked Excel object if you use Paste Special > Microsoft Excel Worksheet Object.
Copy as Picture vs. Screenshot Tools: Key Differences
| Item | Excel Copy as Picture | Windows Snipping Tool |
|---|---|---|
| Source | Direct from selected Excel cell range | Any visible area on the screen |
| Format Control | Choice between Picture (vector) and Bitmap | Typically saves as PNG or JPEG |
| Included Elements | Only the precise cells selected | Everything in the capture rectangle |
| Ease of Repetition | Easy to repeat with same range | Manual selection each time |
| Best For | Pasting formatted tables into Office apps | Quick captures for emails or documents |
You can now insert Excel tables as clean images into presentations and reports. Use the Picture format in the Copy as Picture dialog for the best quality when resizing. Try using the Windows Key + Shift + S keyboard shortcut for a fast screen clip if you need to include on-screen elements outside Excel. For advanced use, explore the Camera Tool, an old Excel feature you can add to the Quick Access Toolbar for dynamic linked pictures.