Topics Map > IT Services > Training
Topics Map > IT Services > Software Support

Microsoft Excel 2016 - Subtotals

This guide will show you how to add subtotals to sheets as well as how to export subtotals.

Subtotals can be useful for displaying all the things that fall into certain categories..

  1. Sort the data ahead of time into the groups desired.
  2. On PC, select the Data Tab and then select the Subtotal tool. On Mac, select from the Mac Menubar, Data > Subtotal
  3. Select the column which should be used for sub-group creation from the drop down menu “At Each Change In”.
  4. Add desired subgroups and settings. Select OK.
After the data has been put into subgroups, it may need to be exported. However, exporting it will only end up with strange-looking and corrupted data. Here is how to properly export sub-grouped data.
  1. Select the Home Tab.
  2. Select Find & Select from the Editing section.
  3. Select Go to Special from the drop down menu.
  4. Select Visible Cells Only.
  5. Export the data

If you need further assistance please contact the Information Technology Help Desk at 920-424-3020 or

Keywords:"Data Management", subgroups   Doc ID:65969
Owner:Richard L.Group:UW Oshkosh
Created:2016-08-10 15:22 CDTUpdated:2016-08-10 15:23 CDT
Sites:UW Oshkosh
Feedback:  0   0