Express Tools for Excel Add-In

The Express Tools for Excel Add-In was designed to be a set of productivity tools for Excel.

Main features:

￭ Date, Inserts today's date in the active cell. The cell is also formatted in the ISO date format: yyyy-mm-dd, a format easy to sort. We use this tool in our office every day in forms and other Excel documents.

￭ Find n color text, Find and color text helps you quickly emphasize certain data in your worksheets by coloring the whole or part of the text inside cells. Select the color for the text and the color for the background then enter the text search value.

￭ Sel. Unlocked, Selects unlocked cells to help in the creation of forms.

￭ Prefix Suffix, Prefix Suffix Conditional Change. A powerful and versatile tool to edit cell values. Examples of operation: * Add values in front of the existing content of the selected cells. * Add values at the end of the existing content of the selected cells. * Remove characters from the beginning of the existing content of the selected cells. * Remove characters from the end of the existing content of the selected cells.

￭ Edit Cell, Helps limiting the number of characters in a cell to the required amount by showing the number of characters while editing the cell.

￭Number Char., versatile tool to edit cell values that have a certain number of characters. Prompts the user to edit and moves to the next cell matching the searching criteria. The search can be done in the current column, current row, in the users selection or in the entire sheet. It has the option of coloring the matching text.

￭ Identical Cell, Identify cells with identical value in the current column. Has the option to mark the duplicate cell in green or to delete the row of the duplicate cell. There is no need to sort the values.

￭ List Sheets, List all sheets and create links to each of them. Attention, the list starts at the selected cell which will be overwritten by the created list.

￭ Delete Empty Line, Deletes lines if all of their cells are empty.

￭ Match n Copy, Copy data from one file to another only for rows in which the data in the selected look up column is identical. Powerful tool to copy values from one file to another by looking up in the specified column. Each data cell in the look up column of one file is compared with all values in the look up column of the second file. There is no need to sort the values.

￭ Auto Backup. Each time you save the current Excel file a copy of it is sent to the recycling bin. If you need to recover a previous version of an Excel file you can restore it from the recycling bin. This works even if the file is on a network drive. The copy of a file originated from a network drive will have the drive letter and folder name added to its name for easy identification.