How to Group Rows in Google Sheets | Scribe

    How to Group Rows in Google Sheets

    • Alai Umerez |
    • 11 steps |
    • 24 seconds

      How to Group Rows in Google Sheets Using the Menu

      1
      Locate the rows you want to group together Make sure they are consecutive, as Google Sheets only allows grouping of adjacent rows To select multiple rows, click on the number of the first row and drag downward to include the additional rows you wish to group
      2
      Go to the top menu bar and click on "View"
      3
      From the drop-down menu choose "Group"
      4
      Choose "Group rows \[range\]", where \[range\] represents the row numbers you selected. For example, in this case it says "Group rows 3–5"
      5
      After grouping the rows, you’ll notice a small minus (-) or plus (+) icon on the left-hand side of the row numbers Click the Minus (-) sign to collapse the group, hiding the rows
      6
      Click the plus (+) sign to expand the group, revealing the rows
      information ordinal icon
      Tip! Repeat the same process to ungroup rows

      How to Group Rows in Google Sheets Using the Keyboard Shortcut

      7
      Locate the rows you want to group together Make sure they are consecutive, as Google Sheets only allows grouping of adjacent rows To select multiple rows, click on the number of the first row and drag downward to include the additional rows you wish to group
      8
      Right-click on any of the selected rows and choose the option "View more row actions"
      9
      From the side menu, select Group rows…. As shown in our example, the menu option will indicate the selected rows (e.g., Group rows 3-5)
      10
      After grouping the rows, you’ll notice a small minus (-) or plus (+) icon on the left-hand side of the row numbers Click the Minus (-) sign to collapse the group, hiding the rows
      11
      Click the plus (+) sign to expand the group, revealing the rows