Dec 02 2021 12:36 PM
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
Dec 05 2021 04:20 AM
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