Microsoft Excel has an option that allows you to group rows and columns. When you group rows or columns, you will be able to collapse them so that the grouped elements are not visible, thus making the table clearer and easier to navigate.
Watch our video tutorial where we show you how to group rows and columns in Microsoft Excel, using Windows 10.
- How to Group Rows and Columns in Microsoft Excel
- It is possible to group only rows and columns that are next to each other. Otherwise, grouping is not possible.
- Select the rows or columns you want to group. You can do this by holding Shift and clicking on the rows or columns you want to select.
- Click on Data
- Click on Group
- Click on Group…