How To Easily Copy And Pasted Range Or Chart As Picture In Excel?

Capturing and sharing specific data or visualisations from Excel worksheets is a crucial ability that can improve your communication and presentation skills. Whether you want to insert an image into a report, include it in a presentation, or simply save it as a separate image, Excel provides a simple way to do so. This tutorial will walk you through the steps of copying and pasting a range or chart as an image in Excel. We'll go over both the Windows and Mac versions of Excel, so that users on all systems can benefit from the instructions.

By the end of this tutorial, you'll know how to pick and copy the desired range or chart, as well as how to paste it as an image into other apps like Word, PowerPoint, or image editing software. Let's get started and see how to quickly copy and paste a range or chart as a picture in Excel!

Easily Copy And Pasted Range Or Chart As Picture

Here we can use the copy as picture function to complete the task. So let us see a simple process to know how you can easily copy and paste a range or chart as a picture in Excel.

Step 1

Consider any Excel sheet.

First, select the range of cells, then click on copy under home and select copy as picture.

Select cell > Home > Copy > Copy as picture.

Step 2

Then set Appearance to "Show on screen," set Format to "Picture," and click OK.

Appearance > Format > Ok.

Step 3

Then use CTRL + V to paste the data as a picture.

You can follow the same steps when dealing with the charts.

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can easily copy and paste a range or chart as a picture in Excel to highlight a particular set of data.

Pradeep Kumar

e

Updated on: 13-Jul-2023

46 Views

Kickstart Your Career

Get certified by completing the course

Get Started