{"id":355650,"date":"2021-10-21T00:00:00","date_gmt":"2021-10-20T21:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-group-and-ungroup-rows-and-columns-in-google-sheets\/"},"modified":"2021-10-21T00:00:00","modified_gmt":"2021-10-20T21:00:00","slug":"how-to-group-and-ungroup-rows-and-columns-in-google-sheets","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-group-and-ungroup-rows-and-columns-in-google-sheets\/","title":{"rendered":"#How to Group and Ungroup Rows and Columns in Google Sheets"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a35e1c0aa3d3\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a35e1c0aa3d3\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-group-and-ungroup-rows-and-columns-in-google-sheets\/#Group_Rows_or_Columns_in_Google_Sheets\" >Group Rows or Columns in Google Sheets<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-group-and-ungroup-rows-and-columns-in-google-sheets\/#Expand_or_Collapse_All_Row_or_Column_Groups\" >Expand or Collapse All Row or Column Groups<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-group-and-ungroup-rows-and-columns-in-google-sheets\/#Ungroup_Rows_or_Columns_in_Google_Sheets\" >Ungroup Rows or Columns in Google Sheets<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Group and Ungroup Rows and Columns in Google Sheets&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731741\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When working with a large spreadsheet, it can be difficult to see the specific data you need without constant scrolling. In Google Sheets, you can group rows and columns and then collapse and expand them as needed.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Group_Rows_or_Columns_in_Google_Sheets\"><\/span>Group Rows or Columns in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Select the rows or columns that you want to group. You can do this easily by dragging through them. Then, right-click and choose the Group option for the rows or columns you selected. Here, we\u2019re grouping rows 2 through 11.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755110\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/GroupRows-GoogleSheetsGroup.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the Group rows option\" width=\"432\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a selection of columns, you can right-click or click the arrow in one of the column headers to pick the Group option. Here, we\u2019re grouping columns B through E.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755111\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/GroupColumns-GoogleSheetsGroup.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the Group columns option\" width=\"650\" height=\"455\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After you group rows, columns, or both, you\u2019ll see a minus sign display in a shaded area on the left for rows or top for columns. Click the minus sign to collapse the group.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-755125 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/ExpandRowsColumns-GoogleSheetsGroup.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Grouped rows and columns expanded\" width=\"650\" height=\"291\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>The minus sign then transforms into a plus sign. So to expand again, click that plus sign.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-755124 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/CollapseRowsColumns-GoogleSheetsGroup.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Grouped rows and columns collapsed\" width=\"300\" height=\"127\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Expand_or_Collapse_All_Row_or_Column_Groups\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_1\">Expand or Collapse All Row or Column Groups<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>If you set up multiple groups of <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/446672\/how-to-freeze-or-hide-columns-and-rows-in-google-sheets\/\">rows or columns in your sheet, you don\u2019t have to click the individual plus and minus signs to expand or collapse each one.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Freeze or Hide Columns and Rows in Google Sheets<\/em><\/strong><\/p>\n<p>Right-click any of the plus or minus signs for a group. Then, select \u201cExpand All Row\/Column Groups\u201d or \u201cCollapse All Row\/Column Groups.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755114\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/CollapseExpandAll-GoogleSheetsGroup.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Expand or Collapse all groups\" width=\"550\" height=\"202\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>This lets you expand or collapse all of your row or column groups in one fell swoop.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Ungroup_Rows_or_Columns_in_Google_Sheets\"><\/span>Ungroup Rows or Columns in Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you finish using the groups to better view your data, you can easily ungroup the rows or columns.<\/p>\n<p>For rows, do one of the following:<\/p>\n<ul>\n<li>Select the rows, right-click, and pick the Ungroup option.<\/li>\n<li>Right-click the plus or minus sign for the row group and pick \u201cRemove Group.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755115\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/UngroupRows-GoogleSheetsGroup.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the Ungroup rows option\" width=\"428\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For columns, do one of the following:<\/p>\n<ul>\n<li>Select the columns, right-click, and pick the Ungroup option.<\/li>\n<li>Right-click the plus or minus sign for the column group and pick \u201cRemove Group.\u201d<\/li>\n<li>Select the columns, click one of the column headers, and pick the Ungroup option.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-755116\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/UngroupColumns-GoogleSheetsGroup.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select the Ungroup columns option\" width=\"650\" height=\"453\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>After you ungroup rows or columns, the plus and minus signs along with the shaded area will disappear.<\/p>\n<p>If you use Microsoft Excel in addition to Google Sheets, you can do something similar. You can group rows and columns to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/724558\/how-to-create-an-automatic-outline-in-microsoft-excel\/\">create a handy automatic outline for your data.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/755108\/how-to-group-and-ungroup-rows-and-columns-in-google-sheets\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Group and Ungroup Rows and Columns in Google Sheets&#8221; When working with a large spreadsheet, it can be difficult to see the specific data you need without constant scrolling. In Google Sheets, you can group rows and columns and then collapse and expand them as needed. Group Rows or Columns in Google Sheets&#8230;<\/p>\n","protected":false},"author":1,"featured_media":355651,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/google_sheets_her_1200x675.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-355650","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/355650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=355650"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/355650\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/355651"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=355650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=355650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=355650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}