Tip of the Day | Monday 31 August 2026

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.

Starting this tool