Find the Largest Number in Excel Without using any Formula!!
Tags: excelpreface, excelbasics, exceltutorials, findlargestvalue
Published: 2021-01-12 03:45:45

---
title: Find the Largest Number in Excel Without using any Formula!!
published: true
date: 2020-12-25 12:47:02 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,findlargestvalue
canonical_url: https://geekexcel.com/find-largest-number-excel-without-using-any-formula/
---

The Largest number is nothing but the highest value from a listed value. Normally, we can use the [formulas to find the largest value in Excel](https://geekexcel.com/excel-formulas-nth-largest-value/). For instance, you need to **find the largest number from a range without using any formula** means, how can you calculate them quickly? 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 largest value in Excel:

There are a number of a couple of ways to get the largest number when using Excel. For example, you can follow the steps below to get the largest number in Excel using the [command](https://geekexcel.com/use-command-ribbon-options-in-microsoft-excel-365/):

- 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 **“[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)“** from the list.

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

- After selecting the “MAX”, it will find the largest value from the given data and return it to the bottom of the selected column.

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

## A Brief Summary:

Hope you understood the simple steps to find the **largest number from a range in Excel without using any formula**. Please feel free to state your query or feedback for the above article. Thank you so much for visiting our site!!

### Read Also:

- **[Excel Formulas to Find the Largest String With Criteria!!](https://geekexcel.com/excel-formulas-find-largest-string-with-criteria/)**
- **[Excel Formulas to Find the Largest Number of Two Values!!](https://geekexcel.com/excel-formulas-to-find-the-largest-number-of-two-values/)**
- **[Apply Mathematical Operations Without Using Formula in Excel 365!!](https://geekexcel.com/apply-mathematical-operations-without-using-formula-in-excel-365/)**
- **[Excel Formulas to Calculate the Average and Ignore Errors!!](https://geekexcel.com/excel-formulas-to-calculate-the-average-and-ignore-errors/)**
- **[Excel 365 Ranges and its Types ~ Easy Tutorial for Newbies!!](https://geekexcel.com/excel-365-ranges-and-its-types-easy-tutorial-for-newbies/)**