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

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.