How to Find the Smallest Number Without Formula in Excel?
Tags: excelpreface, excelbasics, exceltutorials, smallestvaluewithout
Published: 2021-01-06 14:50:49

---
title: How to Find the Smallest Number Without Formula in Excel?
published: true
date: 2020-12-25 12:42:15 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,smallestvaluewithout
canonical_url: https://geekexcel.com/how-find-smallest-number-without-formula-excel/
---

Earlier we have learned the simple steps to find the [largest value without using any formula](https://geekexcel.com/excel-formulas-to-get-the-largest-value-with-criteria/) in Excel. Here we will see how to **find the smallest value without using any formula**. Let’s see them below!! 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)
## Steps to find the smallest value in Excel:

There are several ways to calculate the smallest number in a range. You can [get the smallest number with a formula](https://geekexcel.com/excel-formulas-find-minimum-value/), or you can find the smallest number with the command below:

- First, you need to enter the values in a range and select the range.

![Select range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-range.png)<figcaption id="caption-attachment-20291">Select range</figcaption>

- Then, click the **“[Home](https://geekexcel.com/use-shortcut-to-open-home-tab-in-excel-office-365/)“** tab from the [ribbon](https://geekexcel.com/use-and-customize-ribbon-commands-in-excel-office-365-quick-ways/).

![Home tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-home.png)<figcaption id="caption-attachment-20292">Home tab</figcaption>

- Under the Home tab, you can see the **“Editing”** section.
- Here, you need to click the **“[Auto Sum](https://geekexcel.com/shortcut-to-auto-sum-selected-cells-in-microsoft-excel-365/)“**.

![Editing section](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Editor-tab.png)<figcaption id="caption-attachment-20293">Editing section</figcaption>

- It will expand the drop-down list.
- You need to select the **“[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)“** from the list.

![Select Min](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-Min.png)<figcaption id="caption-attachment-20398">Select Min</figcaption>

- After selecting the “MIN”, it will find the [smallest value](https://geekexcel.com/excel-formulas-find-nth-smallest-value-with-criteria/) from the given data and return it to the [bottom](https://geekexcel.com/remove-all-blank-rows-from-bottom-a-range-in-excel-office-365/) of the selected [column](https://geekexcel.com/definitions-cell-range-row-column/).

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

## Closure:

In this way, we have learned the simple steps to get the **smallest number from a range without using any formula in Excel**. Mention your **queries** in the **comment** box below. Thank you so much for visiting our site!!

### Read Also:

- **[Excel Formulas to Find the Nth Smallest Value from a Range!!](https://geekexcel.com/excel-formulas-find-nth-smallest-value/)**
- **[Excel Formulas to Find the Minimum Value With Multiple Criteria!!](https://geekexcel.com/excel-formulas-minimum-value-with-multiple-criteria/)**
- **[How to Round Cell Values without Formulas in Excel Office 365?](https://geekexcel.com/how-to-round-cell-values-without-formulas-in-excel-office-365/)**
- **[Find the Average of Numbers Without Using Formula in Excel!!](https://geekexcel.com/find-average-excel-without-using-formula/)**