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 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 lesson, we demonstrate a shortcut recipe you can use to remove blank rows quickly.
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 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 work with rows and columns to structure data in an Excel Table.