mightymacros Excel Utilities

PreviousPage 1 of 4
Excel Utilities

Latest Version 4.5.1

4.5.1: The create tabs function under row tools has been modified to accommodate splitting table data where column headers are not on the top row, by simply highlighting the table column header and it's data the tool will split and group the data onto separate tabs. Highlighting the whole column will also split the data if the table headers are on the top row.

4.4.9: The multi-find has 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.

4.4.4: The multi-filter has a new paste option available to add items to the search list box from Windows clipboard. Items must be copied as a single column list. The form settings for Case, Paste, and Filter can now be stored as defaults.

4.4.1:  A new and simpler copy transpose function has been added, as well as a new macro to split table data onto separate sheets based on recurring groups within the column range, it's called 'Create Tabs' and is positioned under the 'Row Tools' menu. This version also includes improvements to the bookmark tool and some bug fixes.


Excel Utilities Product Warning


Download mightymacros Excel Utilities:


Download Excel Utilities


Download mightymacros AddIn Installer it makes installation easy when installing .xla and .xlam files



Download Utilities help file:


Download help file


Unblocking the download


Files downloaded from the internet may automatically be blocked for your safety
If this is the case then unzip the zip folder and right click the .xlam or .chm file then tick the Unblock box.

Unblock File

Installing the xlam add-in

1. Open Excel Options

Options


Form the File tab select options from the lower left hand home screen in Excel


2. Excel Options Menu

Trust Center

Select Trust Center

3. Open Trust Center

Trust Center Settings


Select Trust Center Settings

4. Allow access to VBA project object model

Macro Settings


Select any Macro Setting other than to disable all macros without notification. 

5. Select Add-ins under Excel Options

Manage Add-ins

Go to Manage and select Excel add-ins in the drop box and the click Go... button

6. Open Add-in Dialog Box

Add-in dialog


Select the Browse button

7. Paste xlam into Browse Window

Browse Paste


Make sure that Browse Path is C:\Users\[User]\AppData\Roaming\Microsoft\AddIns

Paste File and click OK button.

Note: If updating an earlier version uncheck the add-in in the add-ins dialog view then click OK to close the dialog, then follow the above steps to reopen the Add-ins dialog and go to the Browse window, paste and replace the old file, then select OK.

8. Add-in Installed

Addin Installed
Select the OK button and close the dialog