Darkening the whole row

[Gokhan_ciftcioglu]

Hello everyone,

I have a list made of many columns and rows, and I need to control it. For example; I need to check the cell A100 by looking at K100 cell. I think it is better for me to darken all the cells in the row 100 to make the vision clear. Are there any options in excel to do that because I don't want to use shift + space bar every time.

 

[wideboydixon]

You could possibly use a macro. Right click on the sheet name and select "View Code". Then paste the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Count = 1 Then
    Target.EntireRow.Select
    Target.Activate
End If

End Sub

WBD

 

[Gokhan_ciftcioglu]

You could possibly use a macro. Right click on the sheet name and select "View Code". Then paste the following:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Count = 1 Then
    Target.EntireRow.Select
    Target.Activate
End If

End Sub

WBD

thank you so much. that works very well