Share via

Is there Consolidate functionality and the Data Tools in Excel Online?

Anonymous
2019-02-01T22:42:50+00:00

I need to consolidate several worksheets into 1. I read that this can be done by clicking Consolidate button and performing subsequent steps. But there is no Consolidate button on the Ribbon in my Excel Online version and no options to customize the Ribbon. Is it possible that Excel Online my company purchased is limited in some features?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2019-02-02T03:02:59+00:00

    Hi Lana,

    According to my test, the consolidate function is only available in Excel local client.

    Features in Excel Online and Excel client are different.

    We would like to suggest you leave a comment to Excel Online UserVoice to improve our product.

    Thanks for your understanding.

    Best Regards,

    Gloria

    7 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-02-06T22:22:09+00:00

    Thank you. I will leave a suggestion.

    0 comments
  2. Anonymous
    2019-02-02T02:30:52+00:00

    Hi Lana,

    Excel Online has limited features compared to the desktop version.

    Here's more info:

    https://support.office.com/en-us/article/differ...

    0 comments