Log in  \/ 
x
or
x
x
Register  \/ 
x

or

How to easily copy and pasted range or chart as picture in Excel?

In some cases, you want to copy and paste a range or char as picture so that it only can show the data but cannot be edited. In this tutorial, I will tell you the methods to easily copy and pasted range or char as picture in Excel.

doc paste range as picture 1

Copy and paste range or chart as picture with Copy as Picture function

Copy and paste range or chart as picture with Kutools for Excel good idea3

Export all charts as gif/tif/jpeg/png with Kutools for Excel good idea3

Export range as image with Kutools for Excel good idea3


goodExport Range to File

Kutools for Excel's Export Range to File function can export or save a range to separate file as
workbook, pdf, text, csv or text.
Click Enterprise > Import/Export > Export Range to File.
doc export cell range to file

arrow blue right bubble Copy and paste range or chart as picture with Copy as Picture function


In Excel, you can use the Copy as Picture function to quickly copy and paste range or chart.

Kutools for Excel, with more than 120 handy Excel functions, enhance working efficiency and save working time.

1. Select the range or chart you want to copy and paste as picture, then click Home > Copy > Copy as Picture. See screenshot:

doc paste range as picture 2

2. In the opening Copy Picture dialog box, specify the options based on your needs, and click the OK button.

doc paste range as picture 3

3. Select a location to paste the picture, and press Ctrl + V to paste the picture.

doc paste range as picture 4

Note: This method does not work in Excel 2007.


arrow blue right bubble Copy and paste range or chart as picture with Kutools for Excel

If you have Kutools for Excel, you can save the range or chart as auto text entry, and then insert the range or chart as picture at any time if you need.

Kutools for Excel, with more than 120 handy Excel functions, enhance working efficiency and save working time.

1. Click Kutools > Insert > AutoText. See screenshot:

doc paste range as picture 5

2. An Auto Text pane pops out and select the range you want to add to auto text, then click doc add . See screenshot:

doc paste range as picture 6

3. Then specify a name for this new auto text, and then select a group you want to add to. See screenshot:

doc paste range as picture 7

4. Click Add to finish the auto text adding.

When you need to insert this range as picture, just need to select a cell that locate the picture, then enable the auto text pane, and click the beside the range, and click Insert as > Picture (EMF).

doc paste range as picture 8


arrow blue right bubble Export all charts as gif/tif/jpeg/png with Kutools for Excel

If you have Kutools for Excel, you also can export all charts of a workbook as gif, tif, png or jpeg images to a specified folder.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

1. Enable the workbook you want to export the charts, and click Enterprise > Import/Export > Export Graphics. See screenshot:

doc paste range as picture 9

2. In the popped out dialog,

1) Select the graphic type you want to export from the Types drop down list;

2) Then select a directory to out put the graphics;

3) Select the picture format you want from Export format drop down list.

doc paste range as picture 10

3. Click the Ok button. A dialog pops out to tell you how many pictures have been successfully exported.

doc paste range as picture 11

4. Click OK to close it, and go to the directory you specify to view the exported pictures.

doc paste range as picture 12

pay attention1If you are interested in this addi-in, click here to download the 60-days free trial.


arrow blue right bubble Export range as image with Kutools for Excel

With Kutools for Excel, you can use Export Range as Graphic utility to export a range as png/tif/jpeg/gif picture.

Kutools for Excel, with more than 120 handy Excel functions, enhance working efficiency and save working time.

After free installing Kutools for Excel, please do as below:

1. Select a range you want to export as image, and click Enterprise > Import/Export > Export Range as Graphic. See screenshot:

doc paste range as picture 13

2. In the Export Range as Graphic dialog, select the save directory you want, and then select the image format you need from the Export format drop down list.

doc paste range as picture 14

3. Click Ok, and another dialog pops out for naming the range, in default, it is named based on the range reference.

doc paste range as picture 15

4. Click Ok, and a dialog pops out to remind you the range has been exported successfully, just close it. And you can go to the directory to find the range image.

doc paste range as picture 16

pay attention1If you are interested in this addi-in, click here to download the 60-days free trial.

You may be interested in:


The Best Office Productivity Tools

Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.