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

[Cara]

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

[Peo Sjoblom]

Is the sheet protected? (tools>protection)

--


Regards,

Peo Sjoblom

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


"Cara" <[email protected]> wrote in message
news:[email protected]...
>I need to ungroup cells but group and ungroup are both grayed out options.
> Why would that be and how can I ungroup?

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

"Peo Sjoblom" wrote:

> Is the sheet protected? (tools>protection)
>
> --
>
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
>
>
> "Cara" <[email protected]> wrote in message
> news:[email protected]...
> >I need to ungroup cells but group and ungroup are both grayed out options.
> > Why would that be and how can I ungroup?
>
>
>

[Gord Dibben]

This would indicate that the workbook is Shared.

Tools>Share Workbook.

Uncheck the "allow changes etc." option.


Gord Dibben MS Excel MVP

On Wed, 26 Jul 2006 10:21:03 -0700, Cara <[email protected]> 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? (tools>protection)
>>
>> --
>>
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>> Excel 95 - Excel 2007
>> Northwest Excel Solutions
>> www.nwexcelsolutions.com
>>
>>
>> "Cara" <[email protected]> wrote in message
>> news:[email protected]...
>> >I need to ungroup cells but group and ungroup are both grayed out options.
>> > Why would that be and how can I ungroup?
>>
>>
>>

[Cara]

That did the trick, thanks a million!!!

"Gord Dibben" wrote:

> This would indicate that the workbook is Shared.
>
> Tools>Share Workbook.
>
> Uncheck the "allow changes etc." option.
>
>
> Gord Dibben MS Excel MVP
>
> On Wed, 26 Jul 2006 10:21:03 -0700, Cara <[email protected]> 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? (tools>protection)
> >>
> >> --
> >>
> >>
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >> Excel 95 - Excel 2007
> >> Northwest Excel Solutions
> >> www.nwexcelsolutions.com
> >>
> >>
> >> "Cara" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >I need to ungroup cells but group and ungroup are both grayed out options.
> >> > Why would that be and how can I ungroup?
> >>
> >>
> >>
>
>

[Gord Dibben]

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 <[email protected]> wrote:

>That did the trick, thanks a million!!!
>
>"Gord Dibben" wrote:
>
>> This would indicate that the workbook is Shared.
>>
>> Tools>Share Workbook.
>>
>> Uncheck the "allow changes etc." option.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Wed, 26 Jul 2006 10:21:03 -0700, Cara <[email protected]> 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? (tools>protection)
>> >>
>> >> --
>> >>
>> >>
>> >> Regards,
>> >>
>> >> Peo Sjoblom
>> >>
>> >> Excel 95 - Excel 2007
>> >> Northwest Excel Solutions
>> >> www.nwexcelsolutions.com
>> >>
>> >>
>> >> "Cara" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >I need to ungroup cells but group and ungroup are both grayed out options.
>> >> > Why would that be and how can I ungroup?
>> >>
>> >>
>> >>
>>
>>

[Gord Dibben]

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 <[email protected]> wrote:

>That did the trick, thanks a million!!!
>
>"Gord Dibben" wrote:
>
>> This would indicate that the workbook is Shared.
>>
>> Tools>Share Workbook.
>>
>> Uncheck the "allow changes etc." option.
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Wed, 26 Jul 2006 10:21:03 -0700, Cara <[email protected]> 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? (tools>protection)
>> >>
>> >> --
>> >>
>> >>
>> >> Regards,
>> >>
>> >> Peo Sjoblom
>> >>
>> >> Excel 95 - Excel 2007
>> >> Northwest Excel Solutions
>> >> www.nwexcelsolutions.com
>> >>
>> >>
>> >> "Cara" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >I need to ungroup cells but group and ungroup are both grayed out options.
>> >> > Why would that be and how can I ungroup?
>> >>
>> >>
>> >>
>>
>>