Tip of the Day | Tuesday January 6th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Select Cells Containing the Highest Value

Quickly find and select all cells that contain the highest value in your selection or across the entire worksheet.

If multiple cells are selected, the tool finds and selects the cells with the highest value within your selection.

If only one cell is selected, it scans the entire worksheet and selects all cells of the highest value.

This tool uses Excel's =MAX() function to identify the largest number and select every matching cell.

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.