How to Paste as a Picture in Excel 2010

Data in Microsoft Excel 2010 can be formatted in a lot of different ways, and some of those ways will result in information that can be difficult to manage.

This is especially true if you need to print some information and Excel isn’t printing what you can see on your screen or Excel is crashing when you attempt to print a spreadsheet with a lot of external data links.

A convenient way around this problem is to copy the data that you want to print, then paste it into a different worksheet as a picture.

As an Amazon affiliate, I earn from qualifying purchases.

Paste as an Image in Excel 2010

This article will focus on copying and pasting between worksheets in Excel, but you can also re-copy the pasted image to another program, such as OneNote, Word, or Microsoft Paint.

I have found pasting into OneNote to be particularly helpful if the image won’t comfortably fit on one page, as OneNote will automatically print on multiple pages as needed.

Step 1: Open your spreadsheet in Excel 2010.

Step 2: Use your mouse to highlight the data that you want to turn into a picture.

select the data you want to copy and paste

Step 3: Press Ctrl + C or right-click on the selected data and choose the Copy option.

how to paste as a picture in Excel 2010

Step 4: Click the Insert Worksheet tab at the bottom of the window.

click the Insert worksheet tab

Step 5: Click the Paste button in the Clipboard section of the ribbon at the top of the window, then click the Picture option.

select the paste as picture

Are you looking for a good, affordable way to edit images? Adobe Photoshop Elements has all of the tools that you will need for common image editing needs. If you need a more advanced tool, however, check out the Photoshop CS6 subscription option. It requires a much lower upfront cost than the retail version of Photoshop.

Now that you know how to paste as a picture in Excel 2010, you can use this option for copied content instead of traditional options.

You can read this article to learn the steps needed to insert your copied Excel picture into Word.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy