Last month we talked about using the subtotal command.\u00a0 In addition to inserting subtotals, it automatically groups the rows to make a sort of collapsible outline. But if you already have a spreadsheet that is sorted and subtotaled the way you want, you may want to\u00a0 add your own groupings so that you can hide or show detail with a single click.<\/p>\n
Grouping is very easy to do.\u00a0 If you have a spreadsheet with amounts on lines 4, 5, and 6 that are subtotaled on line seven.\u00a0 Select rows 4, 5, and 6, then go to the Data menu, and choose Group & Outline, then Group.\u00a0 In the left margin you will see the lines and box indicating your group.\u00a0 You can click the box to expand or roll up your group.\u00a0 You can add as many groups as you want to your spreadsheet.\u00a0 You can even have groups within groups.\u00a0 This is a great way to make a large, spreadsheet easy to navigate.<\/p>\n
Be sure to take some time to explore the other choices in the Group and Outline menu, especially Auto Outline.\u00a0 And remember that grouping can be done on columns too, not just rows.<\/p>\n","protected":false},"excerpt":{"rendered":"
Grouping rows in Excel allows you to roll up sections of a spreadsheet so that you can have both detail and summary views of the same data. Switching between the two views is as simple a single click.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[],"_links":{"self":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/122"}],"collection":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=122"}],"version-history":[{"count":4,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/122\/revisions"}],"predecessor-version":[{"id":125,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/122\/revisions\/125"}],"wp:attachment":[{"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=122"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=122"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iqaccountingsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}