Menu
What I want to achieve is to highlight active row or column. I used VBA solutions but everytime Selection_change event is used I am loosing chance to undo any changes in my worksheet.
Is there a way to somehow highlight active row / column without using VBA?
1000
So, you need to refresh Excel manually. ➤ Press F9. As a result, Excel will refresh itself and the active row will be highlighted. So, now you just need to select a cell and press F9 to highlight the active row.
Select the letter at the top to select the entire column. Or click on any cell in the column and then press Ctrl + Space.
Click the small paint bucket icon, which has a yellow line underneath it, in the “Font” section of the Excel ribbon. Choose the color to use to actually highlight the lines. Click the small colored square. Now both lines are actually highlighted, even when you click off them.
The best you can get is using conditional Formatting.
Create two formula based rules:
=ROW()=CELL("row")=COLUMN()=CELL("col")As shown in:
The only drawback is that every time you select a cell you need to recalculate your sheet. (You can press "F9")
110
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
