Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Formula for current month minus one = Quarter number in a macro. | Excel Discussion (Misc queries) | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Convert week number into calendar month? | Excel Worksheet Functions |