Ooh! This sounds like what's happened to me on my spreadsheet! I entered some information say, in line 11 on TAB B and later on realised that the same information appeared on the same line in TAB A, TAB C, TAB D etc. When I tried to delete it from one of the other tabs (prior to realising the information was elsewhere, too), it deleted the original information from TAB B which is where I wanted it. Luckily I was able to undo that as I hadn't saved the info. However, it looks like when this information was duplicated in other tabs, it's removed the information that had occupied line 11 in the other tabs. I wonder how I can stop the duplication.
@MIMGURU3 жыл бұрын
good
@ntsikelelomaqubela27543 жыл бұрын
Thank you. However when I enter a paste column values copied from another excel file in one of the sheets, even though I no longer want the sheets grouped, the other sheets are populated too. How do I disable this feature? Sorry, just noticed that the excel I'm copying from also had grouped sheets. When I disabled that grouping, the data wasn't pasted throughout the other sheets in my new excel file.