Useful addins for Excel 2010, 2007, 2003 - 2000
For Microsoft Excel 2010 (32-bit and 64-bit), Excel 2007, 2003, 2002, 2000.
With Excel Add-ins Collection by AbleBits you get 12 time-saving add-ins at less than half their regular price. More about Excel Add-ins Collection
The add-ins that you will find on this page are, in fact, an accumulation of our more than 11 years of experience with Microsoft Excel development. Over the years we've been adding new features, refining their code and polishing up the interfaces to make them as perfect as they can possibly be. Like you, we also use Excel on a daily basis and, frankly, we don't know how we would live without our Excel tools :)
Our add-ins can help you with the following tasks in Excel:
Ablebits Quick Tools is a handy 10-piece solution for Microsoft Excel that makes some time-consuming routine tasks easy and fun. Change columns order in your table and filter your records by the selected value, remove empty rows, columns and worksheets, calculate numerical data, work with external and absolute reference addresses.
From converting formulas to using the same selection – Quick Tools will considerably improve your Excel experience.
More about Quick Tools for Excel
Duplicate Remover for Microsoft Excel
With this time-saving add-in you can easily find and remove duplicates or unique entries. You can work with one list or compare two lists with up to 1 million rows. You can choose any columns for comparison and compare lists with different number of columns. Intuitive and user-friendly interface helps you browse lists for comparison and makes your work with the add-in pleasant and easy. You can delete duplicates from any range, select, color, copy or move them to another location (new workbook, new/existing worksheet), etc. Excel 2007 Ribbon interface is completely supported.
More about Find duplicates in Excel
This wonderful Excel plugin will polish off all typos and misprints from your Excel workbooks. The add-in searches for entries that differ in one to six characters in a list or a selected range. E.g. you can easily find and correct records like: Bred O'Nil, Bred Onil, Brad Oneal etc.
More about Finding similar records in Excel
This time-saving plugin quickly finds and merges two Excel tables into one by matching the values in the corresponding columns. These two tables can be located in the same Excel file or in two different Excel files. The intuitive and user-friendly interface of the wizard makes the join process fast and easy.
Rows from two tables with different number of columns will be matched perfectly without copying and pasting.
More about Excel: merge worksheets by matching data
If your Excel table has rows of different information referring to the same record, this 3-step Wizard lets you combine all duplicate rows into one without losing any data. Choose key columns, select columns with the values to merge and see all details for the record lined up on the same row.
More about merging duplicate rows and keeping unique information.
This handy Excel add-in merges, or joins, values from different cells. Use Merge Cells Wizard every time you need to place values from several cells to one cell, or when you need to join several cells and retain their values.
More about Merging Excel cells, rows, columns
Random Number Generator for Excel
Use Random Generator to fill the Excel range with unique random numbers, integers, real numbers, dates or strings in just one click. The add-in can also produce random passwords with different character sets, random strings of any length and pattern. Apart from that it can randomly select values from Excel custom lists, or your own lists and create worksheets from custom lists' values. Random Generator works for Microsoft Excel 2010, 2007, 2003, 2002 (XP) and 2000.
More about Generating unique random numbers in Excel
With Random Sorter for Excel you can easily shuffle individual cells in rows, columns or in the selected range, or randomly sort entire rows and columns.
You can instantly get a random selection of your data by specifying the needed percentage or exact number of entries: e.g. you can pick 10% of rows, or 5 columns, or 3% of cells from the selected range. The add-in is embedded into your Excel worksheets as a task pane and works with Microsoft Excel 2000 – 2010 (32-bit and 64-bit).
More about Random sorting and selection in Excel
Advanced Find & Replace for Microsoft Excel
This very handy add-in for Excel gives you simultaneous search in values, hyperlinks, formulas and comments in all opened or selected worksheets and workbooks .
You will have all search results displayed in a tree view and you'll be able to move between the search results easily, replacing values directly in the found items.
More about Advanced Excel Find and Replace add-in
Measurement Units Converter for Microsoft Excel
Measurement Units Converter performs various conversions between more than 200 measurement units in 18 different categories such as area, distance, fuel consumption, mass, temperature, time, volume etc. The add-in can be used either as a pane in your worksheets or Quick Converter residing on the Excel Ribbon. No matter how many values you want to convert: one unit, a few columns or the entire table, you need just 1 click and a few seconds to get the result.
More about Converting units in Excel
This is a plugin for managing Excel worksheets. It organizes all opened spreadsheets in a catalogue so that you can easily navigate through your Excel workbooks, drag worksheets throughout workbooks, insert, rename, delete, and resort them.
The plugin works like Excel Task pane so that you can work with your Excel workbook and see all the necessary data in the left part of the screen.
More about Managing worksheets and workbooks in Excel
Split Names for Microsoft Excel
The Split Names add-in for Microsoft Excel does exactly what its name suggests, i.e. splits names into individual cells. If you have a spreadsheet with numerous differently formatted names in the same column, the Split Names add-in will quickly clean up the mess and separate name parts into several columns. It recognizes First names, Middle names, Last names, and over 100 salutations, name suffixes and post-nominal letters.
More about Splitting names in Excel
Numbers stored as text, excess spaces and line breaks or words written in a wrong case, - you may not notice them until you need to process your data in Excel further. The Cell Cleaner plug-in automates such tasks as removing spaces between, before and after cell values, deleting and replacing line breaks, wiping non-printing or custom characters, converting numbers stored as text to number format and changing Excel text case.
More about Cleaning Excel data
Fill Blank Cells for Microsoft Excel is a helpful add-in that automatically fills blank cells in your table using values above or below the empty range. It can be especially useful if your spreadsheet has hundreds of rows with missing data, and copying the items manually would take you a really long time. With this handy application you can copy the contents from the first filled cell downwards or upwards the blank, fill all blank ranges in different columns of your table at once and take the advantage of the Split the merged cells option.
More about Fill Blank Cells
A wonderful Excel add-in that extends Excel's built-in AutoFormat and allows you to create, store and share your custom pivot table formats. You can create, save a new pivot table format and use it as a format template for your future Excel pivot tables.
More about Formatting Excel pivot tables
Trim Spaces for Microsoft Excel
This free add-in for Microsoft Excel will eliminate all leading and trailing excess spaces from your worksheets.
More about Trim Spaces for Microsoft Excel
