Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and medical aesthetics - How to select the whole row and column of a cell in EXCEL?
How to select the whole row and column of a cell in EXCEL?
1. When you click on a cell in this Excel table, the whole row and column can be highlighted.

2. Click the View option in the toolbar above the Excel table.

3. Click the triangle down arrow of Reading Mode under View.

4. After clicking the down arrow in reading mode, many colors will pop up, and then select the color you want to highlight.

5. After choosing the color, we can click on any cell in the Excel table. At this time, we can see that the rows and columns of the cell are displayed, which will make it much more convenient for us to look at the data.