• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 190
  • Last Modified:

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?
0
Dov_B
Asked:
Dov_B
  • 4
  • 3
1 Solution
 
urthrilledCommented:
What version of Excel are you using?  Have you tried the Fit to Page option?
0
 
Dov_BAuthor Commented:
ms excel 2010
0
 
Dov_BAuthor Commented:
i am using ms excel 2010:where is that option found?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
urthrilledCommented:
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
 
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now