The MAX function instantly identifies the highest number in a selected range of cells.
Finding the Maximum Value
- Click an empty cell and type
=MAX(. - Highlight the cells you want to check (e.g., B1:B100).
- Type a closing parenthesis
)and press Enter. - Excel will return the largest number found in that range.