Under data/Group&outline/group

B

Bernard

On a spreadsheet I am trying to use the command Group/Ungroup under data menu
but these commands are gray shaded. How can I reactivate these commands?
Thanks
 
S

Shane Devenshire

Hi,

here are some of the reasons those commands may not be available:
1. The sheet is portected
2. You are in Group mode - more than one sheet selected
3. You are in Edit mode - press Enter or Esc
4. Your workbook is in Share mode.

I'm sure there are others
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I get the commands in excel which are gray, active again? 2
Problem with private E-Mails that cant be seen in shared Mailboxes. 0
Printing Outline view - formatting lost 0
Grouping Names in Mail Merge 0
Automatic Emails sent to my Contact Groups by Microsoft 1
Add additional information to excel form after original data entry 0
Save a custom chart as a template 0
Dates In Excel 5

Top