In this tip, We are going to explore: How to group Rows or Columns? All explanations are simple and to the point. To group Rows or Columns First, we select the columns or rows, then right-click and click View more action. Then click Group. A button above the columns or rows appears, which allows us to show/hide them. To ungroup, right-click the icon, then click Remove group.