Here's an add-in from Chip Pearson which does what you are asking:

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

Hope this helps.

Pete

dinesh wrote:
When we move around in cell cotaining huge table, we tend to lose row &
coloumn (even they are highlighted) as we need to look other data say couple
of columns away but in the same row. so i suggest a add on or a feature where
when we move around sheet using arrow keys entire row & coloumns of that cell
should be highlighted or filled iin some colour.