How to freeze multiple rows and columns in wps excel table How to freeze multiple rows and columns in excel table

If we have a large number of rows and columns in our worksheet, we have to flip the page down or right to see the rows and columns that are currently invisible. In order to facilitate reading, you can set the top two rows and the leftmost two columns to be fixed no matter where you flip the worksheet. How to set it up? The editor will introduce the method below. 1. Select cell C3 (cell C3 is exactly one row below row 2 and one column to the right of row B, so this cell is selected) and click the Freeze Panes button in the View tab.

2. Select Freeze to Row 2 and Column B in the pop-up drop-down menu.

3. Next, if we flip the page down in the worksheet, the top two rows will always be fixed; if we flip the page to the right, the two leftmost columns will always be fixed, making it very convenient to read the table.

4. Scroll the page downwards, and the top 2 rows will remain fixed.

5. Flip the page to the right, and the two columns on the left are always fixed.

The above is the detailed content of How to freeze multiple rows and columns in wps excel table How to freeze multiple rows and columns in excel table. For more information, please follow other related articles on the PHP Chinese website!