Skip to main content

Kutools for Office ā€” One Suite. Five Tools. Get More Done.

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

Author Sun Last modified

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.

copy and pasted cells or chart as picture

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

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.

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

click Home > Copy > Copy as Picture

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

specify the options in the dialog box

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

press Ctrl + V to paste the picture

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 offers over 300 advanced features to streamline complex tasks, boosting creativity and efficiency. Itegarate with AI capabilities, Kutools automates tasks with precision, making data management effortless. Detailed information of Kutools for Excel...         Free trial...

1. Click Kutools > Insert > Resource Library. See screenshot:

click Resource Library feature of kutools

2. The Resource Library pane pops out and select the range you want to add to the Resource Library, then click  add button . See screenshot:

select the data and click add button

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

specify a name for this new item

4. Click Add to finish.

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

click Insert as > Picture   the range is inserted as picture

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.

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

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

click Export Graphics feature of kutools

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.

specify options in the dialog box

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

A dialog pops out to tell how many pictures have been exported

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

go to the directory to view the exported pictures

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.

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

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

click Export Range as Graphic feature of kutools

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.

select the save directory and the image format

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

give a name in the textbox

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.

go to the directory to find the range image

You may be interested in:

Best Office Productivity Tools

šŸ¤– Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functionsā€¦
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language ā€“ supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

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!

All Kutools add-ins. One installer

Kutools for Office suite bundles add-ins for Excel, Word, Outlook & PowerPoint plus Office Tab Pro, which is ideal for teams working across Office apps.

Excel Word Outlook Tabs PowerPoint
  • All-in-one suite ā€” Excel, Word, Outlook & PowerPoint add-ins + Office Tab Pro
  • One installer, one license ā€” set up in minutes (MSI-ready)
  • Works better together ā€” streamlined productivity across Office apps
  • 30-day full-featured trial ā€” no registration, no credit card
  • Best value ā€” save vs buying individual add-in