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.

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.

thanks a lot thats what i was looking for

"Pete_UK" wrote:

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.

Thanks for feeding back.

Pete

dinesh wrote:
thanks a lot thats what i was looking for

"Pete_UK" wrote:

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.

Hi,

i am facing a new problem, when i closed the file and reopened, the excel
says it has entcountered problem with the add in and had deactivate it. so
now i m able to use the add in...

Follow the link to Chip's site again - he points out some problems that
can occur with some versions of Excel, so see if these can help you.
Failing that, ask Chip directly via his site.

Hope this helps.

Pete

dinesh wrote:
Hi,

i am facing a new problem, when i closed the file and reopened, the excel
says it has entcountered problem with the add in and had deactivate it. so
now i m able to use the add in...

The following macro will do that. HTH Otto
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

Rows.Interior.ColorIndex = xlNone

Columns.Interior.ColorIndex = xlNone

ActiveCell.EntireColumn.Interior.ColorIndex = 6

ActiveCell.EntireRow.Interior.ColorIndex = 6

End Sub
"dinesh" wrote in message
...
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.