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 peer to peer or based on column, and highlight the updated, new, deleted rows and cells.
Never lose your Excel data using this tool, auto backup your workbooks on open or on-demand with the ability to set backup destination.
Pop up a date picker pane to insert your date easily to a range of cells, you can set your own date & time format.
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 cells, rows, and columns into one with the ability to specify a separator between them.
Split first and last names, or split a range based on a character or separator.
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.
Apply more than 50+ advanced built-in functions without wasting time to write VBA code for it, save time.
Clean your worksheet easily by trimming spaces, change characters' case, convert text to numbers, and vice versa.
Change letters case into UPPER, lower, Proper Case, or Capitalize the first character within a cell.
Color duplicated values each group of matched cells values colored by its own color.
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.
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 selected sheets each in a separate workbook to your local disk.