Tip of the Day | Saturday August 30th, 2025
Discover new tools to get things done.
Select Adjacent Matching Cells in the Column
This tool expands your selection upward and downward to include all adjacent cells in the same column with the same value as the active cell. The selection stops when it reaches a cell with a different value.This makes it easy to select grouped data quickly without manually clicking or dragging. By default, you can launch this tool using the Control+Alt+A shortcut.
Screenshots
Starting this tool
- Click ASAP Utilities › Select › 8. Select Adjacent Matching Cells in the Column
- 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 ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
©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.
🏆 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.