You may want to try Chip Pearson's addin:
http://www.cpearson.com/excel/RowLiner.htm


Tim Magee wrote:

When working on large spreadsheets with many rows on one screen, it is easy
to lose track of exactly where you have been working.

One can highlight a row by clicking on the extreme left column - but that
highlighting dissappears if you click anywhere else.

Is there a way to create a highlight for a row that one can move up and down
with the arrow keys or some other combination of keys -- as your work
position changes.

This would be a handy feature if your are comparing two spread sheets
side-by-side -- or if the telephone rings and you can't remember where you
were on the spread sheet after the call.

Thanks much.

Tim Magee

--

Dave Peterson