Extend Selection to the Rightmost Used Column

ASAP Utilities › Select › 10. Extend Selection to the Rightmost Used Column

Easily extend your selection of cells to the right until the last used column in your worksheet without scrolling manually. This tool is especially useful when Excel's built-in shortcuts don't work as expected:

'Control+Shift+→' stops at empty cells, which can be limiting if your data has gaps.

'Control+Shift+End' selects extra rows, but you only want to extend horizontally. Unlike Excel's shortcuts, this tool recognizes the last used column that contains any content, including values, formulas, formatting, or other cell usage. Use it to quickly copy a formula to the rightmost used column or extend your selection without scrolling to find the last relevant column. By default, you can launch this tool using the Control+Alt+Shift+↓ shortcut.

Screenshots

Select › 10 Extend Selection to the Rightmost Used Column

Starting this tool

Click ASAP Utilities › Select › 10. Extend Selection to the Rightmost Used Column
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
select until last used column in Excel, extend selection to the rightmost used column, expand selection beyond the first nonblank cell, select to last populated column, shortcut to extend selection to the right, extend selection horizontally, continue selection past first blank cell in Excel, how to extend selection past first nonblank cell, Excel shortcut to expand selection to last column, How do I select until the last used column in Excel?, Why does Ctrl+Shift+Arrow stop at blank cells in Excel?

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Extend Selection to the Lowest Used Row

Jump to the First Different Value in a Selection

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.