Forum Discussion
Freeze columns in SharePoint List
Good Afternoon,
I would like to freeze the first (and maybe second) column of a large list I have so when users scroll, they can still see the first column, like in Excel. I’m trying to see if anyone is familiar with how to do this or has script to accomplish this task.
Thanks!
Arielle
22 Replies
Arielle Gerstein the only way I found is by switching to "grid view"
Hi,
Is there, by chance, a place to vote on features, such as the above? Also, I'm noticing that it has 48,000+ views... maybe that enables a feature, such as the ability to freeze a first column, up the list of priorities? ms_UX_Researcher @MS_Product_Manager
Best,
NathanArielle Gerstein i'm also trying to freeze 1st column in list and headers but didn't found any solution so far. Have you found anything to resolve this?
Shrutika_S I've used sticky headers to freeze the first row in a list, couldn't make it work for the first column.
- SpoilerArielle Gerstein can you please help me with code for sticky headers? I'm looking for the same to use on SharePoint o365
Shrutika_S Try "Sticky Headers" from Spoodoo.com. I've added it to the Masterpage so it shows up everywhere. http://spoodoo.com/downloads.
Deleted will this JS code work for modern SharePoint page as script webpart is not available in it?
- I'm going to answer your problem - which is that you have a wide and/or long list and users need to scroll L-R as well as up/down. The answer (again) is to use the modern UI because it will allow you to significantly limit the number of fields you have displayed in the view.
Because the modern UI let's you easily display ALL fields for an item in the details pane and bulk update multiple items at once, you no longer need to display every column in the list like you did in classic mode. I trim my default views down to only the fields needed to sort & filter the list.
https://support.office.com/en-us/article/View-and-edit-information-about-a-file-folder-or-link-in-a-document-library-1ffa10e8-3169-4f79-8b2e-6ed2e1246f6f
As for the large number of items in your list, you should introduce your users to the smart filter button. You can pin fields to the filter button. Hit the button, select your filter terms and apply. Tah dah! much shorter list! :-)
https://support.office.com/en-us/article/what-is-the-list-and-library-filters-pane-293561ed-fb2e-4fb2-9a9f-8a21e299e323 Try Sticky Headers. I added the javascript into my Masterpage. http://spoodoo.com/stickyheaders-for-sharepoint-update-v3-2-0/
Deleted Thanks! I currently have sticky headers for the top row but not the first column. Is the file available for download here? http://spoodoo.com/products/stickyheaders-for-sharepoint/
Nothing is showing up when I click on this page.
- By the way, If your list is a modern list you are not going to be able to use it because it's not recommended / supported to modify SPO sites master pages
- You cannot freeze the first header of a large list, but sticky headers are coming to SPO lists
- https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=SharePoint&searchterms=64168
