Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ConfusedNHouston
 
Posts: n/a
Default Getting Rid of [GROUP] ??

I am importing data from a text file and reducing it down to 2 columns; one
with names, one with numeric values. I save the file as an Excel workbook
and then proceed to edit the data. This editing involves sorting, performing
some deletions, re-sorting, etc. Sometimes for a reason entirely unknown to
me, the term [GROUP] appears at the end of the file name. When [GROUP] is
invoked, I can't sort the data.

What causes the status of my file to change to [GROUP] and how do I get the
file back to a 'normal' Excel worksheet (so that I can perform sorting on the
data)?
  #2   Report Post  
Dave O
 
Posts: n/a
Default Getting Rid of [GROUP] ??

It may be caused during the course of clicking around among and between
tabs that you accidentally press the Shift key. You can make it happen
on purpose by pressing Shift and clicking a different tab: note that
both tabs are highlighted and you receive the [Group] notation. When
[Group] is invoked, any change you make on one tab will be made in the
grouped tabs as well, so use caution!

De-invoke [Group] by right-clicking a grouped tabname, then select
Ungroup Sheets.

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
How do I turn off [Group] mode? tothemax Excel Discussion (Misc queries) 4 April 2nd 23 08:13 PM
What does the '[Group]' label in the Excel title bar mean? Leon Brown Excel Discussion (Misc queries) 4 August 30th 05 09:17 PM
what does .xls [Group] mean? animalashton Excel Discussion (Misc queries) 2 March 7th 05 02:49 PM
FILENAME [GROUP] Roberto Excel Discussion (Misc queries) 2 January 5th 05 08:31 PM
[group] in heading washnepo Excel Discussion (Misc queries) 2 December 6th 04 05:39 PM


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

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

About Us

"It's about Microsoft Excel"