{"id":2049,"date":"2014-10-20T01:59:30","date_gmt":"2014-10-20T07:29:30","guid":{"rendered":"http:\/\/news.filepuma.com\/?p=2049"},"modified":"2014-10-20T01:59:30","modified_gmt":"2014-10-20T07:29:30","slug":"how-to-group-rows-or-columns-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/www.filepuma.com\/reviews\/how-to-group-rows-or-columns-in-microsoft-excel\/","title":{"rendered":"How to Group Rows or Columns in Microsoft Excel?"},"content":{"rendered":"<p>If there are too many rows of data in Excel, you may want to group and hide some of them, leaving only the big picture numbers visible. You can then expand the areas which need to be reviewed only when needed, rather than scrolling down on endless rows.<br \/>\nHere is how to group rows in Excel:<br \/>\nStep One. Open Microsoft Excel and click on \u201cData\u201d from the top menu:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2050\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2014\/10\/qAtYN6625444b91ce31ed758401159.png\" alt=\"01\" width=\"419\" height=\"210\" \/><\/p>\n<p>Step Two. In your worksheet, highlight as many rows as you want to group and hide:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2051\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2014\/10\/wteND9325444b942e2fa1455678974.png\" alt=\"02\" width=\"364\" height=\"229\" \/><\/p>\n<p>Step Three.\u00a0 Press the \u201cGroup\u201d button in the top right corner:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2052\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2014\/10\/epPkM4585444b956bb9c4700772206.png\" alt=\"03\" width=\"301\" height=\"244\" \/><\/p>\n<p>Step Four. Select \u201cRows\u201d from the radio button and click OK:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2053\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2014\/10\/EbWxs5465444b96a20419884737133.png\" alt=\"04\" width=\"310\" height=\"201\" \/><\/p>\n<p>Step Five. The rows will now be grouped and hidden, and you can expand them only when needed by clicking on the \u201c+\u201d sign:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2054\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2014\/10\/wWNSU7615444b9d099d12420024112.png\" alt=\"05\" width=\"352\" height=\"241\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If there are too many rows of data in Excel, you may want to group and hide some of them, leaving only the big picture numbers visible. You can then expand the areas which need to be reviewed only when needed, rather than scrolling down on endless rows. Here is how to group rows in [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-2049","post","type-post","status-publish","format-standard","hentry","category-communications"],"_links":{"self":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/2049","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/comments?post=2049"}],"version-history":[{"count":0,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/2049\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/media?parent=2049"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/categories?post=2049"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/tags?post=2049"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}