WPS Mobile version Freeze pane Quick view of Excel content

When you look at a large number of Excel tables, you will often experience columns and rows, and when you slide down or to the right, the header will also move, it is difficult to distinguish between the column data corresponding to the title, using the "Frozen Pane" feature can be a good solution to this problem.

The way to do this is to position the cursor on the next line of the header row that you want to freeze, and it can be the next line on one or more lines. Then select Freeze pane on the toolbar. When scrolling, the frozen header row is always displayed on top, which greatly enhances the visibility of table editing.

First, a MO describes how to freeze horizontal rows or vertical columns. In the following illustration, if you want to freeze the column B of the product, select column C on the right, and then click Freeze Pane. A green line appears on the right side of the frozen column as a marker. The method of freezing rows is as above.

Simply learn how to freeze specific rows and columns at the same time after you freeze a single row or column? Learn from Mo. If you want to freeze both horizontal and vertical headers in the example document above, you need to select the next cell in the row and column where the product is located, "C4" (as shown in the following image), and then click on the "Frozen panes" to see the two green lines crossed, which makes it much easier to view the data in the document.

Computer Tutorials

WPS Mobile version is the Golden Hill Office software launched, running on the Android platform full-featured Office software, support to view, create and edit a variety of commonly used Office documents, user-friendly mobile phones and tablets to meet the needs of users anywhere, the office, so that the user's Office document operations in control.