Forum Discussion
Auto Highlight an entire row - Eg: if you are D10 the entire row is highlighted.
Hello, Is it possible to highlight the entire row? For example, if you are moving from cell to cell, the cell you are in, the row is highlighted. Thanks in advance for your help. Michael ...
Thanks for your reply. Your file highlights each row permanently. All I want to do is highlight the row I am on, so I move to a different row; the previous highlight disappears, so you only highlight the row you are on.
I had the same request years ago, and stumbled on this very inexpensive Excel addin that does what you are looking for along with a slew of other cool helpful functions. Worth the price of admission.
Its called Kutools. They also have addins for other office programs as well.
This is the website: https://www.extendoffice.com/product/kutools-for-excel.html
Here is a screenshot of what you see as you navigate from cell to cell. This one highlights the column as well. Like a crosshair. I have found some vba scripts, but they all ruin any formatting you have, and because this addin is inexpensive and performs many other great time saving functions, its so worth it.