Need to ungroup cells but don't have the option.
 

I need to ungroup cells but group and ungroup are both grayed out options.
Why would that be and how can I ungroup?

Need to ungroup cells but don't have the option.
 

Is the sheet protected? (toolsprotection)

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Cara" wrote in message
...
I need to ungroup cells but group and ungroup are both grayed out options.
Why would that be and how can I ungroup?

Need to ungroup cells but don't have the option.
 

Unprotect is not an option but neither is protect. It's odd but a lot of the
options that are standard on all sheets are grayed out on this one.

"Peo Sjoblom" wrote:

Is the sheet protected? (toolsprotection)

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Cara" wrote in message
...
I need to ungroup cells but group and ungroup are both grayed out options.
Why would that be and how can I ungroup?

Need to ungroup cells but don't have the option.
 

This would indicate that the workbook is Shared.

ToolsShare Workbook.

Uncheck the "allow changes etc." option.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 10:21:03 -0700, Cara wrote:

Unprotect is not an option but neither is protect. It's odd but a lot of the
options that are standard on all sheets are grayed out on this one.

"Peo Sjoblom" wrote:

Is the sheet protected? (toolsprotection)

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Cara" wrote in message
...
I need to ungroup cells but group and ungroup are both grayed out options.
Why would that be and how can I ungroup?

Need to ungroup cells but don't have the option.
 

That did the trick, thanks a million!!!

"Gord Dibben" wrote:

This would indicate that the workbook is Shared.

ToolsShare Workbook.

Uncheck the "allow changes etc." option.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 10:21:03 -0700, Cara wrote:

Unprotect is not an option but neither is protect. It's odd but a lot of the
options that are standard on all sheets are grayed out on this one.

"Peo Sjoblom" wrote:

Is the sheet protected? (toolsprotection)

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Cara" wrote in message
...
I need to ungroup cells but group and ungroup are both grayed out options.
Why would that be and how can I ungroup?

Need to ungroup cells but don't have the option.
 

Thanks for the feedback.

Always helps us if we know what resolves a problem.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 11:24:02 -0700, Cara wrote:

That did the trick, thanks a million!!!

"Gord Dibben" wrote:

This would indicate that the workbook is Shared.

ToolsShare Workbook.

Uncheck the "allow changes etc." option.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 10:21:03 -0700, Cara wrote:

Unprotect is not an option but neither is protect. It's odd but a lot of the
options that are standard on all sheets are grayed out on this one.

"Peo Sjoblom" wrote:

Is the sheet protected? (toolsprotection)

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com


"Cara" wrote in message
...
I need to ungroup cells but group and ungroup are both grayed out options.
Why would that be and how can I ungroup?