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
155 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

825 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