Tip of the Day | Friday May 15th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Extend Selection to the Lowest Used Row

Easily extend your selection of cells downward to the last used row 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 columns, but you only want to extend downward.

Unlike Excel's shortcuts, this tool recognizes the last row that contains any content, including values, formulas, formatting, or other cell usage. This makes it ideal for quickly selecting data, copying formulas, or applying formatting down to the last relevant row without guesswork.

By default, you can launch this tool using the Control+Alt+Shift+↓ shortcut.

Screenshots

Select › Extend Selection to the Lowest Used Row

Starting this tool

Click ASAP Utilities › Select › 9. Extend Selection to the Lowest Used Row
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Choose your language preference below

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

Today's Tip

Download

©1999-2026 ∙ 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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.