![]() ![]() ![]() In order to use the Subtotal feature effectively, the data set must be clean or consistent. If you see Table Tools Design or Table Design in the Ribbon, your data set is an Excel table.īelow is the Table Tools Design tab in the Ribbon:ĭata sets should be set up correctly with unique column headings or field names in the first row, no merged cells and no blank rows or blank columns within the data set. To see if you data set is a table, click in the data and take a look at the Ribbon. If your data is an Excel table (created using the Table feature on the Insert tab or the Format tab in the Ribbon), you can't use the Subtotals feature. ![]() You can't use the Subtotal feature with Excel tables Recommended article: No Mouse? Using Keyboard Only Navigation in Microsoft Office (Part 1: The Ribbon)ĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses >Ĭheck out the following tips when working with the Subtotals feature in Microsoft Excel. You can insert subtotals in Microsoft Excel data sets or lists using the Subtotal feature (which appears on the Data tab in the Ribbon) to summarize data. 10 Useful Tips for Summarizing Data Using Excel's Subtotal Featureīy Avantix Learning Team | Updated April 9, 2021Īpplies to: Microsoft ® Excel ® 2010, 2013, 2016, 2019 and 365 (Windows)
0 Comments
Leave a Reply. |