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 selecting cells

Excel Shortcuts

2:27

Shortcuts for selecting cells in Excel

Video thumbnail for Shortcut recipe: remove specific rows

Excel Shortcuts

2:58

Shortcut recipe: remove specific rows

Video thumbnail for Shortcuts for Excel Tables

Excel Shortcuts

3:17

Pivot Table Example - IMDB Movie data

Video thumbnail for Working with table rows and columns

Excel Tables

3:28

Working with table rows and columns

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've found your site invaluable as I steadily increase my confidence in Excel! As a manager, I'm also conscious of the development of my team, and since your site has a variety of detailed explanations for each process, its an amazing resource for all types of learners.

Amy

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