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

Thanks,

John
cipriano555Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Barry CunneyCommented:
Hi
Would the Excel Camera Tool be an option for you
http://www.youtube.com/watch?v=N4TabUo2Ezg
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnnyho_Commented:
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



Regards,
Jan
0
msifoxCommented:
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.
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Joe RudSystems 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"
0
PortletPaulfreelancerCommented:
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 :)
0
johnnyho_Commented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.