Can Excel automatically color highlight entire row of cell I'm in
 

Can Excel automatically color highlight (or with bold lines on top and
bottom) the row that I'm working in? I have a spreadsheet with 219 rows and
about 137 columns. I have friends helping me to enter data for my Master's
project so I really want accuracy to not be a problem. As they use the arrow
buttons to fill in information from column to column in the same record (i.e.
row), I would like it to be plainly obvious which record they're in... more
than just the higlighted row number. Bells and whistles, you know? I can't
find any automatic view of guidelines or "rulers" of this sort so maybe I
need to look in Visual Basic or Macros. ANY IDEAS? Thanks in advance!

Can Excel automatically color highlight entire row of cell I'm in
 

you may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm

Estephanina wrote:

Can Excel automatically color highlight (or with bold lines on top and
bottom) the row that I'm working in? I have a spreadsheet with 219 rows and
about 137 columns. I have friends helping me to enter data for my Master's
project so I really want accuracy to not be a problem. As they use the arrow
buttons to fill in information from column to column in the same record (i.e.
row), I would like it to be plainly obvious which record they're in... more
than just the higlighted row number. Bells and whistles, you know? I can't
find any automatic view of guidelines or "rulers" of this sort so maybe I
need to look in Visual Basic or Macros. ANY IDEAS? Thanks in advance!

--

Dave Peterson

Can Excel automatically color highlight entire row of cell I'm
 

Thanks Dave. The add in works great for my computer with Office XP but I
can't get it to load onto an older computer with Office 2000.

Thanks so much for the help... it'll help my work greatly!
Steph


"Dave Peterson" wrote:


you may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm



Dave Peterson

Can Excel automatically color highlight entire row of cell I'm
 

From the top of Chip's site:
....
For Excel 2000, you must have the SR1 patch installed. Otherwise you may receive
an "Illegal Operation" message.
....

Are you running xl2k sr1?



Estephanina wrote:

Thanks Dave. The add in works great for my computer with Office XP but I
can't get it to load onto an older computer with Office 2000.

Thanks so much for the help... it'll help my work greatly!
Steph

"Dave Peterson" wrote:


you may want to try Chip Pearson's Rowliner:
http://www.cpearson.com/excel/RowLiner.htm



Dave Peterson


--

Dave Peterson