Note: Excel 2007 and above, Excel 32 bit only (Windows 64 bit is okay)

For more details and screenshots, download a copy of the AET Excel Utilities Help Files

Worksheet Tools

• Show Worksheet Tools
• Show Worksheet Report
• Save Sheet As Workbook
• Show Selection Tools
• Show Cells With Same Value
• Highlight Blank Cells Conditionally
• Highlight Range Without Formatting
• Copy Merged Area Top Left Cell
• Deselect Cells Within Range
• Show Selection Dimensions
• Compare Cells
• Compare Sheets

Row And Column Tools

• Show Row And Column Tools
• Show Cells To Grid Tools
• Insert Rows And Columns
• Group Rows And Columns
• Ungroup Rows And Columns
• Highlight Row Differences
• Join Columns
• Show Quick Filter
• Show Fill and Unfill Tools
• Show Select Range Tools

Formula Tools

• Copy and Paste Exact Formulas
• Hide Error Messages In Formulas
• Calculation Tools
• Show Dynamic Range Tools
• Find Precedents and Dependents
• Find Circular References

Deletion Tools

• Show Deletion Tools
• Clear The Active Sheet
• Delete External Links
• Delete Duplicates In Selection

Object Tools

• Show Objects Tools
• Change To Classic AutoShape
• Make Transparent Shape
• 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

• Text And Format Tools
• Replace Text Tools
• Show Fonts Sheet
• Insert List In Selection
• Join Cell Text
• Parse Cell Text
• Insert Multi Line Cell Text
• Show Quick Write
• Web Search From Excel

Number Tools

• 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
• Reposition Data Labels
• Move Data Labels To Left
• Position Chart Axes
• Add Custom Gridlines To Chart
• Resize Chart
• Add Gantt Chart
• Insert Bar Graph In Selection

Path And Folder Tools

• 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
• 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

• Change Excel Application Settings
• Show Active Workbook Details
• Copy VBE Modules
• Delete Active Workbook Macros
• Copy Active Cell Formula To VBA String
• Show Excel Color Details
• Show Excel 2007 - 2013 Color Details
• Show Color Picker
• Show Excel Menu Details
• Show Old Style Menu
• Show Ribbon Images
• Show Face IDs
• Delete Custom Toolbars
• Delete Custom Controls
• Reset Built-In Toolbars
• Reset Tools

Games

• Set Game Transparency
• Play Mastermind
• Play Concentration
• Play Simon Says
• Play Zapper
• Play Number Shuffle
• Play Odds and Evens
• Make A Decision
• Generate Password

AET Tools

• Add AET Functions To Workbook
- HASFORMULA
- GETFORMULA
- GETFORMULAR1C1
- GETFORMAT
- GETFONT
- GETCOMMENT
- SHEETSNAME
- BOOKSNAME
- FULLNAME
- USERSNAME
- PATHNAME
- ROWSIZE
- COLUMNSIZE
- FIRSTINROW
- FIRSTINCOLUMN
- LASTINROW
- LASTINCOLUMN
- MILLIONS
- THOUSANDS
- GETNUMBERS
- GETTEXT
- HASTEXT
- REVERSETEXT
- MAKE PASSWORD
- GETCOLORINDEX
- GETTHEMECOLOR
- GETTINTANDSHADE
- GETFONTINDEX
- COLORNAME
- GETHTMLCOLOR
- GETRGBCOLOR
- COUNTCOLOR
- SUMCOLOR
- DATEFORMAT
- DATEFORMAT2
- EDATEPLUS
- EOMONTHPLUS
- LASTDATE
- STATRAND
- STATRANDBETWEEN
- CHAIN
- MALENAMES
- FEMALENAMES
- COMPANYNAMES
- CHOOSEFROMRANGE
- CHOOSEFROMLIST
- CONVERTROMANNUMBERS


• AET Excel Utilities Settings
• Show AET Help Files

AET Right Click Menus

Cell Menu
• Camera Tool added
• Filter Selected Cells added
• Find and Replace tool added
• Select Special Cells added
• Rows and Columns
- Autofit Rows
- Autofit Columns
- Autofit Rows and Columns
- Row Height
- Column Width
- Hide Rows
- Unhide Rows
- Hide Columns
- Unhide Columns
- Hide Rows And Columns
- Unide Rows And Columns


• Quick Number Formats
- General Format
- Numerical Format (0)
- Decimal Format (0.00)
- Dollars Format
- Euros Format - Pounds Format
- Yen Format
- dd/mm/yyyyy
- mm/dd/yyyyy
- yyyy-mm-dd (ISO)
- Manage Custom Formats (add up to 5 possible custom formats)


Row Menu
• Find and Replace tool added
• Select Special Cells added
• Rows and Columns
- Autofit Rows
- Autofit Columns
- Autofit Rows and Columns


• Quick Number Formats
- General Format
- Numerical Format (0)
- Decimal Format (0.00)
- Dollars Format
- Euros Format - Pounds Format
- Yen Format
- dd/mm/yyyyy
- mm/dd/yyyyy
- yyyy-mm-dd (ISO)
- Manage Custom Formats (add up to 5 possible custom formats)


Column Menu
• Find and Replace tool added
• Select Special Cells added
• Rows and Columns
- Autofit Rows
- Autofit Columns
- Autofit Rows and Columns


• Quick Number Formats
- General Format
- Numerical Format (0)
- Decimal Format (0.00)
- Dollars Format
- Euros Format - Pounds Format
- Yen Format
- dd/mm/yyyyy
- mm/dd/yyyyy
- yyyy-mm-dd (ISO)
- Manage Custom Formats (add up to 5 possible custom formats)


Sheet Menu
• Insert Sheets (adding multiple sheets are possible)
• Select Specific Sheets (using checkboxes on a list of worksheets)
• Go To Sheet (type in the name)