How to Find the Largest Number in Excel

In the next couple of minutes, we’ll go through a quick guide on how to find the largest number in Excel. Thanks to these simple steps, you’ll be able to find out maximum sales for a certain period of time promptly.

Let’s start!

See the video tutorial and transcription below:

See this video on YouTube:
https://www.youtube.com/watch?v=G0rvrvK29nM

Contents hide

1 Simplest Way How to Find the Largest Number in Excel

2 How to Find the Largest Number in All Quarters

The largest number of a group in Excel can be identified in more than one way. Today, we’ll cover just one, the simplest way, step by step, using this specific data set as an example.

Simplest Way How to Find the Largest Number in Excel

Set the pointer on the cell in which you want the largest number to appear. In this case, we’ll click on C13, where we want to display the maximum sales for Q1.

How to Find the Largest Number in Excel - find biggest number

Go to ‘Home’ tab and look for the button ‘AutoSum’ in the group ‘Editing’. After clicking on the button, a drop-down menu will appear.

How to Find the Largest Number in Excel - autosum option in Excel

Since we’re looking for maximum sales, find and select the function ‘Max’.

How to Find the Largest Number in Excel - find max number in Excel

Excel will then prompt us to define the area in which we want to look for the maximum value, which is Q1.

How to Find the Largest Number in Excel - define are in which we want to find largest number

You can drag your mouse to select the cell range C3 to C10.

How to Find the Largest Number in Excel - define area with the largest number

Now click on OK. Perfect!

How to Find the Largest Number in Excel - look for the largest number in Excel

If you need to look for the largest number in any of the data tables you created, you can follow these steps.

And there’s more to that.

How to Find the Largest Number in All Quarters

To find out maximum sales in all quarters, just click on the cell containing the function and through its right bottom corner drag the formula through the rest of the cells.

How to Find the Largest Number in Excel - copy autosum formula in Excel

Like this! Easy, right?

How to Find the Largest Number in Excel - find the largest number in whole Excel table

Are you interested in:

If you found this tutorial helpful, give us a ‘like’ and watch other video tutorials by EasyClick Academy. Learn how to use Excel in a quick and easy way!

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button on our YouTube channel and join the EasyClickers!

See you in the next tutorial!