Excel group rows and columns function is an accessory to make hiding/unhiding rows and columns easier. Worksheets with lots of complicated and detailed information can be hard to read and analyse. Luckily, Microsoft Excel provides an easy way to organise data in groups allowing you to collapse and expand rows with similar content to create more compact and understandable views.

Reasons to use Excel Group Function

• To easily expand and contract sections of a worksheet
• To minimize schedules or side calculations that other users might not need
• To keep information organized
• As a substitute for creating new sheets (tabs)
• As a superior alternative to hiding cells

How to group rows or columns in Excel:

1. Select the rows you want to group, the entire row not just cells
2. Go to the data ribbon at the top
3. Select Group

You can repeat the steps above as many times as you like, and you can also apply it to columns as well.

Once you’re finished, you can press the “-” buttons in the margin to collapse the rows or columns.

Tip. To create a new group faster, press the Shift + Alt + Right Arrow shortcut instead of clicking the Group button on the ribbon.

Read more on Excel : Delete named range

Follow the pictures below to see a step-by-step run-through.