How can I get the commands in excel which are gray, active again?

B

Bernard

Some of the commands in excel, like for example on the Data menu, under group
and ungroup are gray shaded: "Group, "Ungroup" and I want to make it active
so I can use them on a spreadsheet. If anyone can help I would appreciate it
 
G

Gord Dibben

The sheet could be protected. Unprotect it.

You could have more than one sheet selected. Uungroup the sheets.

The workbook could be shared. Unshare it.


Gord Dibben MS Excel MVP
 
B

Bill Kuunders

go to <tools> <protection> and unprotect the sheet or book

Greetings from New Zealand
 

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

Under data/Group&outline/group 1
Active Content in this file is blocked issue 1
Dates In Excel 5
Gray Sheet - Excel 2003 3
Need Help with Macro Security 1
Excel - Wich Function should I use? 1
Dumb question alert! What program to use? 0
Automatic Emails sent to my Contact Groups by Microsoft 1

Top