Tip of the Day | Saturday 13 June 2026

Discover new tools to get things done.

Select Cells Containing the Lowest Value

Quickly find and select all cells that contain the lowest value in your selection or across the entire worksheet.

  • If multiple cells are selected, the tool finds and selects the cells with the lowest value within your selection.
  • If only one cell is selected, it scans the entire worksheet and selects all cells of the lowest value.

This tool uses Excel's =MIN() function to identify the smallest number and select every matching cell.

Starting this tool

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

Tip:Alt+P for the previous tool.