By filtering your information, You aren't deleting rows, that you are hiding them. Concealed rows may be unhidden by choosing the row over and beneath the concealed row, right-clicking on them and choosing "Unhide". As an example: a column made up of names could be filtered by those containing “A” https://auto-filter20852.webbuzzfeed.com/34590108/top-auto-filter-secrets