Quick Excel Tip – Grouping Rows / Columns

As I mentioned in reply to haeso’s comment on the first video, there is method of joining rows or columns together called ‘grouping’.  It can be very useful when you want to have different ways of displaying data, or be able to collapse certain areas (underlying details, for example).

Here’s a screenshot explaining how you can do this using the menus in Excel 2010:

Explanation of Grouping Rows/Columns in Excel

A shortcut way to group rows or columns is to highlight the rows/columns you wish to group and use ALT+SHIFT+RIGHT ARROW to group the rows/columns, and ALT+SHIFT+LEFT ARROW to ungroup them. You can go multiple levels as well (so you could group rows 1-30, and then group rows 20-25 as a subgroup of the first). The levels are displayed at the top of the red box in haeso’s screenshot and can be clicked to view the entire sheet at any of the levels.  Remember: this can be done with both columns and rows (separately).

7 thoughts on “Quick Excel Tip – Grouping Rows / Columns

  1. How can I make multiple groupings of columns without embedding them within each other? I grouped columns C-E and then tried to group A and B as a separate pair but couldn’t unless I grouped them all together and embedded A and B within C-E.

    • Unfortunately, if they are next to each other, it will group them as well. You can group 2 levels deep though, so you could have A-E hidden in a 1st level grouping, and A-B at a level deeper. Isn’t a perfect solution but might work for your needs…

  2. I am trying to make a row of numbers to count on each other. F.E if i have 1,2,3,4 and i change any of the numbers i want all the other cells to change accordingly.
    Can you please help me figure out how to do it?

  3. How do you format the groups so that the max/min button is on the top like in the master workbook? When I group cells together in excel, the button is on the bottom, so I can’t have a title for that group and have the button be right next to the title. It will drop down when expanding the group instead of staying in the same place.

  4. Pingback: A Complete Introduction to Excel | MBAx.me

  5. How can i convert the digits into the words?
    Like i wrote 12000 in a cell then it could b automatically change into the words in oter cell. Like (Twelve Thousand).

Post any comments, feedback or questions below!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s