Forum Discussion
scaling graph paper
I would like to use Excel graph paper and make each square equal to 3/32 of an inch. How do i do this?
I am trying to make a ruler in excel. When I try to do the columns to .125 it uses .13. and printing out what should be 10" it comes out about 9.5" in width.
Suggestions?
The .13" is to be expected, as I explained in my previous reply. The column width dialog rounds the number to 2 decimal places, but when you inspect it in VBA, it turns about to be .125".
Printing in Excel is frustrating - the printed output seldomly matches the on-screen display. You'll have to experiment and use trial-and-error to get it right.