• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 297
  • Last Modified:

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.
0
dbfromnewjersey
Asked:
dbfromnewjersey
  • 2
  • 2
2 Solutions
 
Rgonzo1971Commented:
Hi

Data / Outline / Group

Regards
0
 
Rob HensonFinance AnalystCommented:
Still on the Data tab.

Tab can be customised under Excel Options. Maybe somebody has hidden the Outline group (accidentally or deliberately). I have just looked to do that on mine but the Grouping options are greyed out.

Thanks
Rob H
0
 
dbfromnewjerseyAuthor Commented:
There is no Data tab that I see. How do I get it to display?
0
 
dbfromnewjerseyAuthor Commented:
ok. I was able to add it. Thanks.
0
 
Rob HensonFinance AnalystCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now