ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Getting Rid of [GROUP] ?? (https://www.excelbanter.com/excel-discussion-misc-queries/51619-getting-rid-%5Bgroup%5D.html)

ConfusedNHouston

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)?

Dave O

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.



All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com