Selected Cell Change Outline

%3CLINGO-SUB%20id%3D%22lingo-sub-3029122%22%20slang%3D%22en-US%22%3ESelected%20Cell%20Change%20Outline%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3029122%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%26nbsp%3BHow%20do%20I%20make%20the%20outline%20darker%2Fthicker%20of%20a%20cell%20I've%20selected%3F%26nbsp%3BIn%20other%20words%2C%20I%20reduced%20my%20spreadsheet%20view%20to%2060%25%20so%20that%20I%20can%20see%20all%20of%20my%20columns%2C%20but%20then%20I%20cannot%20always%20see%20which%20cell%20I'm%20in.%26nbsp%3B%20How%20can%20I%20make%20the%20current%20'selected'%20cell%20outline%20darker%20so%20that%20I%20can%20see%20where%20I%20am%20in%20the%20row%3FThanks%20for%20your%20help.%26nbsp%3B-Rebecca%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3029122%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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