logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Select » 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

    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
  • 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 Ctrl+Alt+O.

    Remark:
    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:
    http://support.microsoft.com/default.aspx?scid=kb;en-us;832293

    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 utility

    In the Excel menu choose: ASAP Utilities » Select » Select cells based on content, formatting and more...

    « Return to the list of “Select” tools.
    « Previous
    Edit your favorite tools and shortcut keys...
     
     Next »
    Conditional row and column select, hide or delete...
    Excel 2010 with ASAP Utilities in the menu
    Download ASAP Utilities
    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

    Follow ASAP Utilities on Facebook



  • Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
    © 1999-2017 - - - - The Netherlands

    Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
    Follow us on TwitterFollow us on Facebook