mightymacros Excel Utilities

 

menu

Download mightymacros Excel Utilities

Latest Version 4.4.9

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.

Download Excel Utilities

Download Updated Utilities help file

(You may need to unblock the file: right click the file>Properties>unblock) 

Download help file

Workbook Tools

Open files: is an organizer used for storing shortcuts to commonly used files and folders.

Save Copy: simply saves a copy of the open file, without switching the file.

This differs from the 'save as' function which closes the open workbook and saves the workbook as a new file.

Delete Names: Use with caution as this function will clear all names and named ranges in the active workbook.

Column Tools

Hide: checks for a background cell colour on row one column headings to determine the columns to hide. Columns without a background colour will be hidden. 

Unhide: makes visible any hidden columns on the open worksheet

 Select: will select cells top-down to cover the data range within one or more adjacent columns. The selection will ignore blank cells and cover the complete data range. whereas the ctl+shift+down-arrow selection key method will only extend the selection as far as the first blank cell. 

Sheet Tools

Protect: provides the option to protect and unprotect an open workbook and its sheets by using a stored password. The tool also hides or unhides multiple sheets with a single click. Sheets can either be set to hidden or very hidden. A very hidden sheet is not displayed as a hidden sheet using Excels Unhide function on the sheet tab menu. This tool will list any very hidden sheets within a workbook. If the workbook is unprotected, then the sheets can be displayed using this tool.

Row Tools

Remove Blanks: removes blank or empty rows on the selected worksheet.

Insert on Change: separates sheet data when values change within a selected column. For example, applying 'Insert on Change' on a sorted vendor or buyer column will insert a blank row between different buyers or vendors. The blank row height and colour can be preset. Decreasing the row height and colouring the row, makes it appear as a line separating the report data. Run remove blanks to redo row height or colour.

Free Joomla! templates by Engine Templates