Select entire column

Windows	Mac
CtrlSpace	⌃Space

About This Shortcut

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.

Video thumbnail for Shortcuts for Excel Tables

Excel Shortcuts

3:17

Working with table rows and columns

Video thumbnail for Use a throwaway chart to sanity check data

Core Charts

2:53

Use a throwaway chart to sanity check data

Video thumbnail for How to add unique count to a pivot table

Core Pivot

3:27

How to add unique count to a pivot table

Core Excel

2:09

Shortcuts for selecting cells in Excel

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

I want to thank you for this website. I have it bookmarked and use it often for my job. Incredible documentation and well presented with examples. An invaluable resource!

Erik

More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles