Equivalent to choosing the Width command on the Column submenu of the Format menu. Changes the width of the columns in the specified reference.
Syntax
COLUMN.WIDTH(width_num, reference, standard, type_num, standard_num)
COLUMN.WIDTH?(width_num, reference, standard, type_num, standard_num)
Width_num specifies how wide you want the columns to be in units of one character of the font corresponding to the Normal cell style. Width_num is ignored if standard is TRUE or if type_num is provided.
Reference specifies the columns for which you want to change the width.
If reference is specified, it must be either an external reference to the active worksheet, such as !$A:$C or !Database, or an R1C1-style reference in the form of text, such as "C1:C3", "C[-4]:C[-2]", or "Database".
If reference is a relative R1C1-style reference in the form of text, it is assumed to be relative to the active cell.
If reference is omitted, it is assumed to be the current selection.
Standard_num is a logical value corresponding to the Standard Width command from the Column submenu on the Format menu.
If standard is TRUE, Microsoft Excel sets the column width to the currently defined standard (default) width and ignores width_num.
If standard is FALSE or omitted, Microsoft Excel sets the width according to width_num or type_num.
Type_num is a number from 1 to 3 corresponding to the Hide, Unhide, or AutoFit Selection commands, respectively, on the Column submenu of the Format menu.
| Type_num | Action taken |
| 1 | Hides the column selection by setting the column width to 0 |
| 2 | Unhides the column selection by setting the column width to the value set before the selection was hidden |
| 3 | Sets the column selection to a best-fit width, which varies from column to column depending on the length of the longest data string in each column |
Standard_num specifies how wide the standard width is, and is measured in points. If standard_num is omitted, the standard width setting remains unchanged.
Remarks
Changing the value of standard_num changes the width of all columns except those that have been set to a custom value.
If any of the argument settings conflict, such as when standard is TRUE and type_num is 3, Microsoft Excel uses the type_num argument and ignores any arguments that conflict with type_num.
If you are recording a macro while using a mouse and you change column widths by dragging the column border, Microsoft Excel records the references of the columns using R1C1-style references in the form of text.
Related Function
ROW.HEIGHT Changes the heights of rows
Return to index