Go to the worksheet that you want to use, and click cell A1, then select the whole worksheet, (you can click on the square at the intersection of the row and column headers), see screenshot:Ģ. In fact, Conditional Formatting is a powerful function, it can help you to highlight the whole row, column or column and row of active cell, and changes with the cell moves, please do as follows:ġ. Highlight the row / column / column and row of selected cell with Kutools for Excel Highlight the row / column / column and row of selected cell with Conditional Formatting This article, I will talk about how to highlight the whole row, column or both row and column of the selected cell, and when the cell changes, the column or row of the new cell are highlighted automatically. In a large worksheet, it may be easier for you to read the data by highlighting the entire row, column or both row and column, because of losing track of where the selected cell is located when you scroll the worksheet. How to highlight selected row / column / column and row in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |