By filtering your information, You aren't deleting rows, you're hiding them. Concealed rows might be unhidden by picking the row above and underneath the hidden row, proper-clicking on them and picking out "Unhide". This post need to be helpful to understand the Auto Filter in Excel, with its options and examples. https://lanefvgrc.myparisblog.com/34654126/auto-filter-options