98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Grouping in excel 2013
Grouping in excel 2013
Resolved · Urgent Priority · Version 2010
Hai-anh has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Dashboards for Business Intelligence course
Influencing Skills course
Negotiating Skills course
Grouping in excel 2013
Hi, for some reason in excel 2013, when I go to right click on the data which I have highlighted for grouping the option of "group" is not displayed.
Please can you advise on the excel 2013 version?
Many thanks,
Hai-anh
RE: grouping in excel 2013
Hi Hai-anh,
Thank you for the forum question.
You can find the grouping option in Excel 2013 if you click the DATA tab and click Group in the Outline group.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: grouping in excel 2013
Hi,
Thanks for responding to my question, but it's not coming up with the ranges in boxes like they used to?
For eg: how do you group age ranges from 30-50, 51-70?
The new group function does not seem to let me do this.
Many thanks,
Hai-anh
RE: grouping in excel 2013
Hi Hai-anh,
I am sorry but I thought you wanted to group columns or rows.
Is it in a Pivot Table you want to group by age?
If it is in a Pivot Table you need to select one cell inside the row/column you want to group and on the ANALYZE tab under PIVOTTABLE TOOLS click group field.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: grouping in excel 2013
Hi,
Many thanks for your help. The ANALYZE tab doesn't seem to exist and I have tried checking in the ribbon.
Please can you help?
Many thanks,
Hai-anh
RE: grouping in excel 2013
Hi Hai-anh,
You only have the ANALYSE tab in the ribbon if you are working with a Pivot Table.
You can only create age groups if you work with pivot tables.
Is it in a Pivot Table you want to group by age?
You can also create a custom filter where you can filter <=50 to see all below 50 and 50.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Colouring cells containing formulasCells in a worksheet can contain values or they can contain formulas. You may wish to identify all the cells in your worksheet that contain formulas by colouring those cells. |