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 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 show you how some of Excel's shortcuts for selecting cells.
In this video, we look at how to use a pivot table to analyze movie data by rating, runtime, genre, and more.
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.