Highlight cursor position

Question

Excel 2007: Is there any way to high light the cursor position in a way that at a glance it is in the right place prior to entering data? I am sure that I have seen screen shots where the column and row is gently filled with a colour thus visually showing the cursor position.

Answer 1

As long as you do not have colored cells on the worksheet, maybe you can use this simple event code to do what you want...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Cells.Interior.ColorIndex = 0

    Union(Target.EntireColumn, Target.EntireRow).Interior.ColorIndex = 36

End Sub

To install this code, go to the worksheet you want to have this functionality, right click its name tab and select View Code from the popup menu that appears, then copy paste the above code into the code window that opened up. That's it, go back to the worksheet and click around.

---

NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.

Answer 2

Hi,

Maybe you've seen this addin

http://www.cpearson.com/excel/rowliner.htm

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 3

Thank you for the code, Rick!  Works great!

I modified it slightly for my needs to highlight the cursor row only (and not the column).  Here is the modified Row Only code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

     Cells.Interior.ColorIndex = 0

     Target.EntireRow.Interior.ColorIndex = 36

 End Sub

Thanks again!

Mike

Answer 4

Not helpful.

I remember years ago you could change the color of the cursor so that you could easily see where it was located when entering data. This should be some easy, basic.

Answer 5

Thanks Mike and Rick. RowLiner seems to be the answer. I'll look at the code option on a braver day:)

Adam