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

G

Guest

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

Guest

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
 
G

Guest

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
 

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

Ungroup "+" on a protected sheet 6
Userinterfaceonly 5
grouping option grayed out... 1
OT but nowhere to ask. How do I ungroup my tabs in FF? 4
How to UNGROUP worksheets, please? 3
How do you ungroup charts in Powerpoint 07? 2
Ungrouping a table 5
Lock/Protect Grouping Feature in Excel 4

Top