Operis Analysis Kit
  • Applications
    • Spreadsheet Modelling
    • Spreadsheet Review
  • Features
  • Pricing
  • Support
    • FAQ
    • Documentation
  • Blog
  • About OAK
  • Get in touch
Operis Analysis Kit
  • Applications
    • Spreadsheet Modelling
    • Spreadsheet Review
  • Features
  • Pricing
  • Support
    • FAQ
    • Documentation
  • Blog
  • About OAK
  • Get in touch

Start your free trial

Blog

How to use Excel Group Rows function 19 Apr 2022

Share now

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.

 

 


Share now

Categories

  • Discover OAK
  • Modelling Insights
  • OAK Releases

Archive

Companies who decipher complex spreadsheets with OAK

engie-energy-and-services-logo

Pricing

Reduce the time and cost associated with interpreting a spreadsheet model using OAK. See what’s included in the price.

Blog

Discover how OAK helps solve a myriad of Excel issues on our blog.

Support

We’re here to help. Get answers to questions about installation, licensing and new releases.

Everything you need to build, analyze and audit a spreadsheet. And make better decisions

Try OAK for free
OAK
  • Features
  • Pricing
  • About OAK
  • Support
Legal
  • Privacy Notice
  • Cookie Policy
  • Legal disclaimers
OAK Applications
  • Spreadsheet Modelling
  • Spreadsheet Review
Contact us
  • 110 Cannon Street
    London
    EC4N 6EU
  • +44 (0)20 7562 0400
  • [javascript protected email address]
Winners of the 2020 Financial Modelling Innovation Awards

©2023 Operis Analysis Kit. All Rights Reserved.

Powered by FL1 Digital