Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Copy and Paste Excel Table as a Picture

Date:2019-10-7 Author:Cordelia

Sometimes you need to cite some data in an Excel spreadsheet, or display it to someone else, but don’t want the format to be messed up or the content to be tampered. In this case, you can try to copy or paste the table as a picture. It works a bit like screenshot, except that you don’t need any third-party tool.

How to Copy as Picture

1. First of all, select the specific range of cells you want to copy.

How to Copy and Paste Excel Table as a Picture

2. Click Copy in Home tab and choose Copy as Picture… in the drop-down list.

How to Copy and Paste Excel Table as a Picture

3. When the Copy Picture window pop out, make choices in Appearance and Format, then hit OK to confirm the setting.

How to Copy and Paste Excel Table as a Picture

4. Right-click anywhere you want to paste the picture (no matter in Excel, Word, or other apps), hit Paste button in the menu.

Of course, you can press [Ctrl+V] to paste the picture as well.

How to Copy and Paste Excel Table as a Picture

5. Pictures created in this way can be moved and resized freely, and you don’t need to worry about tampering the data accidentally.

How to Copy and Paste Excel Table as a Picture

How Paste as Picture

1. Select the area you want to copy. Click Copy button in Home tab or just press [Ctrl+C] on your keyboard.

How to Copy and Paste Excel Table as a Picture

2. Switch to the Excel sheet or Word document you want to paste the table, click the small arrow below Paste to expand the menu. Find and hit the Picture button.

How to Copy and Paste Excel Table as a Picture

3. The table will be pasted as a picture at the place of the cursor.

How to Copy and Paste Excel Table as a Picture

Note: although the 2 methods are both effective, you can only use Paste as Picture between Office apps, since a specific option of pasting is needed in this case.

If you want to paste a table as picture in any other software, you should either 1) choose the way to Copy as Picture, 2) Paste as Picture in the same Excel sheet first and then copy it to other place.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

2 thoughts on “How to Copy and Paste Excel Table as a Picture”

  1. copy and paste text and code says:

    Good info. Lucky me I recently found your website by accident
    (stumbleupon). I have book-marked it for later!

    1. Olivia says:

      Hi there,
      Appreciate your support and we’ll keep trying to provide better content.

Leave a Reply

Your email address will not be published. Required fields are marked *