How to Save an Excel Table As an Image

by

Excel is a great way to store, compute, and sort information; however, there may be times when you want to save the tables in Excel as images for use on the web, brand print material, or for training.

Use the Copy Feature in Excel to Save an Excel Table as an Image

  1. Highlight the table that you want to save as an image.
Image showing a highlighted table in Excel.

  1. Click the down arrow next to the Copy button in the Clipboard group and click the “Copy as Picture…” selection.
Image showing the Copy As Picture option in Excel.

  1. Open up your favorite image editor. You can use Paint™, Paint 3D™, Photoshop™,  GIMP™, or Photos™ on Mac™. For this tutorial, we will use Paint™.
Image showing a blank canvas in Paint.

  1. Click the Paste option in Paint, and the image appears on the canvas.
Image showing the Paste option in Paint.

  1. Resize the canvas by moving the small white rectangles on the canvas with the mouse so that they match the size of the picture.
Image showing the Canvas resizing handles in Paint.

  1. Edit the image as needed and save the file.
Image showing an Excel table pasted into Paint with the canvas cropped to size.

Use the Print Screen Button to Save an Excel Table as an Image

  1. Open the worksheet you wish to save as an image and press the Print Screen (PrtScr) button on your keyboard.
Image showing a worksheet table in Excel.

  1. Open a new canvas in your image editing software, and press CTRL + V or CMD + V if you use a Mac.
Image showing a portion of the Paint application in Windows.

  1. The screenshot will appear on the canvas and will need editing to isolate the Excel table from the complete image.
Image showing Excel table pasted into Paint after Print Screen shortcut.

Note: if your keyboard does not have a Print Screen button, Windows users can use the Fn + Windows Logo Key + Space Bar combination to take a screenshot. Mac users can take a screenshot with CMD + Shift + 3 together.

Use Shortcut Keys to Save an Excel Table as an Image 

  1. Once your worksheet is open in Excel, press CTRL + C or CMD + V for a Mac to store the picture in the computer’s memory.
Image showing a worksheet table in Excel.

  1. Open your image software and press CTRL + V or CMD + V on a Mac to paste the picture on the blank canvas.
Image showing Excel table pasted into Paint after Print Screen shortcut.

  1. Edit the picture to fit your needs.
Image showing an Excel table pasted into Paint with the canvas cropped to size.

Conclusion

Now you have discovered the different methods for saving an Excel table as an image. Explore the many other topics on our blog to continue increasing your knowledge of Excel.

You can also save the data or workbook without formulas if you want another option of saving the Excel table.

Leave a Comment

Previous

How to Remove Hyperlink in Excel?

Next

How to Unsort in Excel: Revert to Original Data