{"id":16022,"date":"2023-07-10T20:16:31","date_gmt":"2023-07-10T20:16:31","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=16022"},"modified":"2024-03-28T14:53:36","modified_gmt":"2024-03-28T14:53:36","slug":"what-is-group-mode-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/","title":{"rendered":"What Is Group Mode in Excel"},"content":{"rendered":"\n
What-Is-Group-Mode-in-Excel<\/a>Download File<\/a><\/div>\n\n\n\n

When dealing with data in Excel, there is always a way to group the data by any criteria that we want. We can do this by turning on the Group Mode<\/strong>. <\/p>\n\n\n\n

Group Mode<\/strong> is used to group and summarize<\/strong> the range of cells or our data in the worksheet. It allows us to collapse or expand<\/strong> these rows and columns to create a more condensed and specific view of the data, allowing us to analyze and manage large sets of information.<\/p>\n\n\n\n

In the example below, we will show how this can be done.<\/p>\n\n\n\n

Use Group Mode in Excel<\/h2>\n\n\n\n

All of the data in Excel is presented in rows and columns. Grouping is done by being applied to either rows or columns. If you group your data by rows, you collapse the data into a single row or expand it to reveal detailed data that it consists of. The same thing is with columns- you collapse data into a single column or expand them to view the specific data.<\/p>\n\n\n\n

For our example, we can use the list of NBA players<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now, let\u2019s say that we want to group only the first two-three rows (titles and first two players). <\/strong>We will select them, and then go to the Data tab<\/strong>. In the Data tab<\/strong>, we will search for the Outline<\/strong>, and in the Outline<\/strong>, we will find the Group option<\/strong>.  <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

We will click on the Group<\/strong> and will have our data grouped by rows. Excel will add group symbols (numbers or plus\/minus signs)<\/strong> on the left side of the grouped rows. These will be great tools to expand or collapse the grouped sections.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

To collapse our data, we will press the minus sign<\/strong>, and have the following data shown:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

To see our original data again, we will click on the plus sign<\/strong>. With this, we will have our data shown and expanded again.<\/p>\n\n\n\n

To ungroup our data again, we will select it, and click on the Ungroup option<\/strong>:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

To do the same thing with columns, or in general, to get to the grouping option from wherever we are, we will simply go to Data \u00ad\u00ad>> Outline >> Group<\/strong>, and will get the pop-up:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Since we are positioned in column E<\/strong> if we choose Columns and OK<\/strong>, we will have only column E collapsed<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"

When dealing with data in Excel, there is always a way to group the data by any criteria that we want. We can…<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nWhat Is Group Mode in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to use Group Mode in Excel to group and summarize data, allowing you to analyze and manage large sets of information. Download the file here.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What Is Group Mode in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to use Group Mode in Excel to group and summarize data, allowing you to analyze and manage large sets of information. Download the file here.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-10T20:16:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-28T14:53:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"What Is Group Mode in Excel\",\"datePublished\":\"2023-07-10T20:16:31+00:00\",\"dateModified\":\"2024-03-28T14:53:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/\"},\"wordCount\":398,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/\",\"name\":\"What Is Group Mode in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png\",\"datePublished\":\"2023-07-10T20:16:31+00:00\",\"dateModified\":\"2024-03-28T14:53:36+00:00\",\"description\":\"Learn how to use Group Mode in Excel to group and summarize data, allowing you to analyze and manage large sets of information. Download the file here.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png\",\"width\":689,\"height\":275},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What Is Group Mode in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What Is Group Mode in Excel","description":"Learn how to use Group Mode in Excel to group and summarize data, allowing you to analyze and manage large sets of information. Download the file here.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"What Is Group Mode in Excel","og_description":"Learn how to use Group Mode in Excel to group and summarize data, allowing you to analyze and manage large sets of information. Download the file here.","og_url":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/","article_published_time":"2023-07-10T20:16:31+00:00","article_modified_time":"2024-03-28T14:53:36+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"What Is Group Mode in Excel","datePublished":"2023-07-10T20:16:31+00:00","dateModified":"2024-03-28T14:53:36+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/"},"wordCount":398,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/","url":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/","name":"What Is Group Mode in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png","datePublished":"2023-07-10T20:16:31+00:00","dateModified":"2024-03-28T14:53:36+00:00","description":"Learn how to use Group Mode in Excel to group and summarize data, allowing you to analyze and manage large sets of information. Download the file here.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/07\/word-image-16022-1.png","width":689,"height":275},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/what-is-group-mode-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"What Is Group Mode in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16022"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=16022"}],"version-history":[{"count":2,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16022\/revisions"}],"predecessor-version":[{"id":16031,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/16022\/revisions\/16031"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=16022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=16022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=16022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}