Topics

Jan 15, 2012

How to delete multiple columns in Excel 2007?

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