Tom’s Tutorials For Excel: Using the Home key with Scroll Lock

by Tom Urtis 2 Comments ↓

Tom’s Tutorials For Excel: Using the Home key with Scroll Lock
Here are a few navigation tips using the Home key, with or without the Ctrl key, with or without Scroll Lock activated, and with Freeze Panes on or off.

‹ Tom’s Tutorials For Excel: Calculating Negative Time Differences in Hundredths of a Second

Tom’s Tutorials For Excel: Finding Matches Among Horizontal and Vertical Ranges ›

Posted in Tom's Tutorials for Excel
Tags: Keyboard Mouse, Tips and Tricks

2 comments on “Tom’s Tutorials For Excel: Using the Home key with Scroll Lock”

1. Rajesh Sinha says:

   December 6, 2017 at 6:55 am

   Tom, I’ve an issue.

   If I select Row 1, row 20 should highlight, if select 20 row 40 highlight & 20 should be normal.

   Reply
   • Tom Urtis says:

     December 6, 2017 at 10:12 am

     This in your worksheet module will do what you say you want:
     
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = -4142
Rows(Target.Row + 20).Interior.Color = vbCyan
End Sub

     Reply