What it does
Allows you to select all cells from the currently selected cell(s) to the bottom cell used in the column(s) – similar to the Ctrl-Shift-Down Arrow shortcut, but it will select over blanks.  It can also toggle through two other bottom cells – the bottom cell in the column to the left, and the bottom cell across all used columns.

When to use it
When working with data and selecting to the bottom of the column(s) (or other columns used in your worksheet), this is an efficient way to select it, even if there are many blanks in the column(s).

Why to use it
It’s easier and quicker than using the mouse and built-in keyboard shortcuts, and offers three toggle ranges in one shortcut to help you select data in one or more columns, including blanks.

Default shortcut
None

Other Details

• Category: Productivity / Navigation
• Difficulty: 1/5
• Usage/frequency: 4/5
• Automation factor: 3/5 (estimated 5 seconds saved each time used)
• Type: Shortcut
• Date added: 9/15/2014
• Tags: Select, column, range, blanks, bottom

Related Macros
Select Picker
Select To Right

Other Articles
None

None

Prerequisites
Select one or more cells in the column(s) where you want to select to the last cell in the column(s) (or related columns).

Instructions
With cell(s) selected per the prerequisites above, run the Select To Bottom macro.  It will select to the bottom used cell in the column(s), even including blanks.  Run it again to select to the bottom used cell in the column directly to the left of the active column.  Run it a third time to select to the bottom used cell in the entire worksheet.  Run it again to select back to the bottom used cell in the column(s).