Why Excel Online Does Not Have the Consolidate Command
Question details
The user needs to consolidate worksheet data while using Excel Online on a Mac.

- Product
- Microsoft Excel Online
- Device & OS
- Mac
- Scenario
- Using Office 365 Personal in a browser to combine data from multiple ranges.
- Observed behavior
- The Consolidate command is not available in Excel Online, and desktop Excel preferences are not accessible from the browser.
Identify the ranges you want to combine and where you want the results to appear. If you plan to use the Consolidate command, make sure the Excel desktop app is installed and you can sign in with an account licensed to use it.
Use the Consolidate command in desktop Excel
Open the workbook in the desktop app when you need Excel's built-in Consolidate command.
Consolidate may not be available in Excel Online. Changing desktop ribbon preferences in the browser will not add the command.
In Excel Online, use the editing or Open in Desktop App option to open the workbook in Excel for Mac. If that option is unavailable, open the file from Excel's File > Open menu.
In Excel for Mac, select Help > Check for Updates and install any available updates.
Select a cell in an empty area where you want the consolidated results to begin.
Select Data > Consolidate, choose a function such as Sum, select a source range in the Reference box, and click Add. Repeat for each range.
In the Consolidate dialog, select Top row or Left column if your ranges have matching labels, then click OK.

Combine matching cells with a formula in Excel Online
Use a formula when you only need to total corresponding cells from a few worksheets in the same workbook.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets in a familiar interface. Open compatible Excel files and move your spreadsheet work to WPS with ease; it does not add the Consolidate command to Excel Online.

Frequently Asked Questions
Can I add Consolidate to the Excel Online ribbon?
If Consolidate is unavailable in Excel Online, desktop ribbon settings will not add it to the browser. Open the workbook in desktop Excel and look under Data > Consolidate.
Where is Consolidate in Excel for Mac?
Open the workbook in the Excel desktop app, select a destination cell, and choose Data > Consolidate.
Can I combine worksheet data without desktop Excel?
For simple totals in Excel Online, enter a formula such as =SUM(Sheet1!A1,Sheet2!A1) in a result cell. This combines specified cells but does not automatically match labels.
How do I update Excel on my Mac?
In the Excel desktop app, select Help > Check for Updates and follow the prompts. An update does not guarantee that the command will appear in Excel Online.




