mightymacros Excel Utilities v4.3.1
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...
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
Updated links to new site: https://mightymacros.net/
Updated macros for finding duplicates and repeating values
Revisions apply to date tools, the multi-header lookup and insert text.
New macros have been added to cut, copy and paste row sections. These macros can save time in making a selection to the end of a row to copy and paste. Cell Tracker has also been updated to work on filtered lists.
Added a new column-range selection macro that highlights all the data in a column including the gaps. It will work for one or more adjacent columns by simply selecting the top cells. Also added a copy function to Cell Tracker.
Updated menu and help file.
Moved away form using commandbar indexes for menu placement due to variability within
the same version of Excel which did not always display the menu on the cell short-cut menu.
The utilities menu should now appear on all cell, row and column menus and over lists, queries
and tables when activated.
Updated date tools to include a new function that converts dates into Quarters
Improved access options to the utilities menu, which now provides additional access via the Row and Column shortcut menus.
New tool added for copying and pasting into filtered lists
New tool added for transposing rows on double click
Tags: Excel Add-in Excel Utilities
Released:August 11, 2018
Platforms:Windows 2000, Windows XP, Windows Vista, Win7 x32,Win7 x64,Windows 8,Windows 10,WinServer,WinOther
Requrements:2007-2016 MS Excel
Install:Install and Uninstall
5dchart Add-in for Excel is a handy and reliable add-in designed to generate bubble charts for large and complex data sets.
The appearance of the charts can be customized directly from the current worksheet. In addition, the generated images
Essential Excel Add-In is a useful tool for the users who want to insert additional functions to their Excel spreadsheets. The included macros enable you to remove duplicate entries from your tables and change the color of your data ranges.
LANGuardian Excel add-in is a practical tool that allows other users than the network administrator to generate reports. The add-in is completely integrated in the Excel interface and requires very little time to generate report.
It is designed
Change Case Excel Add-In is designed to ease your work in Excel, by allowing you to change the case using only the context menu.
The addin can assign shortcut keys for case changes, enabling you to rapidly change the case in the selected cells
Devart Excel Add-ins allow you to use powerful Excel capabilities for processing and analysis of data from cloud applications and relational databases, edit external data as usual excel spreadsheets and save data changes back to the data source you have
Devart Excel Add-in for Oracle allows you to use powerful Excel capabilities for processing and analysis of data from Oracle database, edit external data as usual excel spreadsheets and save data changes back to Oracle database
Devart Excel Add-in for for FreshBooks allows you to use powerful Excel capabilities for processing and analysis of data from FreshBooks, edit external data as usual excel spreadsheets and save data changes back to Zoho CRM
PlusX Excel Add-In is a 100% free and 100% safe addition to Excel, shown as a new tab on the standart menu. The application has several groups of functionality: Charts , Shortcuts , Rates and Browser.
It enables the user to create 5 addititonal Charts
Devart Excel Add-in for G Suite allows you to use powerful Excel capabilities for processing and analysis of data from G Suite, edit external data as usual excel spreadsheets and save data changes back to G Suite
* Powerful Data Import
Devart Excel Add-in for NetSuite allows you to use powerful Excel capabilities for processing and analysis of data from NetSuite, edit external data as usual excel spreadsheets and save data changes back to NetSuite
* Powerful Data Import
Most popular Spreadsheets
Excel Macro Processor (EMP) is an advanced tool for Microsoft Excel Automation based on MS Excel macros and Excel VBA modules (VBE code). With Excel Macro Processor you can apply your macro to a lot of Excel documents at a time. EMP requires MS Excel
Batch Replacer for MS Excel is a utility which helps you perform multi-replacement operations in MS Excel files with the help of an MS Excel list. It can really save a great deal of time: no need to open each file and make a replacement and then open
Oxygen Phone Manager is the most complete software tool for managing the content and settings of a Nokia cellphone from a personal computer. It is compatible with nearly all currently available models of Nokia and can communicate with the phone through
Oxygen Phone Manager II for Symbian OS smartphones lets your PC and mobile phone with Symbian OS communicate with each other. The program allows you to work with Phonebook, Calendar, To-Do List, Profiles, Log records, Applications, Images, Melodies and
With Ablebits.com Merge Tables Wizard you can lookup and combine matching data from 2 Excel worksheets in seconds The add-in is an easy-to-understand alternative to Microsoft Excel Lookup and Vlookup functions. It perfectly merges matching data from two
Use Merge Cells Wizard every time you need to place values from several Excel cells to one cell, to merge row by row, column by column. If the selection contains multiple data values, Merge Cells Wizard will help you avoid loosing data in Microsoft Excel
DoneEx XCell Compiler offers very easy and hassle free Microsoft Excel workbook copy protection.
You can compile Excel spreadsheet into EXE application with securely hidden formulas in binary format and protected VBA code. With registration/license management
Recovery for Calc is data recovery program for OpenOffice Calc spreadsheets (.ods). Recovery for Calc retrieves cells data and all standard cell's properties from corrupted OpenOffice spreadsheets. Recoveres files created by OpenOffice Calc version 2
Using Chart Tools you will become convinced that it has never been so easy to handle Excel line charts. With this Excel add-in you will be able to: Copy and paste format from a chart to another one, Resize and save charts, Add images, Add and move labels
Merge Excel Workbooks software can merge several more excel files into one new workbook(multiple worksheets), Are you still bothered by the cumbersome job of merging multiple excel workbooks into one workbook?
You may have to merge multiple excel sheets
mightymacros Excel Utilities Author's Software
mightymacros Dat add-in is designed to assist accounts payable and P2P staff, in the identification and prevention of unwanted duplicate payments. The tool installed within MS Excel, offers a non-intrusive option for scanning invoice information for duplicate
Fast Open for Office is a Microsoft Office add-in that saves time and frustration when looking for and opening Office documents on a network or on a computer with documents saved in many locations.
Fast Open for Office offers a simple way to arrange
mightymacros new Excel Multifind is simple, and easy to use. It adds to the functionality of Excel's tool set and installs onto Excel's ribbon data tab.The Excel Multifind is an extremely useful time saving tool, and a critical one, when it comes to finding
List copy paste is a simple windows form application that is an extremely useful for copying chunks of data from Excel such as a list of part numbers and making them available for pasting by item into an external application. List Copy Paste acts as a
mixlUtilities is a tool kit for the Excel user. The add-in simplifies many repetitive tasks by providing a useful set of tools with ease of access from the cell short cut menu. It also comes with access to on-line help and support. The add-in tool kit
mixlNavigator is a sheet navigation and guide tool for large spreadsheets where the column headers extend beyond the width of the screen. The add-in assists in maintaining row position whilst enabling rapid navigation across your worksheet to the select
Multi-Find is a handy Excel addin that can search for multiple words within a worksheet and highlight the corresponding cell.
Multi-Find is designed to be a faster and more efficient alternative to the vlookup function, enabling you to search
The shortcuts add-in helps you to organize your short-cuts by putting them all in one place, and making them accessible from within your Excel worksheet by simply right clicking to open the add-in from the cell short-cut menu. No longer will you have
Short-cuts is an easy to use addin for Excel that provides you with faster access to frequently used Excel documents.
Simply right-click in any workbook to browse through the file shortcuts and open new Excel files. You can create multiple
Unlike the vlookup function, Multi-Lookup will enable you to find more then one result when looking up an item in an Excel spreadsheet.
vlookup only returns the first value associated with the lookup word, while Multi-Lookup outputs all the