Trident_muh
Eternal Poster
In wps spreadsheet is it possible to only freeze Column N1:N5000 to Y1:Y5000?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Help WPS Freeze
- Thread starter Trident_muh
- Start date
Solution
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...
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...
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.
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.
Similar threads
Popular Tags
About this Thread
-
2Replies
-
145Views
-
2Participants
Last reply from:
Trident_muh
Trident_muh
Online statistics
- Members online
- 1,001
- Guests online
- 5,107
- Total visitors
- 6,108