Exceljet

Quick, clean, and to the point

Select table column

Windows shortcut 
CtrlSpace
Mac shortcut 
⌃Space

This shortcut selects one or more table columns in a table, when the cursor is in an Excel table. Behavior changes as the shortcut is used more than once. First time: column data. Second time: column data + column header. Third time: entire worksheet column.

222 Excel Shortcuts for Windows and Mac

Related videos

Tip: Shortcuts for Excel Tables
Shortcuts for Excel Tables
Excel has great support for shortcuts in tables. Shortcuts for inserting, selecting, and deleting rows and columns all work much better! Watch the video to see how.
Tip: How to build a simple dynamic chart
How to build a simple dynamic chart
In this video, we look at how to build a chart that automatically includes new data, and dynamically highlights the top and bottom values. This is an easy way to create an interactive chart for dashboards and other reports.
Tip: How to plot survey data in a bar chart
How to plot survey data in a bar chart
In this video, we demo how to plot results from a survey question in an Excel bar chart. Along the way, we use the COUNTIF function to build a summary table, and show a simple technique for creating an "other" bucket.
Tip: How to use VLOOKUP with an Excel Table
How to use VLOOKUP with an Excel Table
This video shows how to setup VLOOKUP with a table, and how to use the MATCH function inside VLOOKUP to generate a dynamic column index. This makes it easy to refer to columns by name inside VLOOKUP, instead of hardcoding the column number. As a bonus, you can reorder the columns and the formula will keep working correctly.