LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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?






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Groups of cells between workbooks vnacj-joe Excel Discussion (Misc queries) 4 June 14th 07 05:18 PM
Checkboxes vs. Option Buttons JW_4222 Excel Discussion (Misc queries) 2 February 1st 06 01:38 PM
requires that merged cells must be identically sized? Catt Excel Discussion (Misc queries) 11 July 3rd 05 12:36 PM
When shading cells using the 'pattern' option, they print in grey. Todd Excel Discussion (Misc queries) 0 March 11th 05 06:37 PM
Strange Problem with Chart and Plot Visible Cells Option Marcus Leon Charts and Charting in Excel 1 January 7th 05 03:52 AM


All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"