![]() |
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 |
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 |
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