You can temporarily highlight the current row (without changing the selection) by pressing Shift+Space. Current column with Ctrl+Space.

Highlight active row/column in Excel without using VBA? Stackoverflow.com

Extremely useful tip if you’re working with large spreadsheets.

Roberto Mateu @roberto