Exceljet

Quick, clean, and to the point

Select entire column

Windows shortcut 
CtrlSpace
Mac shortcut 
Space

This shortcut will select the entire column of the current selection. If the current selection spans multiple columns, all columns that intersect the current selection will be selected.

Related videos

The videos below demonstrate this shortcut.
In this lesson, we cover shortcuts you can use when working with Excel Tables.
In this lesson, we demonstrate a shortcut recipe you can use to remove rows that meet specific criteria quickly.
In this video, we'll look at how to use a "throwaway" chart to explore data. This is an easy way to quickly size up data.
In this video, we'll look at how to get a unique count in a pivot table. This feature is hidden by default in a normal pivot table.
In this video, we show you how some of Excel's shortcuts for selecting cells.