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
|
|||
|
|||
Highlighting rows?
Hi,
Using Excel 2003 here and when I navigate a spreadsheet using the arrow keys, or the mouse for that matter, I'd like to highlight the entire row. I think this would make it much easier to visually scan the row and read the data. Is there a way to do this? I thought there was a check box in the options I could turn on but that must have been another version of Excel. Thanks in advance, Linn |
#2
|
|||
|
|||
Highlighting rows?
This looked promising Paul but it doesn't work with Excel 2003. The
instructions say it supports up to 2002. Excel crashes when I try to enable it. Wonder how I can remove it from my Add-ins list. Thanks, Linn "Paul B" wrote in message ... Linn, have a look at Chip's row liner addin at http://www.cpearson.com/excel/rowliner.htm and see it will do what you want -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Linn Kubler" wrote in message ... Hi, Using Excel 2003 here and when I navigate a spreadsheet using the arrow keys, or the mouse for that matter, I'd like to highlight the entire row. I think this would make it much easier to visually scan the row and read the data. Is there a way to do this? I thought there was a check box in the options I could turn on but that must have been another version of Excel. Thanks in advance, Linn |
#3
|
|||
|
|||
Highlighting rows?
Linn, sorry, I was not aware that it would not work in 2003, I am not at a
machine with 2003 installed at this time to test delete the addin and then start excel then tools addins and click in row liner, excel should tell you that it can't find it and ask if you want to delete it in the list. You might also want to have a look here http://www.mcgimpsey.com/excel/highl...iteRetainColor -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Linn Kubler" wrote in message ... This looked promising Paul but it doesn't work with Excel 2003. The instructions say it supports up to 2002. Excel crashes when I try to enable it. Wonder how I can remove it from my Add-ins list. Thanks, Linn "Paul B" wrote in message ... Linn, have a look at Chip's row liner addin at http://www.cpearson.com/excel/rowliner.htm and see it will do what you want -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Linn Kubler" wrote in message ... Hi, Using Excel 2003 here and when I navigate a spreadsheet using the arrow keys, or the mouse for that matter, I'd like to highlight the entire row. I think this would make it much easier to visually scan the row and read the data. Is there a way to do this? I thought there was a check box in the options I could turn on but that must have been another version of Excel. Thanks in advance, Linn |
#4
|
|||
|
|||
Highlighting rows?
It worked ok for me when I tried in xl2003.
I would suspect that it was written before xl2003 was available and Chip just hasn't updated the web page. (I don't have a guess why xl2003 crashed on you, though.) Linn Kubler wrote: This looked promising Paul but it doesn't work with Excel 2003. The instructions say it supports up to 2002. Excel crashes when I try to enable it. Wonder how I can remove it from my Add-ins list. Thanks, Linn "Paul B" wrote in message ... Linn, have a look at Chip's row liner addin at http://www.cpearson.com/excel/rowliner.htm and see it will do what you want -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Linn Kubler" wrote in message ... Hi, Using Excel 2003 here and when I navigate a spreadsheet using the arrow keys, or the mouse for that matter, I'd like to highlight the entire row. I think this would make it much easier to visually scan the row and read the data. Is there a way to do this? I thought there was a check box in the options I could turn on but that must have been another version of Excel. Thanks in advance, Linn -- Dave Peterson |
#5
|
|||
|
|||
Highlighting rows?
Ah yes, I like that example much better. I like having access to the actual
code so I can modify it if I want to. I still can't get the addin to delete. I googled it and found a couple descripitons on how to remove it, very much like you suggested, but nothing works. When I delete it and start Excel, select Tools|Addins and click the rowliner and select OK it crashes Excel. When Excel restarts it tells me that it had a problem with the rowliner addin and asks if I want to disable it. No option for deleting. Disabling leaves it in the addin list. Very annoying. If anyone has any other ideas on how to remove an addin I'd love to hear them. Thanks again Paul, Linn "Paul B" wrote in message ... Linn, sorry, I was not aware that it would not work in 2003, I am not at a machine with 2003 installed at this time to test delete the addin and then start excel then tools addins and click in row liner, excel should tell you that it can't find it and ask if you want to delete it in the list. You might also want to have a look here http://www.mcgimpsey.com/excel/highl...iteRetainColor -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Linn Kubler" wrote in message ... This looked promising Paul but it doesn't work with Excel 2003. The instructions say it supports up to 2002. Excel crashes when I try to enable it. Wonder how I can remove it from my Add-ins list. Thanks, Linn "Paul B" wrote in message ... Linn, have a look at Chip's row liner addin at http://www.cpearson.com/excel/rowliner.htm and see it will do what you want -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Linn Kubler" wrote in message ... Hi, Using Excel 2003 here and when I navigate a spreadsheet using the arrow keys, or the mouse for that matter, I'd like to highlight the entire row. I think this would make it much easier to visually scan the row and read the data. Is there a way to do this? I thought there was a check box in the options I could turn on but that must have been another version of Excel. Thanks in advance, Linn |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Insert rows | Mr. G. | Worksheet Functions | 3 | March 31st, 2005 03:49 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Repeat Records - Please Help? | Repeat records | Running & Setting Up Queries | 9 | September 29th, 2004 05:29 PM |
Conditional Hiding of Rows or Columns | sanjay_suda | General Discussion | 6 | June 18th, 2004 04:03 PM |
Excel- Inserting a varying number of rows | Ken Wright | Worksheet Functions | 1 | March 20th, 2004 10:20 PM |