Subtotals are added to the worksheet as another line similar to the Total line. The items continue to be numbered normally above and below them.
Insert subtotal through MultiSort
The easiest way to insert subtotals is through MultiSort.
-
Click
on the Worksheet toolbar.
-
Notice that the first checked column is in bold font. This is the primary sort column that will be used to insert subtotals.
If you want to change the primary sort column, use the Top, Move Up, Move Down and Bottom buttons. -
Check Insert subtotals after each unique value of the primary sort field.
-
Click OK.
This will add subtotals lines of the primary sort column to your worksheet.
Insert Subtotal Manually
To insert a price adjustment, click on the Item toolbar then select Subtotal, Single.
The subtotal will do the sum of all the items above it to the top of the worksheet or to the previous subtotal.
You can move the subtotal line up or down in the worksheet and it will total the items above it.
Move it using the move buttons. Notice the subtotal will automatically update as you move the lines.
Insert subtotal by a selection set
Another way to add a subtotal to the worksheet is to select a range of items.
From the Item toolbar, click and select Subtotal, By Selection.
If there are unselected items before the first selected item, the selected items will be moved up in the worksheet to follow the first subtotal appearing before the first selected items, or the top of the worksheet if there are no subtotals above the first selected item.
If the selection set was not contiguous, the unselected items will be moved below the inserted subtotal.
Remove subtotals
To remove one or many subtotals:
-
Select the subtotal or make it current.
If there is both a current item and a selected item in the worksheet, the selected item will be deleted. -
Right-click and select Delete, Current Item (or Selected Item).
-
Click Yes when you see a confirmation message.
To remove all subtotals, from the Item menu select Delete, All Subtotals.
To hide subtotals but not remove them, see Show or hide rows.