ExTools is a free Microsoft Excel add-in program that has lot of useful functions that can make your life easier working with Excel.
While some of the functions available in ExTools simplify a task which normally would take much more time otherwise some tools in ExTools are additions which are not available in Excel. These can come in very handy when required.
For example, you might have had instances when you have empty rows or columns or rows within your data. As far as I know there is no easy way to remove these except to select them manually and remove them. However, with ExTools you can select the range of data and with a single click remove the empty rows or columns.
Then there is this Converter tool built into ExTools which can convert a lot of the most common units in categories like Area, Length, Volume etc. This is a very convenient option and can save you a lot of time.
I have listed some of the functions that caught my eye:
- Check for duplicates
- Save selection as html
- Save selection as Picture
- Hide blank rows/columns at end of sheet
- Remove hyperlinks on worksheet
- Conditional select Cells by Format
- Convert between Roman and Arabic Numbers
There are many more useful functions and tools within ExTools. I am sure you will find it useful and best of all it is free.
Download ExTools | Userguide | Installation guide
You May Also Be Interested In...
- Few Excel Tips to make you more productive
- How to change the default file type for Word 2007 and Excel 2007
- How to change the default folder to which Word and Excel files are saved
- An Excel AddIn to show Currency in Indian format and Words
- Quickly format any web page for printing with Printwhatyoulike
- Get things done fast with keyboard shortcuts for Windows, Word, Excel and Outlook
- How to Unprotect a Protected Excel Worksheet
- Easy ways to select text in a Microsoft Word document
Subscribe Now
If you enjoyed this post, you will definitely enjoy our others. Subscribe to the feed to get future posts delivered right to your mailbox or feedreader.
Powered by Thesis
An amazing WordPress Theme, nothing beats the versatility and SEO friendliness of the Thesis framework.
From beginners, to the most advanced WordPress developers, Thesis makes it easy for anyone to customize it.
{ 6 comments… read them below or add one }
Dear Suresh
I search a lot for getting a software to convert numbers but all softwares i find is not satisfied to my needs. today i get it.
Great Add-on, Thanks
Do you have add-on in Excel for using date in format dd/mm/yyyy
@Shankar: You don’t need any add-on to get dates to be formatted as dd/mm/yyyy. Just change the date format in the Windows’ Regional Settings (in Control Panel) to the desired format.
You don’t need any add-on to get dates to be formatted as dd/mm/yyyy. Just change the date format in the Windows’ Regional Settings (in Control Panel) to the desired format
i will be highly obliged if you tell me this setting in detail
I Want the following data from yours
Few excel tips for your more productive
Get things done fast shortcuts for word, excel and outlook
An excel addin show currency in indian rupee format and word