![]() ![]() ![]() jW Actually, in the latest version of Excel 2016 for Windows and for Mac, Excel will not show the row and column identifier of the selected cell in that way. Select the row number to select the entire row. The best thing is that automatic banding will continue as you sort, delete or add new rows to your table. 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: 1. Hi Robert-316, Thank you for posting in this community. To quickly highlight the current row, the current column or the entire spreadsheet use the following keyboard shortcuts: "Shift" + "Space": Highlights the current row. You can select the files and folder just by clicking them. Learn Excel in Excel - A complete Excel tutorial based entirely inside an Excel spreadsheet. The screenshot which shows the row and column identifier in yellow-orange is Excel 2007 for Windows. Click on the (More) button, and then the (Format) button. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |