The visibility rule: Excel only says what it can see. If you use filters to hide specific rows, Excel skips over them ...
Screen Ruler can be triggered with the Win + Shift + M shortcut by default, and it should go without saying at this point ...