ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Highlighted row number (https://www.excelbanter.com/new-users-excel/49677-highlighted-row-number.html)

I_am_a_MS_user

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


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

"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


gls858

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

I_am_a_MS_user

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


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?

"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



All times are GMT +1. The time now is 05:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com