To delete multiple columns, you have to select the columns
that you need to delete first. The selection of columns can be adjacent or
non-adjacent.
To select adjacent columns (for example, columns B, C, D, E,
and F), click the column B in the column header area. Press the SHIFT key and
click the column F in the column header area.
To select non-adjacent columns (for example, columns B, H,
J, N, and P), click the column B in the column header area. Press the CTRL key
and click the columns H, J, N, and P in the column header area.
Once the columns selection is over, on the Home tab, in the
Cells group, click the down arrow in Delete and click Delete Sheet Columns.
Alternately,
you can right-click on any selected column in the column header and click
Delete.
0 comments:
Post a Comment