logo ASAP Utilities
HomeExtra features for ExcelSelectAdvanced Criteria-Based Cell Selection...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

Advanced Criteria-Based Cell Selection...

ASAP Utilities  › Select  ›  1. Advanced Criteria-Based Cell Selection...

This tool lets you quickly select cells in Excel using advanced criteria that go far beyond Excel's built-in filtering options.
It offers a wide range of criteria that allow you to select cells based on their content, formatting, properties, date, or anything else you can think of.
For example, you can select cells with bold formatting or dates from a specific month or quarter, though the tool offers much more flexibility than these examples. Select cells by their content based on any of the following criteria:
  • between
  • not between
  • equal to
  • not equal to
  • greater than
  • less than
  • greater than or equal to
  • less than or equal to
  • begins with
  • does not begin with
  • ends with
  • does not end with
  • contains
  • does not contain
  • like (text, with use of wildcard characters)
  • not like (text, with use of wildcard characters)
  • duplicate values
  • unique values
  • empty cells
  • not empty cells
  • FALSE
  • TRUE
  • text length
  • values in lowercase
  • values in UPPERCASE
  • odd numbers
  • even numbers
  • number (constant)
  • number (formula)
  • number (link to sheet)
  • number (link to file)
  • formula with reference to file
  • formula with reference to sheet
  • contains any of the values specified in a range
  • contains any of the full words specified in a range
  • does not contain any of the values specified in a range
  • does not contain any of the full words specified in a range
  • equals a value  specified in a range
  • does not equal a value specified in a range
  • contains all values specified in a range
  • contains all full words specified in a range
  • matches regular expression Select cells by their formatting or other properties based on any of the following criteria:
  • cell color
  • font color
  • font name
  • font size
  • font = bold
  • font <> bold
  • font = underline
  • font <> underline
  • font = italic
  • font <> italic
  • strikethrough
  • has hyperlink
  • has comment
  • resolved comment thread
  • unresolved comment thread
  • protected cells
  • unprotected cells
  • odd rows
  • even rows
  • odd columns
  • even columns
  • visible cells
  • hidden value/formula
  • number format contains
  • merged cells
  • unmerged cells Select cells with dates based on any of the following criteria:
  • between
  • not between
  • equal to
  • not equal to
  • greater than
  • less than
  • greater than or equal to
  • less than or equal to
  • Weekday
  • Month
  • Year
  • Quarter You can run this tool sequentially to refine your selection using multiple criteria. Some people use this tool as an alternative to, or in combination with, Excel's AutoFilter when they need more advanced or flexible filtering options. By default, you can launch this tool using the Control+Alt+O shortcut. Note:
    The tool's speed may decrease if the matching cells are in many non-contiguous blocks of cells. In such an event, you can increase the speed by sorting your data first.

    Screenshots

    Example screenshot: 1 Select cells based on their value
    1 Select cells based on their value
    Example screenshot: 2 Select the cells with duplicated values
    2 Select the cells with duplicated values
    Example screenshot: 3 Select by text length
    3 Select by text length
    Example screenshot: 4 Select cells by their formatting and more such as bold cells
    4 Select cells by their formatting and more such as bold cells
    Example screenshot: 5 Select the cells with the same color as cell A2 (yellow)
    5 Select the cells with the same color as cell A2 (yellow)
    Example screenshot: 6 Select all cells that are strikethrough (perhaps marked for deletion)
    6 Select all cells that are strikethrough (perhaps marked for deletion)
    Example screenshot: 7 Select cells by date such as all dates that are on Tuesday
    7 Select cells by date such as all dates that are on Tuesday
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Select  ›  1 Advanced Criteria-Based Cell Selection...
    Additional keywords for this tool:
    advanced Excel filtering, select cells based on conditions, advanced selection criteria, custom cell selection Excel, select cells by text length, select cells by color formatting, select cells by font style, select cells by numeric criteria, select cells by conditional logic, select cells by duplicate criteria, Excel select non-duplicate cells, select cells based on properties, match, tag, pick, underlined, white, pink, red, orange, brown, yellow, gray, green, cyan, blue, violet, black, threaded, dups, duplicates
    Trustpilot
    Download  



    • 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.