Dov_B
asked on
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?
What version of Excel are you using? Have you tried the Fit to Page option?
ASKER
ms excel 2010
ASKER
i am using ms excel 2010:where is that option found?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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.
Have you tried the Justified and Distributed settings? I've never used them, but you might see if they will work for you.
ASKER
where are they to be found?