By filtering your knowledge, You aren't deleting rows, that you are hiding them. Hidden rows can be unhidden by choosing the row above and down below the hidden row, right-clicking on them and choosing "Unhide". When you filter data, entire rows are concealed if values in one or more columns https://elliotmnmki.blogmazing.com/33235418/facts-about-auto-filter-revealed