. Full list of the utilities

 Some utilities may show in different order to below

Worksheet Tools

• Show Worksheet Tools

Show Worksheet Report

• Save Sheet As Workbook

• Show Selection Tools

• Highlight Blank Cells Conditionally

• Highlight Range Without Formatting

• Deselect Cells Within Range

• Show Selection Dimensions

• Compare Cells

• Compare Sheets

Row And Column Tools

• Show Row And Column Tools

• Insert Rows And Columns

• Highlight Row Differences

• Show Quick Filter

• Show Fill and Unfill Tools

Show Select Range Tools

Formula Tools

• Copy and Paste Exact Formulas

• Copy Merged Area Top Left Cell

• Hide Error Messages In Formulas

• Calculation Tools

Show Dynamic Range Tools

• Cond. Formatting Find And Replace *

Deletion Tools

• Show Deletion Tools

• Clear The Active Sheet

• Delete External Links

• Delete Duplicates In Selection

Object Tools

• Show Drawing Objects Tools

• Change To Classic AutoShape +

• Make Transparent Shape

• Show Checkbox Tools

• Show Comment Tools

Export Tools

• Copy Selection As HTML Table

• Export Picture Of Selection

• Copy Picture Of Selection

• Export Charts As Images

• Export Range As Text File

Text Tools

• Show Text And Format Tools

• Replace Text Tools

• Show Fonts Sheet

• Join Cell Text

• Insert Multi Line Cell Text

• Show Quick Write

• Web Search From Excel

• Show Special Characters

*

Number Tools

• Insert Sequential List In Selection

• Find Maximum And Minimum Values

• Convert Numbers To Text (Add ' Mark)

• Revert Text Numbers To Real Numbers

• Move Minus Sign To Front

• Positive And Negative Numbers

• Perform Quick Math On Selection

• Round Numbers In Selection

• Copy Sum Of Selection To Clipboard

• Show Conversion Tools

• Show Excel Calculator

Time And Date Tools

• Show Excel Timer

• Show Time Picker

• Insert Calendar Sheet

• Select Days And Months

• Show Calendar Date Picker

Chart Tools

• Add Data Labels From Range

• Change Series Colors From Range

• Move Data Label To Left

• Position Chart Axes

• Add Custom Gridline To Chart

• Add Gantt Chart

• Insert Bar Graph In Selection

Path And Folder Tools

• Change Excel Application Settings

• Show Full Path And Book Name in Titlebar

• Copy Pathname To Clipboard

• Open Dialog Box With Current File's Folder

• Open Explorer With Current File's Folder

• Show Folder Details in Worksheet

Workbook Tools

• Add Workbook to Recent Files

• Clear Recent Files List

• Rename Active Workbook While Open

• Delete Active Workbook While Open

• Save Workbook With Backup File

• Reopen Workbook Without Saving

• Close Saved Workbooks

• Insert Headers And Footers

Developer Tools

• Show Active Workbook Details

• Copy VBE Modules

• Delete Active Workbook Macros

• Show Excel Color Details

• Show Color Picker

• Show Excel Menu Details

• Show Face IDs Toolbar

• Show Ribbon Images +

• Show Old Style Menu +

• Delete Custom Toolbars

• Delete Custom Controls

Show Reset Tools

Games

• Play Mastermind

Play Concentration

• Play Simon Says

Generate Password

JMT Tools

• Add JMT Functions To Workbook

• JMT Excel Utilities Settings

• Show JMT Help Files

* Not available with Excel 2007

+ Not available with Excel 97-2003

Back to download page