Forum Discussion
Data>Outline doesn't show Subtotal at all
I have data (not in a table) and I want to subtotal but the Data>Outline group only shows Group and Ungroup. There is no option at all for Subtotal. This is Excel online. What's the problem?
7 Replies
The problem is that is Excel Online, so far it has limited functionality compare to desktop version. In particular, there is no Subtotal for outlines.
- Are there any limeted funtions more in web version?
- I would think that Excel Online, even with limited functionality, would have Subtotals.
Outline (group) data in a worksheet
You can group (or outline) rows and columns in Excel for the web.
Note: Although you can add summary rows or columns to your data (by using functions such as SUM or SUBTOTAL), you cannot apply styles or set a position for summary rows and columns in Excel for the web.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
