highlight row and coloumn of selected cell

[Guest]

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.

 

[Pete_UK]

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

 

[Otto Moehrbach]

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

 

[Guest]

thanks a lot thats what i was looking for

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

 

[Pete_UK]

Thanks for feeding back.

Pete

thanks a lot thats what i was looking for

 

[Guest]

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...

 

[Pete_UK]

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