Is there a way for excel to highlite the entire row and colum that the cursor
is in? I know that for example when my cursor is in box T 12 (coulm T and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it is
still hard to see across the entire row. I was wondering if there is a way
excel can highlite the entire row and colum so that i can see easily what is
in the row and colum?

Chip Pearson has an add-in that will do that for you he

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

Hope this helps.

Pete

On Aug 14, 3:22 pm, Bentley26
wrote:
Is there a way for excel to highlite the entire row and colum that the cursor
is in? I know that for example when my cursor is in box T 12 (coulm T and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it is
still hard to see across the entire row. I was wondering if there is a way
excel can highlite the entire row and colum so that i can see easily what is
in the row and colum?

Download Chip Pearson's RowLiner add-in to gain this functionality.

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

Easily customizable for colors and line weights.


Gord Dibben MS Excel MVP

On Tue, 14 Aug 2007 07:22:01 -0700, Bentley26
wrote:

Is there a way for excel to highlite the entire row and colum that the cursor
is in? I know that for example when my cursor is in box T 12 (coulm T and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it is
still hard to see across the entire row. I was wondering if there is a way
excel can highlite the entire row and colum so that i can see easily what is
in the row and colum?

Thanks for the add in. It is a cool tool, however it does not allow the undu
button to work. unfortunaly i need the undue button to work so this doesnt
seem to be an option for me. but thank you anyway.

"Gord Dibben" wrote:

Download Chip Pearson's RowLiner add-in to gain this functionality.

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

Easily customizable for colors and line weights.


Gord Dibben MS Excel MVP

On Tue, 14 Aug 2007 07:22:01 -0700, Bentley26
wrote:

Is there a way for excel to highlite the entire row and colum that the cursor
is in? I know that for example when my cursor is in box T 12 (coulm T and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it is
still hard to see across the entire row. I was wondering if there is a way
excel can highlite the entire row and colum so that i can see easily what is
in the row and colum?

In case you are happy with only entire rows highlighted, you may download
"workbook navigation" addins from below site.

http://in.geocities.com/shahshaileshs/

This addins allows the undo and possible to select different areas (range)
with mouse but then it will not highlight entire row.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Office Menu-2003 for Office-2007)
If You Can't Excel with Talent, Triumph with Effort.




"Bentley26" wrote in message
...
Thanks for the add in. It is a cool tool, however it does not allow the
undu
button to work. unfortunaly i need the undue button to work so this
doesnt
seem to be an option for me. but thank you anyway.

"Gord Dibben" wrote:

Download Chip Pearson's RowLiner add-in to gain this functionality.

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

Easily customizable for colors and line weights.


Gord Dibben MS Excel MVP

On Tue, 14 Aug 2007 07:22:01 -0700, Bentley26
wrote:

Is there a way for excel to highlite the entire row and colum that the
cursor
is in? I know that for example when my cursor is in box T 12 (coulm T
and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it
is
still hard to see across the entire row. I was wondering if there is a
way
excel can highlite the entire row and colum so that i can see easily
what is
in the row and colum?

Put the following macro in Worksheet code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.EntireRow.Interior.ColorIndex = 6
Target.EntireColumn.Interior.ColorIndex = 6
End Sub

--
Gary''s Student - gsnu200737


"Bentley26" wrote:

Is there a way for excel to highlite the entire row and colum that the cursor
is in? I know that for example when my cursor is in box T 12 (coulm T and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it is
still hard to see across the entire row. I was wondering if there is a way
excel can highlite the entire row and colum so that i can see easily what is
in the row and colum?

i am not familair with what 'worksheet code' means?

"Gary''s Student" wrote:

Put the following macro in Worksheet code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.EntireRow.Interior.ColorIndex = 6
Target.EntireColumn.Interior.ColorIndex = 6
End Sub

--
Gary''s Student - gsnu200737


"Bentley26" wrote:

Is there a way for excel to highlite the entire row and colum that the cursor
is in? I know that for example when my cursor is in box T 12 (coulm T and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it is
still hard to see across the entire row. I was wondering if there is a way
excel can highlite the entire row and colum so that i can see easily what is
in the row and colum?

Right-click on the sheet tab and "View Code"

Copy/paste to that sheet module.

NOTE: this code will wipe out any background colors you may have currently in
use.

Will also make the UNDO stack unavailable.


Gord

On Tue, 14 Aug 2007 08:48:03 -0700, Bentley26
wrote:

i am not familair with what 'worksheet code' means?

"Gary''s Student" wrote:

Put the following macro in Worksheet code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
Target.EntireRow.Interior.ColorIndex = 6
Target.EntireColumn.Interior.ColorIndex = 6
End Sub

--
Gary''s Student - gsnu200737


"Bentley26" wrote:

Is there a way for excel to highlite the entire row and colum that the cursor
is in? I know that for example when my cursor is in box T 12 (coulm T and
Row 12) that the T is highlited and the 12 is higlited, but sometimes it is
still hard to see across the entire row. I was wondering if there is a way
excel can highlite the entire row and colum so that i can see easily what is
in the row and colum?