Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row
is there a keyborad shortcut to highlight the active row you are on?
Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row
James wrote:
is there a keyborad shortcut to highlight the active row you are on? Thanks Shift+Space Hans |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row
Shift spacebar will select the rows in the area with the activecell.
You may want to try Chip Pearson's Rowliner: http://www.cpearson.com/excel/RowLiner.htm James wrote: is there a keyborad shortcut to highlight the active row you are on? Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row
I knew of the shift + space bar, but I wanted to know if there was way to
change the color of the cell, and row (i.e. yellow or green) by some key combination. James "Hans Knudsen" wrote: James wrote: is there a keyborad shortcut to highlight the active row you are on? Thanks Shift+Space Hans |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row
Not quite what I was looking for but I have seen this add in, it is very cool
but it does make the undo option unavailable. The shift + spacebar I already knew, but I was looking for a shortcut to change the color of the cell and row (i.e. yellow or green). I just don't like to use the mouse to much. Thanks, James "Dave Peterson" wrote: Shift spacebar will select the rows in the area with the activecell. You may want to try Chip Pearson's Rowliner: http://www.cpearson.com/excel/RowLiner.htm James wrote: is there a keyborad shortcut to highlight the active row you are on? Thanks -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row
You may be able to mess around with an event macro, but those will usually
destroy the undo stack, too. James wrote: Not quite what I was looking for but I have seen this add in, it is very cool but it does make the undo option unavailable. The shift + spacebar I already knew, but I was looking for a shortcut to change the color of the cell and row (i.e. yellow or green). I just don't like to use the mouse to much. Thanks, James "Dave Peterson" wrote: Shift spacebar will select the rows in the area with the activecell. You may want to try Chip Pearson's Rowliner: http://www.cpearson.com/excel/RowLiner.htm James wrote: is there a keyborad shortcut to highlight the active row you are on? Thanks -- Dave Peterson -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row
James,
I use the following macro to highlight the current selection. It cycles between 4 highlight colors as well as no highlight. You can easily change the colorindex values to suit your preferences, but unfortunately the macro does clear the Undo stack. I have the macro bound to the Ctrl^Shift^H key combination so I can easliy select a highlight color by repeatedly pressing this combination. To highlight the entire row you could press Shift^Space then Ctrl^Shift^H, or you could modify the code to use the expression "With Selection.EntireRow.Interior" instead of "With Selection.Interior" Hope that helps, TK Code follows: Sub Highlight() Dim color As Variant With Selection.Interior Select Case .ColorIndex Case xlNone .ColorIndex = 6 Case 6 .ColorIndex = 3 Case 3 .ColorIndex = 5 Case 5 .ColorIndex = 37 Case Else .ColorIndex = xlNone End Select End With End Sub "James" wrote: is there a keyborad shortcut to highlight the active row you are on? Thanks |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight a row
Works Great, I love it. This will work great as i go through a worksheet and
just new to highlight rows at random. Thanks. "T Kirtley" wrote: James, I use the following macro to highlight the current selection. It cycles between 4 highlight colors as well as no highlight. You can easily change the colorindex values to suit your preferences, but unfortunately the macro does clear the Undo stack. I have the macro bound to the Ctrl^Shift^H key combination so I can easliy select a highlight color by repeatedly pressing this combination. To highlight the entire row you could press Shift^Space then Ctrl^Shift^H, or you could modify the code to use the expression "With Selection.EntireRow.Interior" instead of "With Selection.Interior" Hope that helps, TK Code follows: Sub Highlight() Dim color As Variant With Selection.Interior Select Case .ColorIndex Case xlNone .ColorIndex = 6 Case 6 .ColorIndex = 3 Case 3 .ColorIndex = 5 Case 5 .ColorIndex = 37 Case Else .ColorIndex = xlNone End Select End With End Sub "James" wrote: is there a keyborad shortcut to highlight the active row you are on? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If #, then Highlight | Excel Worksheet Functions | |||
Highlight | Excel Discussion (Misc queries) | |||
Highlight | Excel Worksheet Functions | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Highlight Row | Excel Worksheet Functions |