38  The subtotal hierarchy located to the left of the spreadsheet can be used to hide some of the data within  the spreadsheet. To view only the grand total, select column 1  To view the total for each subsection, select column 2  To view all data, select column 3. To subtotal this data sheet by semester:  Subtotals will automatically be added to your data. 1. Choose  Semester  for the  At Each Change  In dropdown.  2. Select  Sum  for the  Use Function  dropdown. 3. Choose  Amount Paid  for the  Add Subtotal To  field. 4. Click  Ok . 