Tip of the Day | Sunday 4 October 2026

Discover new tools to get things done.

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 ASAP Utilities  ›  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
Today's Tip

Tip:Alt+P for the previous tool.