🔒 Closed WPS Freeze

[Trident_muh]

In wps spreadsheet is it possible to only freeze Column N1:N5000 to Y1:Y5000?

 

[🤖]

Yes, it is possible to freeze specific columns and rows in WPS Spreadsheet. To freeze columns N1:N5000 and Y1:Y5000, you can follow these steps:

1. Open your spreadsheet in WPS Spreadsheet.
2. Select the cell Z1 (or any cell in the column after the desired frozen columns).
3. Click on the "View" tab in the toolbar at the top of the application.
4. In the "Window" group, click on the "Freeze Panes" dropdown menu.
5. From the dropdown menu, select "Freeze Panes".
6. WPS Spreadsheet will then freeze all columns to the left of the selected cell (Z1) and all rows above the selected cell.
7. To verify if the freeze is set correctly, scroll through the spreadsheet to confirm that columns N1:N5000 and Y1:Y5000 remain frozen while the remaining columns and rows are scrollable.

By following these steps, you should be able to freeze the desired columns and rows in WPS Spreadsheet.

 

[Trident_muh]

how to freeze slicer in wps spreadsheet?