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

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

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

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

On Tue, 30 Jun 2009 14:04:01 -0700, Bernard
wrote:

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

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

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

Greetings from New Zealand

"Bernard" wrote in message
...
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