Others

Can You Pin Multiple Columns in a SharePoint List?

Bushra Parveen Sep 28, 2026 869 views

Question details

The user wants to know if there is a built-in option to pin or freeze multiple columns in a SharePoint list so they remain visible when scrolling horizontally.

Can You Pin Multiple Columns in a SharePoint List?

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Navigating and viewing wide SharePoint lists that contain a large number of data fields requiring horizontal scrolling.
Observed behavior: SharePoint lists do not natively support pinning multiple columns at once through the default user interface.

Before you start

Ensure you have the appropriate permissions to edit list views and apply custom JSON formatting in your SharePoint environment.

Solution 1Recommended

Use JSON Formatting for Custom List Views

Since SharePoint lacks native multi-column pinning, you can explore JSON-based custom view formatting as a developer workaround.

By default, SharePoint does not offer a built-in feature to pin or freeze multiple columns during horizontal scrolling. However, advanced users often use custom JSON formatting to alter the list view behavior.

Because complex multi-column pinning requires specialized code tailored to your exact list structure, it is highly recommended to seek custom script solutions from the Microsoft Q&A SharePoint community.

Access View Formatting

Open your SharePoint list, click the View options dropdown menu in the top right corner, and select 'Format current view'.

Apply Advanced Mode

In the formatting pane, click 'Advanced mode' at the bottom to enter custom JSON code.

Consult the Community

Post your specific list structure requirements in the Microsoft Q&A community using the SharePoint tag to obtain the precise JSON snippet needed for your columns.

Use JSON Formatting for Custom List Views

Native Limitations: If JSON formatting is too complex for your workflow, consider exporting the list to a spreadsheet application where freezing multiple panes is natively supported.

Free Microsoft Office alternative

Manage Large Datasets and Freeze Panes Easily with WPS Office

If dealing with wide SharePoint lists online is cumbersome, exporting your data to WPS Spreadsheet allows you to effortlessly freeze multiple columns and rows for better data analysis. WPS Office is a free, lightweight suite perfectly compatible with Microsoft formats.

1. Export SharePoint data: In your SharePoint list, click 'Export' from the top menu and select 'Export to CSV' or 'Export to Excel'.
2. Open with WPS Spreadsheet: Launch WPS Office and open your downloaded list file.
3. Freeze multiple columns: Select the column immediately to the right of the columns you want to pin, go to the 'View' tab, and click 'Freeze Panes'.

Easily freeze multiple columns and rows in just one click for wide datasets.Fully compatible with Microsoft Excel formats (.xlsx, .csv) exported from SharePoint.Lightweight application with a familiar, easy-to-use interface.Free alternative to Microsoft Office for offline data management.

microsoft office alternative - wps office

Frequently Asked Questions

Can I pin at least one column in a SharePoint list natively?

Yes, SharePoint allows you to pin a single column. You can do this by clicking the column header you wish to freeze, selecting 'Column settings', and then choosing the pin option.

Why doesn't SharePoint support multi-column pinning natively?

SharePoint's modern list views are designed for responsive web performance. Pinning multiple columns introduces complex HTML/CSS rendering challenges on varying screen sizes, which Microsoft has not yet addressed with a built-in UI toggle.

Are there third-party tools to freeze multiple columns in SharePoint?

Yes, some third-party SharePoint Framework (SPFx) solutions and web parts available in the Microsoft AppSource store offer advanced grid capabilities, including the ability to freeze multiple columns.

Office Quick Solutions