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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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
All Courses

From novice to tech pro — start learning today.