Filter

%3CLINGO-SUB%20id%3D%22lingo-sub-2160755%22%20slang%3D%22en-US%22%3EFilter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2160755%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20made%20a%20huge%20mistake%20in%20creating%20my%20table%20in%20excel%3A%20not%20to%20make%20lines%20to%20big%20i%20wrote%20necessary%20information%20in%20line%20down%20but%20I%20did%20not%20put%20the%20same%20number%20into%20line%20down%20(i%20did%20not%20put%20any%20ordinal%20number%20too%20that%20lines%2C%20I%20just%20wrote%20Ibidem)%2C%20then%20I%20have%20done%20a%20lot%20of%20filters%20in%20the%20columns%20and%20know%20I%20realize%20that%20data%20in%20the%20lines%20with%20Ibidem%20and%20without%20ordinal%20number%20are%20in%20the%20wrong%20place%20in%20the%20table.%20It%20very%20difficult%20to%20explain....%20I%20add%20a%20prtscr%20photo%20as%20a%20example...%20you%20see%20number%20472%20in%20line%20and%20line%20down%20is%20empty%2C%20this%20line%20should%20be%20in%20the%20other%20place%20in%20the%20document.%20My%20question%20is%2C%20is%20there%20any%20possibility%20to%20back%20my%20data%20before%20any%20filter%20were%20used%3F%20Of%20course%20I%20press%20%22clear%22%20in%20the%20filter%20but%20it%20does%20not%20work...Thank%20You%20for%20the%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2160755%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2161576%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2161576%22%20slang%3D%22en-US%22%3EThis%20image%20is%20not%20sufficient%20to%20understand%20the%20issue%20%2C%2C%2C%20please%20share%20the%20WB%20with%20us%20!!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2161756%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2161756%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F976631%22%20target%3D%22_blank%22%3E%40KatarzynaB%3C%2FA%3E%26nbsp%3BIf%20you%20have%20just%20filtered%20items%20in%20your%20table%2C%20clearing%20the%20filter%20should%20bring%20the%20table%20back%20into%20it's%20original%20state%20as%20filtering%20does%20not%20re-order%20the%20rows%20of%20your%20table.%20It%20merely%20hides%2Funhides%20rows%20based%20on%20the%20filter%20settings.%3C%2FP%3E%3CP%3EHowever%2C%20if%20you%20have%20%3CSTRONG%3Esorted%3C%2FSTRONG%3E%20the%20table%20and%20if%20you%20have%20meanwhile%20saved%20and%20closed%20the%20file%2C%20there%20is%20no%20way%20to%20sort%20the%20rows%20with%20%22Ibidem%22%20back%20to%20their%20original%20place%20in%20the%20table.%3C%2FP%3E%3CP%3EIf%20you%20haven't%20saved%2Fclosed%20the%20file%20yet%20you%20can%20undo%20the%20last%20edits%20by%20pressing%20Ctrl-Z%20(on%20Windows%3B%20Cmd-Z%20on%20Mac)%20repeatedly%20and%20see%20how%20far%20back%20you%20can%20go.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

I have made a huge mistake in creating my table in excel: not to make lines to big i wrote necessary information in line down but I did not put the same number into line down (i did not put any ordinal number too that lines, I just wrote Ibidem), then I have done a lot of filters in the columns and know I realize that data in the lines with Ibidem and without ordinal number are in the wrong place in the table. It very difficult to explain.... I add a prtscr photo as a example... you see number 472 in line and line down is empty, this line should be in the other place in the document. My question is, is there any possibility to back my data before any filter were used? Of course I press "clear" in the filter but it does not work...Thank You for the help.

2 Replies
This image is not sufficient to understand the issue ,,, please share the WB with us !!

@KatarzynaB If you have just filtered items in your table, clearing the filter should bring the table back into it's original state as filtering does not re-order the rows of your table. It merely hides/unhides rows based on the filter settings.

However, if you have sorted the table and if you have meanwhile saved and closed the file, there is no way to sort the rows with "Ibidem" back to their original place in the table.

If you haven't saved/closed the file yet you can undo the last edits by pressing Ctrl-Z (on Windows; Cmd-Z on Mac) repeatedly and see how far back you can go.