You can temporarily highlight the current row (without changing the selection) by pressing
Shift+Space. Current column withCtrl+Space.
Highlight active row/column in Excel without using VBA? Stackoverflow.com
Extremely useful tip if you’re working with large spreadsheets.