Nokia C3: How to turn off Group Mode in Microsoft Excel

How to turn off Group Mode in Microsoft Excel
I'm stuck in Excel - I somehow entered a [Group] mode that blocks most functions. Can't find anything in Help on this topic. [Group] appears on the blue box the top of the Excel window after the filename. I found I could enter [Shared] mode and turn that on and off but have not found the key to turning off the [Group] mode.
Reply With Quote
#2
Old 05-01-2012
Koman Koman is offline
Member

Join Date: Jul 2011
Posts: 563
Re: How to turn off Group Mode in Microsoft Excel
First make note of which sheet tabs are white-colored. These are the grouped sheets. You can select one of them or right-click on one and "ungroup" and they will ungroup. Note: while you have been in group mode, what has been done to the active sheet in the group has been done to all. Check your data on each sheet carefully.
Reply With Quote
#3
Old 05-01-2012
AnitG AnitG is offline
Member

Join Date: Aug 2011
Posts: 491
Re: How to turn off Group Mode in Microsoft Excel
To create identical with little effort Excel spreadsheets. What is entered in group mode, has an impact on all tables in this group - no matter if you charge something, delete or reformat. When multiple worksheets are selected, the group mode is enabled. Text, data and formulas that you enter into a grouped worksheet appear in all the other worksheets in the group.

* To Activate the group mode: Click on the sheet tab of the sheets that you want while holding down the Ctrl key.
* To Deactivate group mode: Click on the tab of a workbook that does not belong to the group or click on any tab, if all the worksheets in the workbook to the group belong.

Reply With Quote