Ms excel vba : macro that will take the number of cells i need to fit on the page and automaicly size them to the largest possible

I am constantly wasting time tweeking the size of cells to get the number I need to fit on the page to fit. Is there a way to do this progrmaticly or is there an excel button for that?
Dov_BAsked:
Who is Participating?
 
urthrilledConnect With a Mentor Commented:
You can find it in a couple of places:

File > Print > Scaling

Home > Page Layout > (then click just to the right of the Section Header that says Scale to Fit)
0
 
urthrilledCommented:
What version of Excel are you using?  Have you tried the Fit to Page option?
0
 
Dov_BAuthor Commented:
ms excel 2010
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Dov_BAuthor Commented:
i am using ms excel 2010:where is that option found?
0
 
Dov_BAuthor Commented:
Thanks but I dont think that is waht I amlooking for that will shrink things. I want something that perhaps should becalled resize to fit
0
 
urthrilledCommented:
Sorry, I don't know of any other way, other than fit to page.

Have you tried the Justified and Distributed settings?  I've never used them, but you might see if they will work for you.
0
 
Dov_BAuthor Commented:
where are they to be found?
0
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.