Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I turn off [Group] mode? | Excel Discussion (Misc queries) | |||
What does the '[Group]' label in the Excel title bar mean? | Excel Discussion (Misc queries) | |||
what does .xls [Group] mean? | Excel Discussion (Misc queries) | |||
FILENAME [GROUP] | Excel Discussion (Misc queries) | |||
[group] in heading | Excel Discussion (Misc queries) |