Quickly locate the name of the row and column where the cell is located

Uploaded time: 2021-08-26 Difficulty: Primary

Quickly locate the name of the row and column where the cell is located

Quickly locate the name of the row and column where the cell is located

Graphic skills

We often deal with tables with vast amounts of data at work.

 

When we move the page, we can locate the content we are focusing on, but we cannot quickly know the row and column names of the cells. But now, with the Reading Layout of WPS Spreadsheet, users can quickly locate the row and column names of the cells that they are concerned about.

 

Take this table as an example. Click the View tab, and then the Reading Layout drop-down button. In this mode, once a cell is selected, we can find all the data in the same row and columns with this cell are highlighted by the shading. Then when we select the WPS cell, we can quickly know where the WPS cell is located according to the row and column colors. In this case, the cell is located in row 38, column F. Also we can learn that this data is in database 5, February 6, 2020. 1.gif


You can also change the shading by clicking the inverted triangle next to the Reading Mode drop-down button according to different work scenarios and personal usage habits.

2.gif 

It will be really convenient for users to check the data location after learning this skill! To be office word advancers, you could learn how to use WPS Office Writer online in WPS Academy.