Top 5 Free Microsoft Excel Add-ins

excel logo Top 5 Free Microsoft Excel Add insMicrosoft Excel is one of the most used office applications. It has a lot of features which can be used to analyze, share, and manage your data easily. However, some features like formulas, complex menus and toolbars may make it a bit tough to use.

To make it easier to use, we can use add-ins or plugins. Excel add-ins will improve the functionality of Excel and will help you perform different operations better than before. Here are 5 Best Microsoft Excel Add-ins or plugins.

Change Units

Change Units is an unit convertor add-in for MS-Excel. It is used for providing parse able units conversion as well as conversion to and from standard metric units. It is easy to use, since it directly converts any combination of units to any other combination of units in a single step. The syntax is flexible and easy, and the interchanged values are updated instantaneously.  This Excel add-in can be freely downloaded here.

change units Top 5 Free Microsoft Excel Add ins

Cells Assistant

Cells Assistant for Excel is an add-in that enriches the built-in Special Cells dialog and gives easy access to other functionality of Microsoft Excel. Cells containing conditional formats, formulas, comments, values can be searched and selected with a one click on the Cells Assistant toolbar. You can save a lot of time in editing cells. This Excel add-in can be freely downloaded at this link

clip image014 Top 5 Free Microsoft Excel Add ins

Trim Spaces

The extra spaces in Excel worksheets are hard to remove manually. This add-in helps you remove leading and trailing spaces in selected cells. Using it is very easy, you just need to select a cell(s), click the “Run” button of the add-in and no excess spaces are left in your Excel worksheet.  This Excel add-in can be freely downloaded it here

clip image018 Top 5 Free Microsoft Excel Add ins

Excel Utilities

This Excel add-in is a bundle of frequently used features. These include some nifty shortcuts and selection tools. The wide variety of features available in this add-in are name box sizing, locate specific number format, and a utilities toolbar. The best feature is the one click access button which will simplify operations like Conditional Formatting, Data Validation, Goto Special, Paste Special and Define Name dialogs etc. Download it here

excelutility Top 5 Free Microsoft Excel Add ins

Ultimate Add-in

Ultimate Add-In is a collection of utilities which will allow you to create bookmarks, find duplicates, increase the number of undos (up to 100), protect multiple sheets, remove worksheet/book protection, named range manager, multiple Sum If generator, conversion tools and loads (200+) more.The below screenshot shows the different functions it can perform. Download Ultimate Add-in

clip image026 Top 5 Free Microsoft Excel Add ins

If you have a favorite Microsoft Excel Add-in with better features, share them through your comments.

By Prasanth Chandra, Check Out his Tech Blog PCs Place.  You can find him on Twitter @pcsbox and Facebook

Advertisement

9 Comments

  1. Nirmal
    Jul 27, 2009 @ 22:51:38

    The author’s link at the bottom of the post is pointing to some exe file download.

    • Kyle Judkins
      Jul 28, 2009 @ 11:01:08

      Thanks for the heads up. It’s fixed.

  2. Phaoloo
    Jul 27, 2009 @ 23:34:11

    Nice plugins for excel :D

  3. Dominic Brown
    Aug 11, 2009 @ 04:41:00

    As the author of Ultimate Add-In, I’d like to say thank you for including it in your list, and also that a 2007 version is now available for download from http://www.dom-and-lis.co.uk.

    Ultimate Add-in 2007 will integrate directly into your Office ribbon for ease of use. Apologies for the shameless plug … ;-)

  4. Suneel
    Aug 25, 2009 @ 10:59:11

    I would also like to add Excel plugin for keyword research which offers competitive analysis of the keywords and what’s more, you can perform the search using just your Excel sheet.

  5. Kumar
    Mar 13, 2011 @ 17:51:00

    Best one is ASAP Utilities

  6. Gsomp
    Mar 17, 2011 @ 13:55:00

  7. Richard Gailey
    Nov 10, 2011 @ 11:28:00

    Nice article Kyle.
    Extools is the one I use the most (as well as Dominic’s Ultimate Add-in) It’s free and can be found here:
    http://www.excel-extools.com/

  8. paul
    Jul 09, 2012 @ 06:44:00

    the links to ultimate addin do not seem to work