Home » Science & Technology » How to auto highlight row and column of active cell in Excel?

How to auto highlight row and column of active cell in Excel?

Written By ExtendOffice on Thursday, Feb 17, 2022 | 02:49 AM

 
When viewing a large worksheet with numerous data, you may want to highlight the selected cell's row and column so that you can easily and intuitively read the data to avoid misreading them. This video demonstrates a method to help 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.