How to Select Maximum or Minimum Values Cells in Excel Office 365?
Tags: kutoolsexceltutorial, selectmaxorminvaluec, kutools
Published: 2020-11-23 10:46:53

---
title: How to Select Maximum or Minimum Values Cells in Excel Office 365?
published: true
date: 2020-11-23 09:10:28 UTC
tags: KutoolsExcelTutorial,SelectMaxorMinValuec,Kutools
canonical_url: https://geekexcel.com/how-to-select-maximum-or-minimum-values-cells-in-excel-office-365/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-40.png)<figcaption id="caption-attachment-17913">Select the range</figcaption>

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

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-10.png)<figcaption id="caption-attachment-17914">Kutools Tab</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-39.png)<figcaption id="caption-attachment-17915">Select Cells With Max &amp; Min Value dialog box</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-38.png)<figcaption id="caption-attachment-17916">Result</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-34.png)<figcaption id="caption-attachment-17917">Select the range</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-10.png)<figcaption id="caption-attachment-17914">Kutools Tab</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/5-29.png)<figcaption id="caption-attachment-17918">Select Cells With Max &amp; Min Value dialog box</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-27.png)<figcaption id="caption-attachment-17919">Prompt box</figcaption>

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

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-25.png)<figcaption id="caption-attachment-17920">Result</figcaption>

## 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-34.png)<figcaption id="caption-attachment-17917">Select the range</figcaption>

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

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-10.png)<figcaption id="caption-attachment-17914">Kutools Tab</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-24.png)<figcaption id="caption-attachment-17921">Select Cells With Max &amp; Min Value dialog box</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-21.png)<figcaption id="caption-attachment-17922">Prompt box</figcaption>

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

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-18.png)<figcaption id="caption-attachment-17923">Output</figcaption>

## 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.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [How to Extend Selection to Start of Row Using Shortcut in Excel 365?](https://geekexcel.com/quick-shortcut-to-extend-selection-to-start-of-row-in-ms-excel-365/)
- [Filter Cells by Background Color in Excel 365](https://geekexcel.com/how-to-filter-cells-by-background-color-in-excel-365/)