Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Grouping rows in excel 2013?

Posted on 2014-04-03
4
Medium Priority
?
2,282 Views
Last Modified: 2014-04-09
I'm sure there is a easy way to do this but is there a good way to group items in rows so that I can expand or collapse them?

I know there is a group button but it seems really clunky and every time I try it the heading for the group is on the bottom which seems backwards to me.

Is there a better way to group rows or a way to make the heading of the group on the top so it expands down?

Attached a file showing an example of what type items I am trying to group.

Thanks,
Group.xlsx
0
Comment
Question by:REIUSA
  • 2
4 Comments
 
LVL 4

Expert Comment

by:Dash Amr
ID: 39977093
I have attached the file Please let me know if this is what you looking for

First you need to Freeze the header :

http://www.wikihow.com/Add-Header-Row-in-Excel

then you select Data  grouping according to what you need to group

http://www.wikihow.com/Group-and-Outline-Excel-Data
https://www.youtube.com/watch?v=0V4G7H2u538
Group.xlsx
0
 
LVL 34

Accepted Solution

by:
Rob Henson earned 2000 total points
ID: 39977545
In the same Ribbon Group (Outline) as the Group and Ungroup buttons, click the bottom right hand corner of the Ribbon Group.

This will bring a small set of options, one of which is to set Summary rows below the detail. Untick it and when you Group the collapse buttons will be ta the top of the group.

Thanks
Rob H
0
 
LVL 34

Expert Comment

by:Rob Henson
ID: 39977913
Just taken a look at your file. I am assuming that the rows with "Revenue" and "Widgets Sold" should be a total of the lines below.

If your data was laid out slightly differently you would be able to use the Subtotal function.

For example, in column A you have Revenue Jan, Revenue Feb, Revenue Mar etc...

If you had in Column A just "Revenue" and then inserted a column for the month, you would be able to run the Subtotal Function Wizard such that it looks for changes in column A and applies the grouping accordingly. You can set the Wizard to apply subtotals above the data and it will apply a heading of "Revenue Total".

See attached.

Thanks
Rob H
Copy-of-Group.xlsx
0
 

Author Closing Comment

by:REIUSA
ID: 39989355
Thanks, so simple just didn't see that option.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question