| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel comes up gray screen when first launched | Excel Discussion (Misc queries) | |||
| How do you shade 10% gray on an excel row? | Excel Discussion (Misc queries) | |||
| Why does my excel chart appear in gray when I copy it? | Charts and Charting in Excel | |||
| Please help Gray excel view | Setting up and Configuration of Excel | |||
| menu commands are gray | Excel Discussion (Misc queries) | |||
Linear Mode
