Highlighted row number

[I_am_a_MS_user]

How do I make it so that the entire row that I'm working on is highlighted
(not just the row number) ?

I'm looking back and forth from a worksheet to my screen and I'm trying to
make it so I don't have to search for my place when I look back up?

Thanks

 

[CyberTaz]

If you simply want to be able to spot the row, click the Row Heading number.
You can move the active cell along the row by pressing Enter or Tab.

HTH |:>)

 

[gls858]

How do I make it so that the entire row that I'm working on is highlighted
(not just the row number) ?

I'm looking back and forth from a worksheet to my screen and I'm trying to
make it so I don't have to search for my place when I look back up?

Thanks

Click in the row number.

gls858

 

[I_am_a_MS_user]

Is there a way to have this effect automatically as I press enter to move to
the next row?

 

[Alvin]

are you familiar with VBA?
a simple VBA code can do that.
what does "highlight" means to you?
1 a simple highlight when you select a range?
2 give a background color to the entire row?

 

[Guest]

http://www.xcelfiles.com/Excel02.html#anchor_54
is probably what you're looking for...

/lac/