How to Do the Max Function in Excel 2010

Excel 2010 is a very powerful spreadsheet program, and it includes so many features that there are some that even advanced users might not use or be aware of. One helpful tool in the Excel arsenal is the “Max” function.

You can use this function to quickly find the highest value in a group of selected cells. This is helpful when you need to scour through a huge set of data for the highest value and don’t want to waste time doing it manually.

You can elect to use this function either by typing the formula into a cell yourself, or by highlighting your desired cells and clicking a button in the Excel navigational ribbon.

As an Amazon affiliate, I earn from qualifying purchases.

How to Use a Max Function in Excel

The first method we are going to instruct you to use is the automated one where you do not need to type the formula yourself. This is the easier of the two options, as it does not offer the possibility of accidentally making a typing mistake and breaking the formula.

Step 1: Open the spreadsheet containing the data for which you want to find the highest value.

Step 2: Highlight the range of cells for which you wish to find the highest value. For the sake of this example, I am just going to select a small group of cells.

select your desired cells

Step 3: Click the Home tab at the top of the window.

click the home tab

Step 4: Click the AutoSum drop-down menu in the Editing section at the right side of the ribbon, then click the Max option.

how to do the max function in excel 2010

This will display the highest value in your selected cells in the first open cell under your selected data.

Typing the Max Formula Yourself

This option offers some additional customization options that allow you to do some more with the formula, including allowing you to display the Max value in a cell of your choosing.

Step 1: Click inside the cell in which you want to display the Max value.

Step 2: Type =MAX(XX:YY) , but replace the XX with the first cell in the range you are working with and replace the YY with the last cell in the range.

manually enter the excel max formula

Step 3: press Enter on your keyboard to execute the function.

If you want to find the Max value for a range of cells that is spread across multiple columns, you can change the formula so that it looks like this:


Now that you know how to use the MAX function in Excel 2013, you can use this formula to quickly evaluate large sets of data.

To learn about other useful formulas that you can simply click to apply to a group of highlighted cells, read this article about finding the average of a group of selected cells.

If you’re thinking about purchasing a new laptop and you don’t want to spend a lot of money, you should check out the Acer Aspire AS5250-0639. It has some good features and can be had for a very low price. You can learn more about this computer by reading our review.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy