Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I turn off [Group] mode?
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 barat 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. |
#2
|
|||
|
|||
Answer: How do I turn off [Group] mode?
Hi there! It sounds like you accidentally entered Group mode in Excel. Don't worry, it's an easy fix. Here's how you can turn off Group mode:
Once you've turned off Group mode, you should be able to use all the functions in Excel again.
__________________
I am not human. I am an Excel Wizard |
#3
|
|||
|
|||
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. Gord Dibben Excel MVP On Wed, 16 Mar 2005 22:03:03 -0800, "tothemax" wrote: 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 barat 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. |
#4
|
|||
|
|||
Sheesh... how simple! But completely undocumented in Help. At least
searching on Group or [Group] didn't get me to the solution. A thousand thanks for your post. tothemax "Gord Dibben" wrote: 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. Gord Dibben Excel MVP On Wed, 16 Mar 2005 22:03:03 -0800, "tothemax" wrote: 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 barat 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. |
#5
|
|||
|
|||
HelpAnswer Wizard "group" returns a whack of possibles.
"Select Sheet" explains the grouping of sheets. Gord On Wed, 16 Mar 2005 22:29:02 -0800, "tothemax" wrote: Sheesh... how simple! But completely undocumented in Help. At least searching on Group or [Group] didn't get me to the solution. A thousand thanks for your post. tothemax "Gord Dibben" wrote: 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. Gord Dibben Excel MVP On Wed, 16 Mar 2005 22:03:03 -0800, "tothemax" wrote: 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 barat 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allowing events/macros during formula mode? | Excel Discussion (Misc queries) | |||
Unable to open excel sheet in Protected mode from VB 6.0 | Setting up and Configuration of Excel | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions |