By filtering your info, You aren't deleting rows, that you are hiding them. Hidden rows may be unhidden by selecting the row higher than and under the concealed row, proper-clicking on them and selecting "Unhide". The auto filter activates filtering for selected cells, when Advanced filters out using elaborate criteria. https://autofilter87418.blogadvize.com/41595286/new-step-by-step-map-for-auto-filter