How to Select Multiple Columns in Excel?

To select adjacent columns, click the first column header and drag across the other column headers

To select adjacent columns, click the first column header, hold Shift, and click the last column header

To select non-adjacent columns, click the first column header, hold Ctrl, and click each additional column header

To select all columns in a worksheet, click the Select All button at the top-left corner of the sheet

To select multiple columns using the Name Box, type a range such as A:C or A:A,C:C and press Enter

To select multiple columns with the keyboard, click a column header and use Shift plus arrow keys to extend the selection

To deselect a column from a multi-selection, click another column while holding Ctrl

To select entire columns from cells, click a cell in the column and use Ctrl plus Space, then repeat with Ctrl held for additional columns

Suggested for You

Trending Today