ColumnCollection Methods
A collection of all columns in a worksheet.
Name | Description |
---|---|
Auto |
Adjusts the width of columns to accommodate cell content. |
Auto |
Adjusts column widths to fit the cell content. |
Auto |
Automatically creates an outline for the specified columns. |
Clear |
Removes an outline of columns. |
Clear |
Clears an outline for the specified columns. |
Clear |
Clears an outline for the specified columns. |
Collapse |
Collapses all the column groups in a worksheet. |
Collapse |
Collapses all column groups starting from the specified level. |
Expand |
Expands all the column groups in a worksheet. |
Group |
Groups the specified columns on a worksheet. |
Group |
Groups the specified columns on a worksheet. |
Hide |
Hides the specified columns in a worksheet. |
Hide |
Hides the specified columns in a worksheet. |
Insert |
Inserts multiple columns and specifies how to format these columns. |
Insert |
Inserts multiple columns into the worksheet. |
Insert |
Inserts a new column into the worksheet at the specified position. |
Insert |
Inserts multiple columns and specifies how to format these columns. |
Insert |
Inserts multiple columns into the worksheet. |
Insert |
Inserts a column with the specified heading into the worksheet. |
Remove |
Removes columns that match the specified condition from the worksheet. |
Remove |
Removes columns that match the specified condition from the worksheet. |
Remove |
Removes columns that match the specified condition from the worksheet. |
Remove |
Removes multiple columns from a worksheet. |
Remove |
Removes the column at the specified position from the worksheet. |
Remove |
Removes multiple columns from a worksheet. |
Remove |
Removes a column with the specified heading from the worksheet. |
Un |
Ungroups the grouped columns on a worksheet. |
Un |
Ungroups the grouped columns on a worksheet. |
Unhide |
Displays the hidden columns on a worksheet. |
Unhide |
Displays the hidden columns on a worksheet. |
See Also