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
 
Top