By filtering your knowledge, You aren't deleting rows, you will be hiding them. Hidden rows can be unhidden by deciding upon the row over and under the hidden row, right-clicking on them and deciding upon "Unhide". The auto filter turns on filtering for picked cells, when State-of-the-art filters out working https://damienvlwit.blog5star.com/34580549/5-essential-elements-for-auto-filter