Conditional Select Assistants Menu

Part of the Spreadsheet Assistant for Microsoft Excel — select cells based on what they contain.

Download a trial version now!

  • Select only the visible cells after you have filtered your data
  • Select just the number (input) cells in a range
  • Select just the formula cells in a range
  • Select cells using an IF test — value based or text based
  • Add any feature to Excel's quick access toolbar for instant use
Conditional Select Assistants menu
The Conditional Select Assistants menu

The following is the Select Assistants menu that appears when you click on the Select Assistants button. Any of the features can be added to Excel's quick access toolbar for instant use any time.

The first feature on the Select Assistant menu is very useful if you have filtered your data and need to select only the visible cells. Manually such a task is painful. With the Spreadsheet Assistant, it is but a click.

If you are reviewing your worksheets and want to see which cells are input or number cells and which are formula cells, then all you need to do is select a range and use the Select Number Cells or Select Formula Cells features.

The Select Cells using an IF test is one of our most powerful features. With it you can do value based IF tests or text based IF tests.

Customers who viewed the Spreadsheet Assistant also viewed