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 No 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 No comments

2 additional answers

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

    Thank you. I will leave a suggestion.

    0 comments No 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 No comments