How do I Create a Collapsible Sub-total?


Step 1: Go to the table where you want to insert sub total

Step 2: From the ribbon select Home | in the Tables group | Sub-Total Add or select Table Tools | in the Operation group | Sub-TotalAdd

Step 3: The Select Rows dialog will appear. Select the rows you wish to include in the sub-total. 

Step 4: Select Create collapsible section. 

Step 5: Select Apply title and subtotal styles (This will apply the subtotal bold style to the title and subtotal row).

Step 6: Enter "Title description" and "Subtotal description".

Step 7: Click OK to insert Collapsible Sub-total section.

Attached Files
There are no attachments for this article.
Related Articles
How to Print/Hide Page Numbers
Viewed 9375 times since Fri, Jun 13, 2014
How do I use the Linkage Feature in a DIY Table?
Viewed 1304 times since Tue, May 30, 2017
Detailed Trading Accounts in Financials IFRS Template
Viewed 5023 times since Thu, May 1, 2014
Summary of Financial Reporting and Auditing Requirements for Incorporated Associations
Viewed 2195 times since Thu, Jun 12, 2014
How to delete a Note in the Financial Statements
Viewed 2947 times since Fri, Jun 13, 2014