You can do this too
Download now, it's easy
ASAP Utilities menu
Language:
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 wildcards)
- not like (text, with use of wildcards)
- duplicate values
- unique values
- empty cells
- not empty cells
- FALSE
- TRUE
- text length
- 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
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.
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
Video example
Screenshots
Example screenshot: 1 Select cells based on their value
Example screenshot: 2 Select the cells with duplicated values
Example screenshot: 4 Select bold cells
Example screenshot: 5 Select cells with the same color as cell B2
Example screenshot: 6 Select all cells that are strikethrough (perhaps marked for deletion)
.png "6 Select all cells that are strikethrough (perhaps marked for deletion)")
Starting this utility
In the Excel menu choose ASAP Utilities » Select » Select cells based on content, formatting and more...Additional keywords:
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
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
« Return to the list of “Select” utilities.
© 1999-2010 - Bastien Mensink - ASAP Utilities - Excel tools - A Must in Every Office BV - The Netherlands 