Solved

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

Posted on 2013-06-24
7
134 Views
Last Modified: 2014-01-11
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
Comment
Question by:Dov_B
  • 4
  • 3
7 Comments
 
LVL 4

Expert Comment

by:urthrilled
ID: 39272471
What version of Excel are you using?  Have you tried the Fit to Page option?
0
 

Author Comment

by:Dov_B
ID: 39272478
ms excel 2010
0
 

Author Comment

by:Dov_B
ID: 39272480
i am using ms excel 2010:where is that option found?
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 4

Accepted Solution

by:
urthrilled earned 500 total points
ID: 39272501
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
 

Author Comment

by:Dov_B
ID: 39272517
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
 
LVL 4

Expert Comment

by:urthrilled
ID: 39272765
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
 

Author Comment

by:Dov_B
ID: 39273218
where are they to be found?
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now