ASAP Utilities for Excel - Select Adjacent Matching Cells Below the Active Cell

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.

Starting this tool

Click  ›  Select  ›  7. Select Adjacent Matching Cells Below the Active Cell

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Select  ›  7 Select Adjacent Matching Cells Below the Active Cell

Additional keywords to help you find 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

Merge Contiguous Range Selections

Tip:Alt+P for the previous tool.

Select Adjacent Matching Cells in the Column

Tip: Alt+N for the next tool.

Designed by Excel users for Excel users.
Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

ASAP Utilities helps you save time and do what Excel alone can't.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 28,500+ organizations.

Get Started with ASAP Utilities

Start saving time in Excel with practical tools you can use right away.

Download See What You Can Do

  • No sign-up required.

  • Free 90-day trial