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 ...
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
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
