scaling graph paper

Copper Contributor

I would like to use Excel graph paper and make each square equal to 3/32 of an inch.  How do i do this?

1 Reply

@Leon1730 

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":

HansVogelaar_0-1679046044070.png

but the actual value will be correct, as confirmed by Visual Basic:

HansVogelaar_1-1679046095749.png