Highlight current row / column

Occasional Contributor

How do you highlight the current row/column?

 

I found this https://docs.microsoft.com/en-us/office/vba/excel/Concepts/Cells-and-Ranges/highlight-the-active-cel... but it wipes out formatting, and disables ctrl-z!!!  Without even a warning..

 

There must be some way to simply highlight the whole row/column, just as the current cell.

 

 

1 Reply

@ToasterGhost 

See the free Follow Cell Pointer add-in from Jan Karel Pieterse's download page