Excel - keep selection highlighted

Question

I work with two monitors. Often I select a row in Excel and then need to "click" or "move" over to my other monitor. When you originally select a row in Excel it is very easy to see - stays highlighted until you click another cell.  However it also highlights when I move to my other monitor. When I go back to that monitor / Excel and click to make it "active" again it does show again and is still highlighted. Is there a way that to keep the selection highlighted even when you move to another monitor. Would be nice as many times I need to reference that row or selection for input into another program I use and following across the line is much more difficult when the selection doesn't remain highlighted.

Answer 1

Hi Meredith,

Do you mean something like this:

Alt+ F11>click the sheet, then copy in :

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    With Target

        .Parent.Cells.Interior.ColorIndex = xlNone

        .EntireRow.Interior.ColorIndex = 6

        .EntireColumn.Interior.ColorIndex = 6

    End With

End Sub

Actually Excel has't this feature temporary. You Should find some third-part add-in to achieve this. 

Thanks,

Jerry