Merge Add-in for Excel for the Mac. RDBMerge is a user friendly way to Merge Data from Multiple Excel workbooks into a Summary Workbook. Download add-in for Excel 2011 or 2016. Note: RDBMerge is available as freeware. But you can use the Contact button in the menu if you want to support the development of this merge add-in. Click Data>Consolidate (in the Data Tools group). In the Function box, click the summary function that you want Excel to use to consolidate the data. The default function is SUM.
Show / Hide
A collection of tools allow you to quickly show or hide the workbooks, worksheets and ranges, Excel window settings, etc.
Work Area
This utility has embodied 3 types of working area settings in your Excel as follows:
- 1. To minimize the ribbon and hide the status bar;
- 2. To minimize the ribbon, hide the status bar and the formula bar;
- 3. To minimize the ribbon, hide the status bar, the formula bar, and the ribbon.
Always Show Comment
This feature will display the comment of the actively selected cell all the time, no matter where you move your mouse to.
Set Scroll Area:
It's a fantastic way to set or limit the scrolling area in your workbook. If you move around your worksheet a lot, or if you have data you don't want readers to explore, this tool is convenient for you to limit the visible area of your worksheet to only that which has actual data.
Unhide All Ranges:
Consolidate Duplicates In Excel
You can quickly unhide all the hidden ranges in active worksheet.
Hide Unselected sheets:
It allows you to quickly hide all the inactive (non-selected) sheets in the active (current) workbook with one click.
Unhide All Hidden Sheets:
Unhide all hidden sheets of the active workbook with one click. Normally you have to unhide all hidden worksheets one by one in Excel.
Hide Inactive Windows:
If you have opened multiple workbooks in Excel, this tool allows you to quickly hide all the other inactive workbooks with one click.
Mining Target
Unhide All Hidden Windows:
Unhide all hidden workbooks with one click. Normally you have to unhide all hidden workbooks one by one in Excel.
Hide/Unhide Workbooks and Sheets:
Interactively hide or unhide multiple workbooks and worksheets at one time. Normally you have to hide or unhide the workbook and worksheet one by one in Excel. This is a handy tool for you to handle a large workbook with a bundle of worksheets.
View Options:
Excel Consolidate Data Multiple Rows
With this utility, you can quickly toggle any of the following settings: gridlines, horizontal scrollbar, vertical scrollbar, row and column headers, page breaks, formula view, sheet tabs, status bar, formula bar, full-screen display, comment visibility, and object visibility. Save your time from looking for where to toggle any of the above settings. It's all done interactively, so you can see the preview before you commit to it.