Link to home
Start Free TrialLog in
Avatar of Jenkins
JenkinsFlag for United States of America

asked on

Where is the grouping option in Excel 2010?

I'm not seeing the grouping option.  In Excel 2007, it was under the Data tab as I recall.  I'm on 2010 now and can't find the darn thing.
SOLUTION
Avatar of Rgonzo1971
Rgonzo1971
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jenkins
Jenkins
Flag of United States of America image

ASKER

There is no Data tab that I see. How do I get it to display?
Avatar of Jenkins
Jenkins
Flag of United States of America image

ASKER

ok. I was able to add it. Thanks.
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image
Go to File Tab and Select Excel Options at the bottom.

This shows a WIndow with two panes. In the left hand pane select the Customize Robbon option. In the right hand pane will appear two lists with Add and Remove buttons between them. The right hand list should have an option for the Data tab which I suspect is not ticked. Tick and OK.

Thanks
Rob H