4. Select the range of cells to calculate.  5. Click  Enter  on your keyboard. 1. Select the cell directly beneath the range of data. 2. Select the  Auto Sum  dropdown.  3. Select  Max  or  Min  to calculate the maximum or minimum values  6. Select the range of cells to calculate.  7. Click  Enter  on your keyboard to calculate the value. 44  To calculate the Maximum or Minimum for a range of data:  Maximum and Minimum 