Have you ever felt problems like this in excel, like,
>> Your Filters will not work.
>> If you write something in some cell of one sheet, it will automatically update in same cell of another sheet.
Do you know, this, actually is not a problem. This happens because you have grouped the sheets.
How to ungroup the sheets and get rid of this?
Its easy, go to sheet name, click options(right click on mouse), select ungroup.
Note : Grouping of sheets is useful if you have to work on one sheet and you want same sheets to be backed up/copied to another sheet on real time manner.
Find us on facebook : www.facebook.com/cashelpline
>> Your Filters will not work.
>> If you write something in some cell of one sheet, it will automatically update in same cell of another sheet.
Do you know, this, actually is not a problem. This happens because you have grouped the sheets.
How to ungroup the sheets and get rid of this?
Its easy, go to sheet name, click options(right click on mouse), select ungroup.
*** Please Follow Us if You Found This Helpful***
***Enjoy Playing With Excel***
Find us on facebook : www.facebook.com/cashelpline
Find us on twitter : www.twitter.com/CAsHelpline
Contact : cashelpline@gmail.com
No comments:
Post a Comment