![]() 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. Once done, you don’t need to press F9 to recalculate.How to auto-highlight row and column of active cell in Excel? Next, you need to type the following code to the selected sheet and close the window.Double-click on the sheet where you did this formatting.Then click on Microsoft Excel Objects to expand it.Press Alt and F11 keys at the same time to open Microsoft Visual Basic for Applications window.To make it become easier, you can use Visual Basic to change it. How to make the switch of highlight a column easier? To make the other column you selected be highlighted, you need to press F9 first, and then select the column which needs to be highlighted. But when you select the next column, nothing happens. Once done, you can see a highlighted column. You can set the Number, Font, Border, and Fill according to your preference. Then you will open the Format Cells window. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |