This add-in consists of a set of productivity tools for Excel.
Menu for Excel 2010
and 2007 versions:
Menu for Excel 2003 version:
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.
The result can be a colorful and clearer
sheet; example:
-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.
-Duplicate Values,
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 Cell, Deletes rows or columns if all 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. (available in 2003 version only) 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. For example, for a file
originated from L:\Projects\Part List.xls,
the copies in the recycling bin will have
named: L;^Projects^Part List.xls.
Home
AutoCAD Tools
