mightymacros simplifies many repetitive tasks in Excel with a useful set of tools. 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...
