By filtering your knowledge, You're not deleting rows, you're hiding them. Hidden rows is often unhidden by selecting the row over and under the hidden row, right-clicking on them and choosing "Unhide". The auto filter activates filtering for selected cells, even though Sophisticated filters out making use of complicated requirements. https://auto-filter97530.thenerdsblog.com/39881196/the-fact-about-auto-filter-that-no-one-is-suggesting