The visibility rule: Excel only says what it can see. If you use filters to hide specific rows, Excel skips over them ...
Excel's Custom Views tool lets you create a snapshot of your spreadsheet, allowing you to toggle between layouts.