In this video I explain 2 keyboard shortcuts to select a column that contains blank cells in Excel.

-- LINKS --
DOWNLOAD THE MACRO ► https://www.excelcampus.com/keyboard-shortcuts/select-column-blank-cells/**

*** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM***
https://www.excelcampus.com/join-elevate/

~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) https://www.excelcampus.com/blueprint ~

~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: https://www.excelcampus.com/newsletter/

-- Keyboard Shortcuts for Selecting Columns with Blank Cells --

It can be difficult to select a column of the used range or current region of data in Excel. Especially when the column contains blank cells.

The first technique requires that the data be in an Excel Table. The keyboard shortcut to select an entire column in a Table is Ctrl+Space.

When the active cell (the cell the user has selected) is in the body of the table, the entire column of the data body range will be selected when pressing Ctrl+Space.

Press Ctrl+Space a 2nd time to include the header cell in the selection.

Press Ctrl+Space a 3rd time to select the entire column of the sheet.

The 2nd technique uses a macro to attempt to select the column of used data on a regular range.

We can store the macro in our Personal Macro Workbook and assign a keyboard shortcut to it to run the macro.

Get the VBA macro code at: https://www.excelcampus.com/keyboard-shortcuts/select-column-blank-cells/

Other videos mentioned in this video:
Beginners Guide to Excel Tables: https://youtu.be/fJnJTff4Na8
4-part Video Series on the Personal Macro Workbook: https://youtu.be/rD2-mSbTuL0
New Video on How to Move the Selection with a Shortcut: https://youtu.be/KM8MYrdaoNc
00:00 Introduction
00:44 Using an Excel Table
01:07 Control Space
02:03 Current Region
03:42 Select Entire Column