Express Tools for Excel Add-In
|Op. System:||Windows 2003/XP/2000|
|File size:||339 KB|
Publisher description for Express Tools for Excel Add-In
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: 1-Add values in front of the existing content of the selected cells. 2-Add values at the end of the existing content of the selected cells. 3-Remove characters from the beginning of the existing content of the selected cells. 4-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. dentical 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.