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:

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).

This entry was posted in Quick Tips and tagged , , , , . Bookmark the permalink.

7 Responses to Quick Excel Tip – Grouping Rows / Columns

  1. Anonymous says:

    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. Anonymous says:

    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. Anonymous says:

    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. Fahad Qureshi says:

    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).

Comments are closed.