Shade line while entering data

[Railfan]

Probably a simple, stupid question. As I input data down a column in a wide Excel spreadsheet I would like to have highlighted the line I am working on as a check that I am in the correct place. I know that I can hit 'shift', 'space' for a single line, but is there a way to do it without having to hit those keystrokes each time?

[WNErika]

I found (and tested) this code. It will highlight the row you are in (yellow) as well the column, almost like a cross point.

Here's how to implement it:
Press Alt+F11 to open the VBE.
From the Project Explorer double click on one of the Sheets (i.e. Sheet1).
Paste the code in the window that opens up.
Close the VBE (Alt + Q or press the X in the top-right corner).

Please Login or Register  to view this content.

[abubaniyan]

hi you can use conditional formatting too....