Others

Why Excel Online Does Not Have the Consolidate Command

Olivia MillerOlivia Miller Nov 20, 2026 869 views

Question details

The user needs to consolidate worksheet data while using Excel Online on a Mac.

Why Excel Online Does Not Have the Consolidate Command
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the desktop app

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.

2
Check for updates

In Excel for Mac, select Help > Check for Updates and install any available updates.

3
Choose a destination

Select a cell in an empty area where you want the consolidated results to begin.

4
Add source ranges

Select Data > Consolidate, choose a function such as Sum, select a source range in the Reference box, and click Add. Repeat for each range.

5
Create the result

In the Consolidate dialog, select Top row or Left column if your ranges have matching labels, then click OK.

Use the Consolidate command in desktop Excel
Desktop access required: The browser version and the desktop app have different features. Installing updates does not add the desktop Consolidate command to Excel Online.
Free Microsoft Office alternative

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.

Open and edit spreadsheets in a familiar tabbed interfaceWork with Microsoft Excel XLSX and XLS filesUse formulas to combine values from worksheet cellsAccess a free, lightweight office suite
microsoft office alternative - wps office

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.