The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
#ONE CLICK CODE TRIAL#
If you want to have a free trial ( 30-day) of this utility, please click to download it, and then go to apply the operation according above steps. This Reading Layout View feature will disabled when you launch the workbook next time. This Reading Layout View feature is applied to all of the worksheets within your workbook. You can cancel this utility by unchecking the Reading Layout under Reading drop down list. You can change the reading layout settings based on your needs as below screenshot shown. Then the reading layout is enabled, you can see the row and column of active cell are highlighted immediately. And it will be dynamically moved as the selected cells change.
#ONE CLICK CODE HOW TO#
Let's see how to apply the Kutools for Excel’s Reading Layout feature to highlight entire rows and columns of a range of cells.ġ. Download and try it now! ( 30-day free trail) This utility helps to easily highlight row and column of selected cell in Excel as the below demo shown. If you are a newbie of VBA, here recommend the Kutools for Excel's Reading Layout utility. If there are some colored cells in your worksheet, the color will be lost when you click the cell and then move to other cell.Īuto-highlight row and column of selected cell with Kutools for Excel If you do not want to highlight the column and row of the selected cell again, you need to delete the above VBA and set no fill to the selected row and column by clicking Home > Fill color > No fill.
#ONE CLICK CODE CODE#
This VBA code only apply to the worksheet you choose in the above step 2. ColorIndex = 6 color to other color you like. And it will be dynamically moved as the selected cell changes. Then press the Alt + Q keys together to return to the worksheet, now when you select a cell, the entire row and column of this cell has been highlighted. Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)ģ. VBA code: auto-highlight row and column of selected cell Then copy and paste following VBA code into the blank code window: Open the worksheet you will auto-highlight the row and column of active cell, right click the sheet tab and select View Code from the context menu.Ģ. The following VBA code can help you automatically highlight the entire column and row of the current cell in worksheet, please do with following steps:ġ. One click to highlight row and column of selected cell Here, I can introduce you some interesting tricks to highlight the row and column of the current cell, when the cell is changed, the column and row of the new cell are highlighted automatically as following screenshots:Īuto-highlight row and column of selected cell with VBA code When you view a large worksheet with numerous data, you may want to highlight the selected cell’ row and column so that you can easily and intuitively read the data to avoid misreading them. How to auto-highlight row and column of active cell in Excel?