Taking a picture of a large Excel spreadsheet that doesn't fit on computer screen

I reated a dashboard in excel.  It's big and on one sheet.  I want to take a picture of it so I can send it to someone, and maybe put it in a pdf and print it.  I can't do a screen capture because of it's size, and would prefer not to have to make multiple screen captures and splice them together in Photoshop.  How can I do it?

Excel 2013 in Windows


Who is Participating?
Barry CunneyConnect With a Mentor Commented:
Would the Excel Camera Tool be an option for you
Hi John,

how about using a very simple macro?

First, select the area you need and then run this short code:

Sub CopyBigAreaOfCells()

    Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture

End Sub

Open in new window

Or use a printer driver that outputs to PDF and tell windows that you have inserted a huge pice of paper into that printer. PdfCreator can 'print' to sheets of size A0.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

GeisrudSystems AdministratorCommented:
Any chance you have Acrobat (full version, not the reader)?  

If so,  set your print area, Print to Adobe PDF, and under scaling, select the option to "Fit Sheet on One Page"
all of the above I found interesting, great stuff

but as the the recipient of this massive image, what am I to do with it?
I might actually prefer it screen x screen

your convenience isn't necessarily convenient to the end-user

- just a non-technical observation

(and yes, before flaming me, I know pdf reader's zoom :)
macro can do this:
determine the range for which the snapshot is to be done
split into slices (rows x columns)
save each picture as a file
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.