How To Select Entire Column In Excel?

Click the column letter at the top of the column

Use the keyboard shortcut Ctrl + Space

On Mac, use Command + Space

To select multiple adjacent columns, drag across the column letters

To select non-adjacent columns, hold Ctrl and click each column letter

To select all columns in the worksheet, click the Select All button at the top-left corner or press Ctrl + A twice

Suggested for You

Trending Today