 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / August 2007Highlite 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? Chip Pearson has an add-in that will do that for you here: http://www.cpearson.com/excel/RowLiner.htm Hope this helps. Pete On Aug 14, 3:22 pm, Bentley26 <Bentle...@discussions.microsoft.com> 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 >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. > Download Chip Pearson's RowLiner add-in to gain this functionality. > [quoted text clipped - 10 lines] > >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. > Thanks for the add in. It is a cool tool, however it does not allow the > undu [quoted text clipped - 21 lines] >> >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  SignatureGary''s Student - gsnu200737 > 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? > Put the following macro in Worksheet code: > [quoted text clipped - 10 lines] > > 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 >i am not familair with what 'worksheet code' means? > [quoted text clipped - 12 lines] >> > excel can highlite the entire row and colum so that i can see easily what is >> > in the row and colum? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.