By filtering your data, You're not deleting rows, you might be hiding them. Hidden rows is often unhidden by selecting the row over and below the hidden row, right-clicking on them and selecting "Unhide". You could implement filters to each column with your details range, providing you with a lot https://finnyfscm.blogchaat.com/34166158/a-review-of-auto-filter