Selected Cell Change Outline

Copper Contributor

Hello Everyone, How do I make the outline darker/thicker of a cell I've selected? In other words, I reduced my spreadsheet view to 60% so that I can see all of my columns, but then I cannot always see which cell I'm in.  How can I make the current 'selected' cell outline darker so that I can see where I am in the row?Thanks for your help. -Rebecca

1 Reply

@Rebecca_Mellinger 

I would suggest you using VBA to highlight where you are.

Find attachment

Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
    Static rr
    Static cc

    If cc <> "" Then
        With Columns(cc).Interior
            .ColorIndex = xlNone
        End With
        With Rows(rr).Interior
            .ColorIndex = xlNone
        End With
    End If

    rr = Selection.Row
    cc = Selection.Column

    With Columns(cc).Interior
        .ColorIndex = 20
        .Pattern = xlSolid
    End With
    With Rows(rr).Interior
        .ColorIndex = 20
        .Pattern = xlSolid
    End With
End Sub