Dose for Excel - a powerful, feature-rich add-in for Excel

Use this reliable Excel extension to easily manage the information contained in certain fields, filter cells, remove blank rows and more.

If you are tired of removing duplicated rows, or loaded by comparing sheets, or having a headache doing complicated tasks in Excel, then Dose for Excel is the powerful handy tool for you to simplify all these complicated tasks into few clicks. It provides more than +100 advanced new functions and features added into the Excel ribbon for your easy use.

Large collection of Excel editing functions
The advantages brought by Dose for Excel to the spreadsheet editor are simple and very handy especially for users who often work with Excel. Some features are new to Excel while others are greatly simplified.

You can delete custom rows with one mouse click, for instance entire empty lines, rows that contain at least one empty cell or duplicates. Moreover, the tool allows you to remove lines that contain a specific value. The functions are available for current sheet, for the selected sheets or the entire workbook.

The Clear Spaces option allows you to remove leading, trailing, extra spaces or all fields in the sheet.

Cell management made easy
Dose for Excel allows you to merge or split the selected cells, as well as add a background color to each field. The tool also includes data filters, a date picker, as well as a row-to-column converter.

You can easily customize the size of the work area, as well as add or edit comments with the help of the dedicated assistant. For instance, you can display only the comments for the selected cells, display only symbols of the comments or convert them into cells. An additional function is the case changer that allows you to switch words to upper/lower or proper case.

Create backups with one mouse click
Dose for Excel allows you to generate backups with the help of the dedicated function. You can set the tool to automatically backup the data each time you close Excel, or only on demand. The add-in integrates with Excel and creates an individual section in the command ribbon. Moreover, its ease of use makes it convenient for any user.

Features and Highlights

Compare Sheets
Compare sheets peer to peer or based on column, and highlight the updated, new, deleted rows and cells.

Auto Backup
Never lose your Excel data using this tool, auto backup your workbooks on open or on-demand with the ability to set backup destination.

Date Picker
Pop up a date picker pane to insert your date easily to a range of cells, you can set your own date & time format.

Trim Spaces
Remove leading, trailing, or extra spaces for a selected cell or worksheet or the whole workbook with one click.

Count by Color
Calculate sum, count, average, min, max based on background or font color in a range, and generate a report.

Merge
Merge cells, rows, and columns into one with the ability to specify a separator between them.

Split
Split first and last names, or split a range based on a character or separator.

Formula Helper
Dose for Excel Add-In provides more than 100+ built-in complex formulas that you could frequently use without the need to remember how to create the formula.

Functions
Apply more than 50+ advanced built-in functions without wasting time to write VBA code for it, save time.

Data Cleaning
Clean your worksheet easily by trimming spaces, change characters' case, convert text to numbers, and vice versa.

Change Case
Change letters case into UPPER, lower, Proper Case, or Capitalize the first character within a cell.

Duplicates
Color duplicated values each group of matched cells values colored by its own color.

Columns
Delete identical columns, blank columns, hidden columns, columns contain specific values, columns of at least one blank cell, all with one click.

Text / Numbers
Remove from selected cells (Only Characters, Only numbers, Only symbols) with one click.

Rows
Delete or highlight identical rows, blank rows, hidden rows, rows contain a specific value, rows of at least one blank cell, all with one click.

Export
Export selected sheets each in a separate workbook to your local disk.