Mightymacros offers a valuable set of tools that streamline routine tasks in Excel, making them less repetitive and more efficient.
- Shortcut Organizer, which allows you to store file and folder paths for quick access.
- Workbook multi-sheet protection tool, keeps your work safe and secure.
- Multi-find tool, to find multiple items with a single click.
- Navigation tool, for navigating large worksheets with ease.
- Multi-lookup tool, that can return more than the first match.
- Multi-header lookup tool, performing multiple look-ups across a worksheet.
- Multi-find and replace tool.
- Multi-filtering tool, which helps you save and retrieve your filter criteria.
- Store text and insert text tools, to save repetitive typing.
- Bookmarks tool, which lets you sort and arrange sheets.
- Clean and trim text tool.
- Delete empty rows.
- Insert rows on changing values.
- Show duplicates and all repeating values.
- Change case.
- Edit cells, insert, move, delete, characters, and text within cells.
- Rounding number tool.
- A variety of date tools and many more.
Overall, mightymacros is a great addition to any Excel user's toolset that can save time and effort with everyday tasks. The tools are easy to use, and the on-line help feature provides quick assistance when needed.
Version 4.7.6: The latest version includes a new dynamic pointing tool for highlighting cell locations. The tool´s purpose is to draw focus on specific row and column data when presenting information.
Version 4.6.9: New tools have been added to the toolset: A count filter tool, a click filter tool and a create workbooks tool.
Version 4.6.2: This update includes a new tool called Delete Rows and is located under the row tools menu. This tool eliminates the need of applying and selecting filters and cells to remove unwanted rows.
Version 4.5.7: A simple row color sort has been added to the tool set collection under the row tools menu. The tool will sort row colors on a sheet having up to 7 colors. The sort configuration can be stored and used across multiple worksheets.
Version 4.5.2: Fixed bugs with Multi-Find and Multi-Filter paste option. Added an additional button to the Multi-Find providing the choice to either search by a selected range or to search by a select column and eliminated the bug when only one item is added to search list.
Version 4.5.1: A new Create Tabs function under row tools, splits and groups data onto separate tabs based on recurring data within a selected column.
Version 4.4.9: The multi-find and multi-filter have a new paste from the clipboard button and the auto-backup reminder method has been revised on multiple forms and hopefully now is more user-friendly. Also included in the update are bug fixes to the multi-find and replace form.
Version 4.3.1: Text tools, date tools, round numbers, multi-find and multi-filter, along with duplicate/repeat finders have all been updated with a new range class to simplify use. Hyperlink remover has been updated and now maintains the background colour on removal. Also included are a few minor bug fixes
Version 4.2.4: Updated text and date tools as well as the duplicate and repeat finder with a new range selection class. Updated macros for the auto-filter to select the top row of the used range. Also updated the remove hyperlinks function to maintain the background cell colours when hyperlinks are removed.
Version 4.13: Updated links to new site: https://mightymacros.net/