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

C

Cara

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

Cara

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.
 
G

Gord Dibben

This would indicate that the workbook is Shared.

Tools>Share Workbook.

Uncheck the "allow changes etc." option.


Gord Dibben MS Excel MVP
 
C

Cara

That did the trick, thanks a million!!!

Gord Dibben said:
This would indicate that the workbook is Shared.

Tools>Share Workbook.

Uncheck the "allow changes etc." option.


Gord Dibben MS Excel MVP
Click to expand...
 
G

Gord Dibben

Thanks for the feedback.

Always helps us if we know what resolves a problem.


Gord Dibben MS Excel MVP
 
Top