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

Tip: 30+ Excel Shortcuts in 12 minutes
Shortcuts are a great way to save time and energy in Excel, but there are more than 200, so the list can seem overwhelming. In this rapid fire video, we demonstrate more than 30 popular Excel shortcuts you can use to save time every day in Excel. We built this list of shortcuts based on a survey of over 800 Excel users.
Tip: How to select cells with your keyboard
Excel Pros use keyboard shortcuts to power though big worksheets with blazing speed. In this video, we look at some key shortcuts for selecting cells.
Tip: Pivot tables and movie data
A simple example of how you can use pivot tables to analyze all kinds of data, not just sales data. We look at the top 250 movies from IMDB from 2014.
Tip: Shortcuts Recipe Remove Blank Rows
In this video, we'll look at a simple shortcut recipe for removing thousands of blank rows in a large set of data. Shortcut recipes are just a series of shortcuts you perform in a certain sequence to solve a specific problem.
Tip: Use a throwaway chart to sanity check data
In most cases, you'll want to take time to build clean, uncluttered charts that are easy to read. However, a quick, messy chart is a great way to "sanity check" unfamiliar data. A chart can show you patterns and outliers almost instantly. It can even show when data has been faked. Best of all, you get all of this with almost no effort.
This is the best Excel training site I have ever seen. -Kedy
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Shortcuts Video Course
Excel Charts video training course