How to Freeze the Top Row or Left Column in SharePoint Lists Using WPS Office
Question details
A SharePoint user wants to keep the top row or left column visible while scrolling through a list. Modern SharePoint does not have a built-in freeze option, so the user needs a supported workaround.

- Product
- Microsoft SharePoint Lists
- Device & OS
- not provided
- Scenario
- A user needs to lock the header row or first column in place while scrolling through a long SharePoint list.
- Observed behavior
- Modern SharePoint Lists do not provide a standard freeze top row or left column setting, so the header or first column scrolls out of view.
Check that you have permission to view and export the SharePoint list. If you plan to use the WPS Office workaround, make sure WPS Office Spreadsheets is installed and can open Excel files.
Check your SharePoint list view settings for a freeze option
Use this first to confirm that modern SharePoint does not expose a supported freeze-panes setting in list views.
In your SharePoint site, open Lists and select the list where you want to freeze the top row or left column.
Click the view selector or the gear icon in the upper-right corner, then choose List settings and select the current view.
On the View Settings page, look for a Freeze Panes, frozen row, or frozen column option. Modern SharePoint list views do not include this setting.
Export the SharePoint list to Excel and freeze panes in WPS Office Spreadsheets
Use this workaround when you need to scroll through list data with the header row or first column still visible.
Reduce scrolling inside SharePoint by using filtering, sorting, or grouping
Use this if you must stay in SharePoint and only need to keep relevant rows visible rather than physically locking the header.
Use WPS Office Spreadsheets to freeze rows and columns from an exported SharePoint list
SharePoint lists do not offer a native freeze pane option, but WPS Office is a free, lightweight Microsoft Office alternative that handles the same Excel files with familiar tools. Export your SharePoint list, open it in WPS Office Spreadsheets, and freeze the top row or left column without custom SharePoint code.
- 1. Export the SharePoint list to Excel: Open the SharePoint list, click Export > Export to Excel, and save the file.
- 2. Open the file in WPS Office Spreadsheets: Launch WPS Office and open the exported Excel file.
- 3. Freeze the desired rows or columns: Select the cell below and to the right of the area you want to freeze, go to the View tab, click Freeze Panes, and choose Freeze Panes.
- 4. Scroll to verify: Scroll down and right; the frozen top row or left column remains visible.

Frequently Asked Questions
Can I freeze the top row in modern SharePoint lists?
No, modern SharePoint lists do not have a built-in freeze top row or freeze first column setting. You need a workaround such as exporting the list to Excel and opening it in WPS Office Spreadsheets, or using list views to reduce scrolling.
How do I freeze the top row and first column in WPS Office after exporting a SharePoint list?
Open the exported Excel file in WPS Office Spreadsheets, click cell B2, go to the View tab, click Freeze Panes, and choose Freeze Panes. This locks both the top row and first column.
Does SharePoint classic mode support freezing columns?
Classic SharePoint also does not provide a supported row or column freeze setting for list views. Freezing rows or columns in SharePoint usually requires custom development or a third-party application.
Can I export a SharePoint list to Excel?
Yes, in the SharePoint list, click Export > Export to Excel from the command bar. Save the file and open it in WPS Office Spreadsheets to use freeze panes and other spreadsheet tools.
Does WPS Office have a freeze panes feature?
Yes, WPS Office Spreadsheets includes View > Freeze Panes, which can lock top rows, left columns, or both. This is useful for list data exported from SharePoint.





