How to Copy & Paste Range or Object as Picture in Excel

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on March 26, 2023

This tutorial demonstrates how to copy and paste as a picture in Excel.

 

copy paste as picture 3 new1

 

Copy and Paste as a Picture

In Excel, you can copy and paste a data range as a picture. See the data in Columns B and C in the picture below. To copy and paste it as a picture, follow these steps:

 

copy paste as picture initial data new1

 

  1. Select the data range (here, B1:C10), right-click anywhere in the selected area, and click Copy (or use the keyboard shortcut CTRL + C).

 

copy paste as picture 1 new1

 

  1. Right-click where you want to paste the range as a picture, click on the arrow next to Paste Special, and choose Picture.

 

copy paste as picture 2 new1

 

As you can see below, the copied range is pasted as a picture.

 

copy paste as picture 3 new1

 

If you click on the picture, you can find the picture name in the name box (Picture 13). Also, you get the picture frame that can be used to resize the picture.

Copy and Paste a Chart as a Picture

You can also copy a chart (or another object) as a picture in Excel.

 

copy paste as picture 8 new1

 

  1. First, add a chart from the Product–Revenue data. Select the data range (B1:C8) and in the Ribbon, go to Insert > Recommended Charts. Then choose a chart.

 

copy paste as picture 4 new1

 

  1. Select the chart, right-click it, and choose Copy (or use the keyboard shortcut CTRL + C).

 

copy paste as picture 5 new1

 

  1. Right-click the cell where you want to paste the chart as a picture and click Paste Special.

 

copy paste as picture 6 new1

 

  1. In the Paste Special window, choose the PNG picture format. (Here you could also choose different picture formats, such as JPEG, GIF, etc.)

 

copy paste as picture 7 new1

 

Notes

  • In a similar way, you can also copy a table as a picture in Excel.
  • You can also use VBA code to use Paste Special options.
  • Unfortunately, Google Sheets doesn’t support copying as a picture.

AI Formula Generator

Try for Free

See all How-To Articles