logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Select cells based on content, formatting and more...

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Select  ›  1. Select cells based on content, formatting and more...

With this tool you can select cells based on their value, formatting style and other properties.
You can for example select all cells between 50 and 250 or all bold cells or all red cells.

You can use the following criteria to select cells based on their contents:
  • 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

    You can use the following criteria to select cells based on formatting and more:
  • 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

    You can use the following criteria to select cells based on their date:
  • 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

    Some people use this utility as an alternative for or addition to Excel's AutoFilter.

    By default this utility can be used with the shortcut Control+Alt+O.

    Note:
    The speed of the utility decreases if the matching cells are in many non-contiguous blocks of cells. The speed can be increased by first sorting your data.
    You cannot use this utility to select cells on a condition that is set via conditional formatting.
    Due to a limit in Excel, this utility can select a maximum of 8192 non-contiguous blocks of cells. More information about this is on the Microsoft website:
    https://support.microsoft.com/kb/832293/en-us

    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 Select cells based on content, formatting and more...
    Additional keywords for this tool:
    Duplicates, Double, Colour, Based on criteria, highlight, duplicate data, duplicate fields, duplicate cells, find all duplicates, filter, select rows or columns in intervals, colours, find and select cells that meet specific conditions, wildcard, match, tough filter, find cells with a certain amount of characters, finding, duplication, Conditional select cells, the same value, colored, highlight, line, advanced, amount, quantity, see, tag, select within, choose, pick, underlined, blanks, deselecting, unselect, separators, only, white, pink, red, orange, brown, yellow, gray, green, cyan, blue, violet, black, threaded comment, threaded comments


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


    Empowering Excel Users Worldwide for 25 Years