Tip of the Day | Tuesday May 7th, 2024
Discover new tools to get things done.
Extend selection to the last used row
This utility will extend your selected range to the last used row on your worksheet.This way you can easily extend your selection without having to scroll down.
This is very useful when you cannot use Excel's built in shortcuts such as 'Control+Shift+↓' because of empty cells in between or 'Control+Shift+End' because you only want to extend your selection down and not include the columns to the right.
You can for example use this to quickly copy a formula down to the last used row without having the difficulty of scrolling and finding the end of your data manually.
By default you can start this utility with the shortcut Control+Alt+Shift+↓.
Screenshots
Starting this tool
- Click ASAP Utilities › Select › 9. Extend selection to the last used row
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years