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
Gray Sheet - Excel 2003 3
Gray area on spreadsheet 2
Missing Rows after Ungrouping 1
2007 Pvt Group/Ungroup symbols 3
How do I delete the words Page 1 printed across my spreadsheet? 2
Grouping Dates in Pivottable Excel 2007 1
Excel 2007: Pivot sharing same cache? 1

Top