Controller Posted April 5, 2007 Share Posted April 5, 2007 A co-worker asked me if there is a way in Excel to highlight the current row in a spreadsheet no matter where you move the cursor. He is working a large sheet and constantly has to double-check to make sure he is in the right row. I found this link that seems to offer a solution, but I'm embarassed to say I don't know how to implement it. Anyone able to help me with the above, or better yet have a solution that is easier than this? Quote Link to comment Share on other sites More sharing options...
Grits and Shins Posted April 5, 2007 Share Posted April 5, 2007 Not sure how to implement it ... but it is worth noting that if he is working with a large spreadsheet that the conditional formatting will add overhead and slow things down. The bigger the spread sheet the slower. In this case every time he moves the cursor conditional formatting will be deleted for the entire worksheet and readded for the entire worksheet. Sounds like you could be waiting alot. Quote Link to comment Share on other sites More sharing options...
Coffeeman Posted April 5, 2007 Share Posted April 5, 2007 (edited) I'd say its a clumsy solution. Can't your buddy just look up in the left corner (just above Row 1 and left of Col. A) and read what it says for the current cell? That stays true no matter where the cursor is. 'Reading is fundamental....' edit: Also, if you have 2003 or later, the column and row markers are highlighted, just not the whole row Edited April 5, 2007 by Coffeeman Quote Link to comment Share on other sites More sharing options...
Sam Posted April 5, 2007 Share Posted April 5, 2007 You just go to Tools - Macro - Visual Basic Editor and paste that code into the Worksheet page. I just tested it and it works. Let me know if you need any help. Quote Link to comment Share on other sites More sharing options...
Big Country Posted April 5, 2007 Share Posted April 5, 2007 Could he not just freeze the panes so he can always see the row and column headers? Quote Link to comment Share on other sites More sharing options...
Controller Posted April 5, 2007 Author Share Posted April 5, 2007 You just go to Tools - Macro - Visual Basic Editor and paste that code into the Worksheet page. I just tested it and it works. Let me know if you need any help. After I paste it into the VB editor worksheet page there must be a step I'm missing, because nothing happens. Do I need to do anything after pasting the code? Quote Link to comment Share on other sites More sharing options...
Controller Posted April 5, 2007 Author Share Posted April 5, 2007 Not sure how to implement it ... but it is worth noting that if he is working with a large spreadsheet that the conditional formatting will add overhead and slow things down. The bigger the spread sheet the slower. In this case every time he moves the cursor conditional formatting will be deleted for the entire worksheet and readded for the entire worksheet. Sounds like you could be waiting alot. There is a tradeoff, but in this case he's willing to wait if it helps him avoid mistakes. Quote Link to comment Share on other sites More sharing options...
Controller Posted April 5, 2007 Author Share Posted April 5, 2007 I'd say its a clumsy solution. Can't your buddy just look up in the left corner (just above Row 1 and left of Col. A) and read what it says for the current cell? That stays true no matter where the cursor is. 'Reading is fundamental....' edit: Also, if you have 2003 or later, the column and row markers are highlighted, just not the whole row Neh neh neh - he wants what he wants, and he wants it NOW. Having the column and row markers highlighted is NOT GOOD ENOUGH, dammit. Quote Link to comment Share on other sites More sharing options...
Controller Posted April 5, 2007 Author Share Posted April 5, 2007 Could he not just freeze the panes so he can always see the row and column headers? Basically, that's what he's been doing, but moving the "freeze" point all the time apparently is too much of a pain in the ass. Quote Link to comment Share on other sites More sharing options...
Sam Posted April 5, 2007 Share Posted April 5, 2007 After I paste it into the VB editor worksheet page there must be a step I'm missing, because nothing happens. Do I need to do anything after pasting the code? Are you pasting it into the correct worksheet? All I did was copy and paste and it worked fine for me. Quote Link to comment Share on other sites More sharing options...
Gonkis Posted April 5, 2007 Share Posted April 5, 2007 Buy him a 50 inch monitor. Quote Link to comment Share on other sites More sharing options...
Controller Posted April 5, 2007 Author Share Posted April 5, 2007 Hey Sam, thanks - I figured it out and it works perfectly. Grits - it does not slow him down at all, at least with this particular file. Quote Link to comment Share on other sites More sharing options...
The Irish Doggy Posted April 5, 2007 Share Posted April 5, 2007 Buy him a 50 inch monitor. +1 and me too while you're at it. Quote Link to comment Share on other sites More sharing options...
Grits and Shins Posted April 5, 2007 Share Posted April 5, 2007 Hey Sam, thanks - I figured it out and it works perfectly. Grits - it does not slow him down at all, at least with this particular file. Yeah it would have to be a big and/or complex spreadsheet ... like the one Rhino sends out every year. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.