If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Highlite row and colum cursor is in
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? |
#2
|
|||
|
|||
Highlite row and colum cursor is in
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? |
#3
|
|||
|
|||
Highlite row and colum cursor is in
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? |
#4
|
|||
|
|||
Highlite row and colum cursor is in
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? |
#5
|
|||
|
|||
Highlite row and colum cursor is in
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? |
#6
|
|||
|
|||
Highlite row and colum cursor is in
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? |
#7
|
|||
|
|||
Highlite row and colum cursor is in
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? |
#8
|
|||
|
|||
Highlite row and colum cursor is in
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? |
Thread Tools | |
Display Modes | |
|
|