Note: Excel 2007 and above, 32 bit only
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)