Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tothemax
 
Posts: n/a
Default 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   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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:
  1. Look for the "Group" button on the "Data" tab in the ribbon. It looks like two rectangles overlapping each other.
  2. Click on the "Group" button to ungroup the selected cells. If the button is grayed out, it means that you don't have any grouped cells selected.
  3. If you're still having trouble, try selecting any cell that is not part of the grouped cells and then click on the "Ungroup" button.
  4. If none of the above steps work, try pressing the
    Code:
    Ctrl + Shift + 8
    keys on your keyboard. This is the shortcut for toggling Group mode on and off.

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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   Report Post  
tothemax
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
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
Allowing events/macros during formula mode? shorowit Excel Discussion (Misc queries) 1 February 9th 05 06:32 PM
Unable to open excel sheet in Protected mode from VB 6.0 ourspt Setting up and Configuration of Excel 0 January 26th 05 12:07 PM
Combo Box goes to edit mode even if design mode is in OFF position Chas Excel Discussion (Misc queries) 0 January 7th 05 08:21 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich New Users to Excel 2 December 9th 04 03:06 AM
coverting answer from Radian mode to degree mode Xmastrzman Excel Worksheet Functions 1 November 10th 04 05:45 PM


All times are GMT +1. The time now is 06:07 PM.

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

About Us

"It's about Microsoft Excel"