Forum Discussion
scaling graph paper
Switch to Page Layout view.
Click the button at the intersection of the row headers and column headers to select the entire sheet.
On the Home tab of the ribbon, in the Cells group, select Format > Row Height.
Enter 0.09375" in the box and press Enter or click OK.
Do the same for Format > Column Width.
Remark: if you later select Format > Row Height or Format > Column Width, Excel will show 0.09":
but the actual value will be correct, as confirmed by Visual Basic:
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.