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

Additional keywords to help you find this tool:
Find lowest value in Excel, Select smallest number, Highlight minimum value, Find and select lowest value, Identify smallest number in a range, Select all cells with the lowest value, Find and highlight the smallest value, How to locate the smallest value in a range

Tip:Alt+P for the previous tool.