Chip Pearson has an add-in to do this for you - here's the link:
http://www.cpearson.com/excel/RowLiner.htm
Hope this helps.
Pete
> Excel should have a feature to high-light the row and column when a cell is
> selected for data entry users and when manually searching spreadsheet.
[quoted text clipped - 7 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=5be0273f-fc80-4
049-a3fe-f03340ab765b&dg=microsoft.public.excel.setup