You can change the highlight color to another you like in this script “ = 8”, change the number 8 to another color index.Ģ.
Then save and close this code, now, when you click a cell, the whole row of this selected cell will be highlighted as following screenshots shown:ġ. VBA code: Highlight whole row when scrolling Private Sub Worksheet_SelectionChange(ByVal Target As Range)ģ.
In the opened Microsoft Visual Basic for Applications window, please copy the following code to this blank module: Active the worksheet that you want to highlight the whole row of the selected cell, and then right click the sheet tab, and choose View Code from the right-click menu, see screenshot:Ģ. The following VBA code can help you to highlight a row of selected cell dynamically, please do as follows:ġ. Highlight whole row / column / row and column when scrolling with Kutools for Excel Highlight whole row when scrolling with VBA code This article, I will talk about some tricks for you to solve this problem. In this case, you can highlight the whole row of active cell so that you can quickly and easily view the data in that row when you scroll down the horizontal scroll bar. If you have a large worksheet with multiple columns, it will be difficult for you to distinguish data on that row.
#Kutools excel highlight row column how to#
How to highlight entire / whole row while scrolling in Excel worksheet?