Conditional Format Assistant helps you in saving time to write formulas to conditionally format your spreadsheet. The conditional tests are specified on an Excel worksheet. The Conditional Format Assistant main menu has a menu item titled Create a...

read more

The Random Number Generator for Microsoft Excel can quickly generate a set of unique random numbers in any range you select. Or use it to generate exactly the number of random numbers you need. Each number can be unique, and you can specify the...

read more

One of its most useful features is to prompt you to backup a file immediately after it is opened. Eliminate the worry about messing up a file and not having an up-to-date backup. Backup on open is a very powerful feature. It can be used to backup all of...

read more

To manually swap two rows you have to insert a row, cut or drag the row being moved to the new row, and then delete the blank row that is left. With List Assistant for Microsoft Excel you just select a cell anywhere on the row to be moved and click on the...

read more

Duplicate Finder and Deleter for Microsoft Excel can easily handle over 65,000 rows. The Duplicate Finder is completely menu driven and very fast. Once all the duplicates are found, their rows are selected. This allows you to delete the duplicates by...

read more

Cell Color Assistant adds a new menu item to the View menu that displays the Cell Color Assistant toolbar. The buttons background and text font colors represent the colors you get when you use the buttons. You can specify any color and any letter for the...

read more

If you have a price list of product numbers and prices in one worksheet and in an invoice worksheet you just have product numbers, the Lookup Assistant for Microsoft Excel will match the numbers in the invoice to those in price list. You are given the...

read more

Histogram Creator for Microsoft Excel comes with an exercise file that lets you learn quickly and easily how to use the Histogram Creator's features. The exercise file can be easily opened from the About menu or from the main Histogram Creator menu. The...

read more

To go to any column, just click on the column description. To change worksheets, just click on the spin buttons on the upper left of the above dialog. The "Titles" button allows you to change the title rows to any rows you want. Multiple rows can be used...

read more

Colored Cells Assistant will return just the cells with the color you indicate. For example, if you color some cells in a range with a yellow background you can use a Colored Cells Assistant function to return or sum just those cells. It can easily...

read more