![]() |
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)? |
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