How to turn off Group Mode in Microsoft Excel

[AlandraJ]

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.

[Koman]

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.

[AnitG]

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.