G Guest Jul 26, 2006 #1 I need to ungroup cells but group and ungroup are both grayed out options. Why would that be and how can I ungroup?
I need to ungroup cells but group and ungroup are both grayed out options. Why would that be and how can I ungroup?
P Peo Sjoblom Jul 26, 2006 #2 Is the sheet protected? (tools>protection) -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com
Is the sheet protected? (tools>protection) -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com
G Guest Jul 26, 2006 #3 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.
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 Jul 26, 2006 #4 This would indicate that the workbook is Shared. Tools>Share Workbook. Uncheck the "allow changes etc." option. Gord Dibben MS Excel MVP
This would indicate that the workbook is Shared. Tools>Share Workbook. Uncheck the "allow changes etc." option. Gord Dibben MS Excel MVP
G Guest Jul 26, 2006 #5 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...
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 Jul 26, 2006 #6 Thanks for the feedback. Always helps us if we know what resolves a problem. Gord Dibben MS Excel MVP
Thanks for the feedback. Always helps us if we know what resolves a problem. Gord Dibben MS Excel MVP
