Scroll Highlighting
Scroll Highlighting
(OP)
Does anyone know how to get excel to automatically highlight the row where the cursor is while you're scrolling? This woul help in focusing your attention on the information in that row while you are scrolling through a spreadsheet.





RE: Scroll Highlighting
TTFN
RE: Scroll Highlighting
RE: Scroll Highlighting
Older versions of Excel (Excel 3 and 4, and maybe 5) had something like this feature when in "data entry mode". I haven't seen this feature in later versions of Excel, but maybe it's hiding someplace.
RE: Scroll Highlighting
RE: Scroll Highlighting
Of course, each time the active cell changes the operation has to be repeated. hmmm, maybe this could be worked into a macro: "on key", then select the row.
RE: Scroll Highlighting
Highlighting The Active Cell
If you want to make the active cell appear in a special color, use the following code in the Workbook_SheetSelectionChange event of the workbook.
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object,
ByVal Target As Excel.Range)
Static OldRange As Range
On Error Resume Next
Target.Interior.ColorIndex = 6 ' yellow - change as needed
OldRange.Interior.ColorIndex = xlColorIndexNone
Set OldRange = Target
End Sub
This will change the background color of the ActiveCell to yellow anytime you select a new cell, either with the mouse or with the arrow keys.
RE: Scroll Highlighting
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Rows(ActiveCell.ROW).Select
End Sub
As the cell selection changes, its entire row is selected (gets the selection highlight).
I'm sure this can be customized so you can turn it on and off "at will".
RE: Scroll Highlighting
Here is one way using Conditional Formatting.
1) select all the rows
2) then invoke FORMAT|Conditional Formatting, and use ...
3) formula is ... =cell("row")=row()
this would highlite the row when you make or delete an entry; to automate highliting the row simply on selection, additionally use the following code ...
CODE
Application.ScreenUpdating = True
End Sub
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
RE: Scroll Highlighting
Hg
Eng-Tips policies: FAQ731-376
RE: Scroll Highlighting
TomBarsh. I tried this earlier but we were not able to change the cell contents that we were in.
Yogia. I need this to be active only on the current cell and on the whole row. Once moved to a different cell the previous cell and row should go back to normal.
HgTX. I only want the row where the cursor is and to move along with the cursor. I need to still be able to modify the contents of the cell that I am in.
RE: Scroll Highlighting
Take a look at the link that I sent. Look at the RowLiner add in. This will accomplish what you want, even though the whole row is not highlighted. It actually will indicate the row and or column.
RE: Scroll Highlighting
I did go to the link. This looks exactly what I was looking for.
I will try it out tomorrow.
Many thanks to you,
Jelenko
RE: Scroll Highlighting
RE: Scroll Highlighting
Have you actually tried the approach I suggested -- it does exactly what you have stated.
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com
RE: Scroll Highlighting
RE: Scroll Highlighting
You are right -- but here is my reasoning ...
I have included the Conditional Formatting part because that alone will work on going to a new cell and on either making an entry, deleting a key, pressing F9 (meaning something to trigger screen update).
To fully automate so it will work passively simply on selecting a cell in another row, I included the Worksheet selection change event code.
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC
http://www.energyefficientbuild.com