CPA Resource Zone

Excel Tutorials for CPA's

Pivot Table and Trial Balances Function and Example

When the above is accomplished, click OK and then Finish. The result will be a new tab with our pivot table in it (see tab Step 4-Pivot in the combined file):

Created pivot table

The wizard created total lines for each account (rows 6, 8, etc.) and for the two periods (column E). Those totals do not provide much value to our comparative trial balance and thus, we want to hide them. To hide total rows, point your mouse at the edge of column A and row 6 so that the cursor becomes a black arrow and left click on it. This action will select all total rows. Then right click on selected row 6 and click Hide:

Hiding total rows

Once you hide the total rows, you will see that the comparative trial balance is much cleaner:

Total rows hidden

Page 6 of 7