Select max or min (smallest or greatest) value cell in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
Excel's MIN or MAX function can only identify the max or min value in a range, but it cannot locate and select the cells containing max or min values. Kutools for Excel’s Select Cells with Max & Min Value tool can help you quickly select the cells with maximum or minimum value.
Select the minimum values of first cell or all cells
Select the maximum values of first cell or all cells
Select the maximum/minimum values of each row or column
Click Kutools >> Select >> Select Cells with Max & Min Value. See screenshots:
 |  |  |
Select the minimum values of first cell or all cells
1. Highlight the range that you want to select the smallest values.
2. In the Select Cells With Max & Min Value dialog box, specify the type of cells to search (formulas, values, or both) in the Look in box.
3. Then check Minimum value from Go to option, and check Cell option in Base section, if you want to select the first matching cell, just choose the First cell only option, to select all the matching cells, please choose All cells option. See screenshot:
4. And then click OK. A prompt box will remind you how many cells will be selected. See screenshot:
5. Click OK. All of the smallest values have been selected. See screenshot:
Select the maximum values of first cell or all cells
1. Select the range and apply this utility.
2. Go to the Select Cells With Max & Min Value dialog box, specify the type of cells to search (formulas, values, or both) in the Look in box.
3. Then check Maximum value from Go to option, then select Cell in the Base section, if you want to select the first matching cell, just choose the First cell only option, to select all the matching cells, please choose All cells option. See screenshot:
4. And then click OK. A prompt box will remind you how many cells will be selected. See screenshot:
5. Click OK. All of the greatest values have been selected. See screenshot:
Select the maximum/minimum values of each row or column
1. Select the range and apply this utility.
2. Go to specify the type of cells to search (formulas, values, or both) in the Look in list box.
3. Then check Maximum value or Minmum value in the Go to section, and check Entire row or Entire column in the Base section, then go to Select section to choose First cell only or All cells. See screenshot:
4. Click Ok, and a prompt box will tell you the number of selected cells, just click OK to close it. Now the maximum value in each row or column have been selected. See screenshot:
| Select Maximum value base on entire row |
 |
| Select Maximum value base on entire column |
 |
Demo: Select the maximum / minimum values in a range or each row or column in Excel
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
