A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Highlighting rows?



 
 
Thread Tools Display Modes
  #1  
Old November 11th, 2005, 06:59 PM
Linn Kubler
external usenet poster
 
Posts: n/a
Default 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  
Old November 11th, 2005, 09:12 PM
Linn Kubler
external usenet poster
 
Posts: n/a
Default 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  
Old November 12th, 2005, 12:09 AM
Paul B
external usenet poster
 
Posts: n/a
Default 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  
Old November 12th, 2005, 12:14 AM
Dave Peterson
external usenet poster
 
Posts: n/a
Default 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  
Old November 12th, 2005, 05:55 PM
Linn Kubler
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 02:53 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.