![grandtotal 3 grandtotal 3](https://www.mediaatelier.com/GrandTotal7/img/en/main_invoice.png)
![grandtotal 3 grandtotal 3](https://storage.googleapis.com/support-forums-api/attachment/thread-10879196-61826684783094689.png)
Save your file before you start Subtotaling!.Right-click on the new Sheet tab, select Rename, type Subtotal OR, and then press ENTER.When you see a sheet icon with a + sign, let go of the mouse button and then the CTRL key.Point at the Weekly OR sheet tab at the bottom of the screen, hold the CTRL key down, and left-drag the sheet to the right until you are past all the existing sheets.We want to find out what the weather looks like for each day of the week, so we’ll need to save our data to a new sheet, sort by the days of the week, and then convert the table in order to get ready to see the subtotal. If you want to limit your displayed data further, Filter in the Data tab in the ribbon.Subtotal in the Data tab in the ribbon.Convert the table back to a normal Excel range.Sort by the column you want to subtotal on.
![grandtotal 3 grandtotal 3](https://i.stack.imgur.com/lZL4A.png)
In order to subtotal successfully, you always need to do the following in order: It is recommended that you make a copy of the data you want to subtotal and place it in a new sheet, so that you can save the summary subtotaled data separately if desired. It is important to save often during this process and follow the steps carefully. This can provide Management with a report of higher level summary data one minute, and then can be easily switched back to detailed data the next minute. This is a powerful tool that allows you to quickly display multiple levels of summary data within your table. You can automatically calculate subtotals and grand totals in a table for a column.