Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies. Only from Platform Scholar.
Solved
Grouping rows in excel 2013?
Posted on 2014-04-03
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
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
[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
2
4 Comments
Active 4 days ago
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
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
Active 1 day ago
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
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
Active 1 day ago
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
Cancel future meetings from user mailboxes in Office 365 using Remove-CalendarEvents
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month4 days, 23 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.