By filtering your info, you are not deleting rows, you're hiding them. Concealed rows may be unhidden by choosing the row above and down below the hidden row, correct-clicking on them and picking out "Unhide". After you filter information, total rows are concealed if values in one or more columns https://felixjsxdi.win-blog.com/14645150/considerations-to-know-about-auto-filter