AbleBits.com Toolbox for Microsoft Excel

Consolidate Worksheets Wizard

Easily consolidate multiple worksheets into one. Select the consolidation option you need: merge spreadsheets from different workbooks into one file, combine data from several worksheets into a single sheet, join workbooks without opening them.

Split Table Wizard

Split your table data across multiple spreadsheets based on key values in the selected columns. Instantly have complete pieces of information from your table in separate worksheets or files.

Extract Data

Group the selected rows by key values, convert them to column view and export to one or multiple worksheets. Effortlessly rearrange the contents of your table: group the extracted records or place row data in a questionnaire form.

Find Broken Links

Use this smart add-in to scan your current worksheet for broken links. Easily correct references to other Excel files to guarantee flawless summary worksheets.

Select Special Cells

Quickly find all cells that meet your criteria. Select cells by type, value and by font format.

Fill Blank Cells

Fill empty cells in the selected columns with the value of the cell above or below. Use it if numerous blocks with missing data in your table don't let you sort, filter your list or use some other Excel function.

Comments Manager

Conveniently work with cell comments in your worksheets. If you like to explain formulas, provide instructions or enter ideas in your sheet with comments, this tool will be your irreplaceable assistant.