Thread: Highlighted row number

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

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 |:>)

"I_am_a_MS_user" wrote:

> 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
>

I_am_a_MS_user wrote:
> 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

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?

"I_am_a_MS_user" wrote:

> 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
>

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

"CyberTaz" wrote:

> 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 |:>)
>
> "I_am_a_MS_user" wrote:
>
> > 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
> >

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

/lac/

On Mon, 10 Oct 2005 12:45:11 -0700, "I_am_a_MS_user"
<IamaMSuser@discussions.microsoft.com> wrote:

>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