Spreadsheet Assistant's Conditional Select Assistants Menu

Time-saving conditional select features added to Microsoft Excel.

Download a trial version now!

The following are just a few of the time-saving conditional select features added by the Spreadsheet Assistant that make Microsoft Excel easier to use:

  • 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

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.

Conditional Select Assistants menu
The Conditional Select Assistants menu

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

Return to the Spreadsheet Assistant overview to explore all the other assistant menus.

Customers who viewed the Spreadsheet Assistant also viewed