Others

How to Freeze the Top Row or Left Column in SharePoint Lists Using WPS Office

Kushani NimanthikaKushani Nimanthika Nov 13, 2026 869 views

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.

How to Freeze the Top Row or Left Column in SharePoint Lists Using WPS Office
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.
Before you start

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.

Solution 1

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.

1
Open the SharePoint list

In your SharePoint site, open Lists and select the list where you want to freeze the top row or left column.

2
Open view settings

Click the view selector or the gear icon in the upper-right corner, then choose List settings and select the current view.

3
Review available view options

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.

No built-in freeze setting: Modern SharePoint lists do not provide a standard freeze top row or left column option. You would need a workaround or custom development.
Free Microsoft Office alternative

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. 1. Export the SharePoint list to Excel: Open the SharePoint list, click Export > Export to Excel, and save the file.
  2. 2. Open the file in WPS Office Spreadsheets: Launch WPS Office and open the exported Excel file.
  3. 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. 4. Scroll to verify: Scroll down and right; the frozen top row or left column remains visible.
Freeze top rows and left columns in WPS Office Spreadsheets after exporting a SharePoint listWorks with Microsoft Excel .xlsx files for seamless SharePoint list exportsFree, lightweight Office alternative with a familiar ribbon interfaceNo unsupported SharePoint customizations required
microsoft office alternative - wps office

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.