logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Select Adjacent Matching Cells Below the Active Cell

ASAP Utilities  › Select  ›  7. Select Adjacent Matching Cells Below the Active Cell

This tool expands your selection 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.

Screenshots

Select  ›  7 Select Adjacent Matching Cells Below the Active Cell

Starting this tool


Select  ›  7 Select Adjacent Matching Cells Below the Active Cell
Additional keywords for this tool:
select adjacent cells in Excel, expand selection , auto-select matching cells , select similar values below , Excel select continuous matching cells, how to select all matching cells below , Excel select range of similar values, auto-expand selection based on value , Excel select downward matching values, find and select adjacent cells

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Merge Contiguous Range Selections




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


🏆 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.