Column Measurement Defaults

gary_marshall

New Member
Joined
Apr 7, 2004
Messages
7
Can I change the default measurements for the columns to something else (inches). I am trying to fill in a form that has boxes, check off boxes, etc. and it would be easier if the column width defaults could be set to inches.

Thanks in advance for your advice.

Gary Marshall
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
Hi marshall,
Use this in your required excel workbook, in the Workbook_Open event. It will get you almost to one inch cells........!

Private Sub Workbook_Open()
With Cells
.ColumnWidth = 13.3
End With
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,645
Members
412,335
Latest member
cinciri99
Top