By filtering your data, You aren't deleting rows, that you are hiding them. Hidden rows could be unhidden by choosing the row previously mentioned and below the concealed row, correct-clicking on them and choosing "Unhide". This informative article should be practical to grasp the Auto Filter in Excel, with its alternatives https://autofilter25788.thekatyblog.com/32825083/a-review-of-auto-filter