Select Multiple Columns in Excel

In order to select a column in Excel, you click a column letter.

You can also select the entire column by using Ctrl + Space shortcut.

Selecting multiple Columns

If you want to select more than one column, you have to click a column letter and then drag your cursor to the column letter where you want to stop.

You can also select multiple columns by selecting cells in a row and then pressing Ctrl + Space.

The last method to select multiple adjacent cells is by using the Shift key. Just click the first column letter and then, while holding Shift, press the last column letter. All columns between these two are going to be selected.

Selecting multiple non-adjacent Columns

So far we selected columns that are adjacent. But what if you want to select multiple columns that are non-adjacent? It’s a simple task. Instead of using Shift, use Ctrl.

Just click the first column and then click another one you want to select. If you click the same column one more time, you are going to deselect it.

You can also make a combination of these methods. For example, Drag a few columns and then hold Ctrl to deselect the ones you don’t want to select.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.