×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Scroll Highlighting

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

Scrolling does not move the cursor???

TTFN



RE: Scroll Highlighting

(OP)
What I mean is that wherever the cursor is, to highlight the whole row.  If the cursor is moved down one cell I want the whole row to highlight.

RE: Scroll Highlighting

I understand and it sounds like a good idea to me!

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

(OP)
Sounds like something logical to me.  I'm going blind looking at these sheets trying to focus on lines in worksheets.  Anybody know a Microsoft Software Engineer out there?

RE: Scroll Highlighting

Maybe I can help with the going blind part. I often will hit the "shift" key + space bar. This 1/4 second command "selects" the entire row of the worksheet. The selection highlighting helps direct my eyes' attention to the correct spot as I toggle back and forth to other running applications, answer the phone, papers on desk, etc. This has gotten more important with my aging eyes.

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

Try this from http://www.cpearson.com/excel/excelM.htm#HighlightActiveCell

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

Try this macro:

  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

Hi jelenko:

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

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    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

Are they looking to have the row highlight just when the mouse hovers over it, without actually *selecting* the cell?

Hg

Eng-Tips policies:  FAQ731-376

RE: Scroll Highlighting

(OP)
clyde38.  Thanks but I need the whole row highlighted.

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

jelenko,
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

(OP)
Clyde38:

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

Jelenko, FWIW, you should be able to edit the cell contents in the sample macro by pressing the F2 function key to activate the cell for editing.

RE: Scroll Highlighting

Hi jelenko:

Quote:


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.
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

Yogi, That is pretty slick too! That could also be incorporated into a macro so that the manual part (steps 1, 2, and 3 of your original post) didn't need to be performed.

RE: Scroll Highlighting

Hi Tom:

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources