ASAP Utilities is a powerful Excel add-in that fills the gaps in Excel.
Since 1999 it has grown to become probably one of the world's most popular add-ins for MS Excel.
A few of the tools that add new functionality to Excel and that are guaranteed to save you time and speed up your work:
Select cells based on content, formatting and more
Advanced sorting, sort by more than just values
Deselect cells in your selection
Apply formula to selected cells
Remove leading, trailing and excessive spaces
Sort the sheet tabs by name or color
Export worksheets as separate files
Quickly create many worksheets with auto-naming
Copy a worksheet's page and print settings
Protect multiple sheets at once
Insert before and/or after each cell in your selection...
Vision control: view workbooks, sheets and easily change their settings
File import and export tools (txt, csv, dbf, xls, gif, jpg, html, etc.)
More: list of all utilities and extra worksheet functions
The number of features in ASAP Utilities (300+) may seem a bit overwhelming, but taking a few minutes just to look everything over works wonders. You can add the tools that you like best to your favorites menu and assign your own shortcuts for quick access. You can also quickly search and start a tool without going through the menu.
Comments and Reviews
Many different, powerful utilities--some are a bit superfluous, but many get constant use. Note that this is free for non-commercial/educational use.
I am surprised something as great as this does not exist on GitHub nor is proved by Microsoft.