Forum Discussion
lindamitch
Mar 03, 2020Copper Contributor
Freeze first column in SharePoint List
I am using custom views and filters but for certain custom views I still find it necessary to have a number of fields that extend beyond the page width. It would be really helpful to keep the first column - for example vendor name. I appreciate the header in SharePoint lists that are now static but is there a way to freeze a column on the left of the list view? I have read other articles here and done some research and haven't come up with anything yet. Appreciate your help.
Thanks.
- DeletedJan 25, 2018
This is quite problematic for our users too, a lot of users got caught out by creating spreadsheets in OneDrive sync folder on their machine, linking there and then sharing the files. The Excel has a link reference to C:\user\<name>\One Drive - <Tenant Name>\Test.xlsx etc But of course the person using the file does not have access that persons c: drive so the <name> bit doesn't exist on their local drive.
Links to https:\\<onedrive location> tend to also be a little slow.
So its tricky, plus links like this can easily break spreadsheets and cause errors. I'm not sure I can count the times that someone has come to me asking me to check their spreadsheet because they think it might be wrong but they can't see where the issue is. Normally its a link or copying down etc.
If it was me, I would use the new feature built into Excel called PowerQuery, on the data tab, using SharePoint Folder link and avoid using links all together ... but this is a lot of work to change, but the long term benefits are huge.
This effectively queries the other spreadsheet, using a simple interface, so no need for vloopup or linking or calculations in the spreadsheet ... all calculations can be done in the query, so they are repeatable and difficult to break. Plus as a bonus, if you copy the query which it builds it can be pasted into PowerBI and you can create dashboards very quickly that are available anywhere.
4 Replies
Sort By
- Not sure if this can be done and I believe this has been asked to be done through List View Formatting, but not sure if this is available yet
- bretchamCopper Contributor
jcgonzalezmartin Is there a plan to enable freezing of the first column in a SP list? I would like to use the feature.
Unfortunately, Freeze/Sticky columns are not released yet for normal view in lists.
It was targeted earlier for release in December 2021 but now the release timeline will be updated by Microsoft for this feature. Check more information at: Microsoft Lists: sticky first column - built on SharePoint
However, Sticky columns are available in Quick Edit (Grid view) view of Microsoft lists: As users scroll horizontally across a list in Quick Edit mode, the far-left column remains in place - improving context while viewing and editing.
Similar thread: Can you freeze a column in SharePoint list
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.