DEV Community

loading...

How to Select Maximum or Minimum Values Cells in Excel Office 365?

excelgeek profile image Andrews Originally published at geekexcel.com on ・5 min read

In this article, we will explain the steps to Select Max or Min Value Cell in Excel Office 365 using Kutools with clear-cut examples. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

Select the Minimum Values of First Cell or All Cells:

To select the minimum values from a range in Excel, do as follows.

  • First, you need to select the range that you want to select the smallest values.

Select the range
Select the range

  • On the kutools Tab, click the Select option, then choose the Select Cells with Max & Min Value option from the listed menu.

Kutools Tab
Kutools Tab

  • Next, it will display the Select Cells With Max & Min Value dialog box.
  • Look in – Here, you need to specify the type of cells (formulas, values, or both) that you want to search.
  • Go to – In this section, you need to select the Minimum value option.
  • Base – You need to check the Cell option.
  • Select – Here, you need to choose the First cell (It will select first matching cells) only or the All cells (It will select all matching cells) option.

Select Cells With Max & Min Value dialog box
Select Cells With Max & Min Value dialog box

  • Then, click the OK button.
  • At last, you will see that all the smallest value has been selected as shown in the below image.

Result
Result

Steps to Select the Maximum Values of First Cell or All Cells:

If you want to select the maximum values of the first cell or all cells in the range, follow the below instructions.

  • You need to select the range where you want to select the maximum values.

Select the range
Select the range

  • Go to the kutools Tab, click the Select option, then choose the Select Cells with Max & Min Value option from the listed menu.

Kutools Tab
Kutools Tab

  • Then, it will display the Select Cells With Max & Min Value dialog box.
  • Look in – Here, you need to specify the type of cells (formulas, values, or both) that you want to search.
  • Go to – In this section, you need to select the Maximum value option.
  • Base – You need to check the Cell option.
  • Select – Here, you need to choose the First cell (It will select first matching cells) only or the All cells (It will select all matching cells) option.

Select Cells With Max & Min Value dialog box
Select Cells With Max & Min Value dialog box

  • Then, click the OK button. A prompt box will pop-out to tell you how many cells will be selected.
  • You need to click OK to close this prompt box.

Prompt box
Prompt box

  • After completing the above steps, you will see that the greatest values have been selected as shown in the below screenshot.

Result
Result

Select the Max/Min Values of Each Row or Column:

You can also select the maximum or minimum values of each row or column in the worksheet. To do this, follow the below steps.

  • You need to select the range in the Excel worksheet.

Select the range
Select the range

  • On the kutools Tab, click the Select option, then choose the Select Cells with Max & Min Value option from the listed menu.

Kutools Tab
Kutools Tab

  • Next, it will display the Select Cells With Max & Min Value dialog box.
  • Look in – Here, you need to specify the type of cells (formulas, values, or both) that you want to search.
  • Go to – In this section, you need to select the Minimum value or Maximum value option (here we choose the Maximum value option).
  • Base – You need to check the Entire row or Entire column option (we choose the Entire Row option).
  • Select – Here, you need to choose the First cell (It will select first matching cells) only or the All cells (It will select all matching cells) option.

Select Cells With Max & Min Value dialog box
Select Cells With Max & Min Value dialog box

  • Then, click the OK button. A prompt box will pop-out to tell you how many cells will be selected.
  • You need to click OK to close this prompt box.

Prompt box
Prompt box

  • Finally, you can see that the maximum values in each row have been selected as shown in the below image.

Output
Output

Verdict:

From this article, you can clearly understand the steps to Select Maximum or Minimum Values in Excel Office 365 using Kutools with clear-cut examples. Don’t forget to share your feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!

Read Also:

Discussion

pic
Editor guide