mightymacros Excel Utilities

This is a collection of macros for the Excel.

This library of macros will help reduce the amount of time wasted on repetitive Excel tasks. The macros available will help doing repetitive tasks automatically thereby reducing time taken and improving productivity. These custom built programs for the Excel will help improve the processes carried out in Excel in the organization. You can download the collections for a free trial. The dialog boxes opened by these macros are quite intuitive. You would be able to choose the options easily. Choosing the options usually means just clicking radio buttons. The operation, in general, is simple and should not pose any challenges for any users. On-line help provided makes things easier too. This collection of macros has functions like, a shortcut organizer to store your file and folder paths, you can protect multi-sheet workbooks, a finder tool that can search for multiple items at a time, and a navigation tool for large worksheets.

​

The collection includes multi-look up tool that can find you more than the first match found. A multi-header look-up tool performs look-ups in a worksheet. A multi-filter tool is provided. This will let you save the search criteria and retrieve them later. Multiple look-ups can be carried out by a multi-header look-up tool. Duplicates as well as all repeating values can be displayed by one of the tool. Changing case and editing of cells such as insert, move, delete, characters and text within cells can be carried out easily with one of the tools. A number rounding off tool is provided in addition. A bookmark tool, cleaning and trimming text tool, delete empty rows and inserting rows, etc. are additional functions offered with the package. This is a good tool.

mightymacros simplifies many repetitive tasks in Excel with a useful set of tools with fast access from the cell short-cut menu.
The utilities come with on-line help and include:
1. A shortcut organizer to store your file and folder paths.
2. A workbook multi-sheet protection tool.
3. A Multi-find tool for finding multiple items with a single click.
4. A navigation tool for large worksheets.
5. A multi-lookup tool that can return more than the first match.
6. A multi-header lookup tool that performs multiple lookups across a worksheet.
7. A multi-find and replace tool
8. A multi-filter tool that you can save and retrieve your filter criteria
9. A store text and insert text tool to save repetitive typing.
10. A bookmarks tool where you can sort and arrange sheets,
11, A Clean and trim text tool
12. Delete empty rows
13. Insert rows on changing values.
14. Show duplicates as well as all repeating values.
15. Change case
16. Edit Cells, insert, move, delete, characters and text within cells
17. A rounding number tool
18. A variety of date tools and more...