logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Select Cells Containing the Highest Value

ASAP Utilities  › Select  ›  13. 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.

    Screenshots

    Select  ›  13 Select Cells Containing the Highest Value

    Starting this tool


    Select  ›  13 Select Cells Containing the Highest Value
    Additional keywords for this tool:
    Find highest value in Excel, Select largest number, Highlight maximum value, Find and select highest value, Identify largest number in a range, Select all cells with the highest value, Find and highlight the largest value, How to locate the largest value in a range



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


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