AVAST Software - New
The official launch is scheduled for the 29th of July 2011. We think you’ll be pleased with the rich features and simplicity of operation that have been built into these solutions. For the first time, a management console has built expressly fmore...
Description
Add-ins for Microsoft Excel
For Microsoft Excel 2010, Excel 2007, Excel 2003, Excel XP (2002), and Excel 2000.
For ease and comfort of use:
- Our Excel add-ins have friendly user interfaces.
- All addins are easy to install, they are menu driven and very fast.
- All Excel plugins come with detailed instructions in the help files that are easily accessible from the opening dialogs.
Excel Add-ins Collection
Get 11 most popular Excel add-ins with a 60 % discount.
The Excel Add-ins Collection by AbleBits offers you 11 time-saving add-ins for Excel at less than half price.
These add-ins will automate routine operations, such as removing duplicates, typos and misprints, merging cells and tables, navigating through multiple sheets, pivot table formatting and more.
More about Excel Add-ins collection
Removing duplicates
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 Removing Excel duplicates
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 and deleting fuzzy duplicates, misprints
Matching and merging Excel tables
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 Merging Excel tables
Merging cells
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 cells, rows, columns, fields in Excel
Splitting names and titles
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 Split Names for Excel
Generating random numbers, strings, random sort
Use Random Generator to fill the Excel range with unique random numbers, integers, real numbers, dates or strings in just one click. Sort randomly in rows, columns or a range, and fill the selected cells with random values from Microsoft Excel custom lists or your own custom lists. The add-in works for Microsoft Excel 2010, 2007, 2003, 2002 (XP) and 2000.
More about Generating unique random numbers in Excel
Find and replace
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 Finding and replacing in Excel
Pivot table formatting
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
A free add-in for Microsoft Excel that adds several useful buttons to the AutoFormat for PivotTables' toolbar.
More about Pivot Table Helper
Managing worksheets
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. This Excel add-in will also help you manage worksheet names, hyperlinks, links, comments, errors and conditional formatting.
More about Explorer for Microsoft Excel
Colors and styles
This handy add-in for Microsoft Excel allows you to create unique color palette collection quickly and easily. With Excel Color Manager you can create and manage various kinds of color palettes and gradient colors, quickly change the current color palette in your workbook and restore the standard color palette with a click.
More about Creating colors and palettes in Excel
With this handy Excel plugin you can easily create your own unique Excel styles and formats. Unlike the built-in Style dialog, Excel Style Manager displays all styles and formats and shares styles between workbooks. You can create a new Excel style collection with new fonts, font sizes, borders and share it with your colleagues. You can create a new style in one workbook and use it in another.
More about Creating styles and formats in Excel
Free Excel add-ins
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
This free Excel plugin enriches the built-in Special Cells dialog and simplifies access to other Excel functionalities. Cells containing conditional formats, formulas, comments, values can be found and selected with two clicks on a single dropdown menu of the Cells Assistant for Excel toolbar.
More about Cells Assistant for Excel
