How to Save a Table as an Image in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on August 27, 2023

This tutorial demonstrates how to copy and save a table as an image in Excel.

table as picture excel

Copy a Table as a Picture

Say you have some data in Excel, formatted as a table, and you want to copy the table to a different sheet, a PowerPoint presentation, or a Word document. A table copied as a picture can generally be displayed in any document type.

First, position the cursor in the upper-left corner of a table until it becomes a diagonal arrow, and then click to select the entire table.

select table excel

With the table selected, right-click anywhere in the selected area and choose Copy (or use the keyboard shortcut CTRL + C).

copy table excel

Move to where you want to copy the table as a picture (here, Sheet2, but it could also go to a Word or PowerPoint document).
Right-click where you want to copy the picture. Then click the arrow beside Paste Special and choose Picture.

paste special picture

This copies the table as a picture. If you select the picture, it’s been given a generic picture name (Picture 5) that you can see in the name box. Selecting a picture also adds the Picture Format tab to the Ribbon.

table as picture excel

Save the Table as a Picture

To save a table as an image to your computer, repeat the steps from above to copy and select the table. Then paste it to a drawing program (e.g., Paint) to save it.