Free Utility Package for Excel
Surf the Web and you’ll find dozens of Excel utility collections available for download. Here’s one we particularly like, and it’s free. Andrew’s Utilities 2 can do everything from copying the comments for a cell into the cell itself to converting numbers to text. You can download it from
http://www.andrewsexceltips.com/my_utilities.htm
The download includes three files: one adds a new option to your main menu (you select all the features from this entry), another adds a new toolbar (with major categories offered as buttons on the toolbar), while the third lets you invoke the utilities with a click of your right-mouse button.
The utilities are well organized in categories. There are over 24 options for tweaking or working with comments: you can copy the cell’s formula to a comment (for a cell selection or all cells on a worksheet); align the comment text left, center, or right; or autofit the dimensions of the comment box to the text it contains (a feature I find particularly handy).
In the “Rows and Columns” category, there are utilities that can duplicate, conditionally remove, autofit, change the size of, or color rows or columns. It can also eliminate blank rows and columns.
Looking to work on multiple cells? The utility collection lets you select cells by background color, value (number or text), or those within the range you specify. You can select unique values or duplicates, too. Also in this category are tools for working within a range (select or simply move to the first/last row/column of a range, for example),
Text utilities can change the case of text, insert or delete characters, and fill blank cells with the value you specify. Other utilities insert row or column numbers, change a date’s format, add a day, month, or year to a value, convert measures (meters to miles, grams and ounces), show or hide Excel interface elements (such as scroll bars), and e-mail the active workbook or worksheet.
0 Responses to “Free Utility Package for Excel”