The Ultimate Time Saving Excel Tools

$35.00

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)




© Copyright andrewsexceltips.net All Rights Reserved.