SOLVED
Home

What have I done - Group

%3CLINGO-SUB%20id%3D%22lingo-sub-1033430%22%20slang%3D%22en-US%22%3EWhat%20have%20I%20done%20-%20Group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1033430%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Excel%20Masters%2C%3C%2FP%3E%3CP%3EI%20was%20copying%20and%20pasting%20some%20%22Sum%22s%20-%20Ctrl%20C%20%26amp%3B%20Ctrl%20V.%20Next%20thing%20I%20know%20one%20cell%20listing%20has%20disappeared%20from%20my%20Sum%20.%20well%20I%20guess%20I%20over%20wrote%20it%20when%20I%20was%20pasting%2C%20no%20problem%20Ctrl%20Z%20(undo).%20Nothing.%20again%3F%20nothing.%20again%3F%20nothing.%20hmm.%20Then%20I%20noticed%20that%20at%20the%20top%20of%20my%20page%20it%20now%20says%20%22FileName%22%20-%20Group%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20have%20any%20smart%20ideas%20what%20I%20may%20have%20done%3F%20and%20how%20I%20can%20resolve%20it%3F%20this%20is%20a%20very%20important%20and%20intensive%20file%2C%20which%20I%20would%20rather%20not%20have%20to%20resort%20back%20to%20a%20prior%20saving%20of%20if%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20Thanks%2C%3C%2FP%3E%3CP%3ELaura%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1033430%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
LazyBee
Occasional Contributor

Hi Excel Masters,

I was copying and pasting some "Sum"s - Ctrl C & Ctrl V. Next thing I know one cell listing has disappeared from my Sum . well I guess I over wrote it when I was pasting, no problem Ctrl Z (undo). Nothing. again? nothing. again? nothing. hmm. Then I noticed that at the top of my page it now says "FileName" - Group

 

 

 

Anyone have any smart ideas what I may have done? and how I can resolve it? this is a very important and intensive file, which I would rather not have to resort back to a prior saving of if possible.

 

Many Thanks,

Laura

4 Replies

FYI it has also removed my ability to trace any precendants or decendants;

 

Solution

@LazyBee 

You get that message on the title bar when two or more sheets are grouped.

To get rid of that, right click on the active sheet tab name and choose Ungroup Sheets.

 

Ungroup Sheets.jpg

Amazing! Thankyou @Subodh_Tiwari_sktneer, that's just the thing, worked a treat

You're welcome @LazyBee! Glad I could help.