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

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

Share Button
Posted in Tom's Tutorials for Excel
Tags: ,
2 comments on “Tom’s Tutorials For Excel: Using the Home key with Scroll Lock
  1. Rajesh Sinha says:

    Tom, I’ve an issue.

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

    • Tom Urtis says:

      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

Leave a Reply to Rajesh Sinha Cancel reply

Your email address will not be published.

*