Select Adjacent Matching Cells in the Column

ASAP Utilities › Select › 8. 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...

Additional keywords for this tool:
select adjacent cells in column Excel, expand selection in Excel column, auto-select matching cells, select continuous matching values, select range of same values in column, how to select all adjacent matching cells in a column in Excel, Excel select similar values in a column, select grouped data in Excel column automatically, Excel auto-expand selection in column, find and select adjacent values in Excel column

Choose your language preference below

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

Select Adjacent Matching Cells Below the Active Cell

Extend Selection to the Lowest Used Row

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.