Solved

Grouping rows in excel 2013?

Posted on 2014-04-03

1 solution

2,043 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

Comment

Question by:REIUSA

[X]

Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

Help others & share knowledge
Earn cash & points
Learn & ask questions

Join The Community

4 Comments

LVL 4

Expert Comment

by:Dash Amr

ID: 399770932014-04-03

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

LVL 33

Accepted Solution

by:Rob Henson

Rob Henson earned 500 total points

ID: 399775452014-04-04

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

LVL 33

Expert Comment

by:Rob Henson

ID: 399779132014-04-04

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

Author Closing Comment

by:REIUSA

ID: 399893552014-04-09

Thanks, so simple just didn't see that option.

Featured Post

Question has a verified solution.

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

Error 0xc004d307 When Rearming Office 2013 for KMS

Article by: Paul

This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…

Simple Audit Log

Article by: Dale Fye

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.

Microsoft Access

Creating a Scrolling Chart in Excel

Video by: AnnieCushing

This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

Microsoft Excel

How to export Office 365 mailboxes to PST using eDiscovery

Video by: CodeTwo

In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…