Share via

Freezing Columns on a SharePoint List

Stephanie Harris 40 Reputation points
2024-04-17T18:45:24.6+00:00

Hi. I have a SharePoint list that contains a large amount of data with several columns. How do I freeze the first six columns, or, at minimum, just freeze the sixth column? I've been scouring the internet and found that there is no direct way to accomplish this, but there are work-arounds. The problem is that the solutions are not easy to follow for someone who does not have experience with CSS, jquery, html, (etc). If I HAVE to use one of these languages, I'll find someone to help me; Or if someone could provide a more detailed response, that would be so helpful!! Note: No columns on the sp list are to be hidden (to shorten the length of scrolling from left to right). Thanks!

Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | SharePoint | For business | Windows

Answer accepted by question author

Yanli Jiang - MSFT 31,686 Reputation points Microsoft External Staff
2024-04-18T02:22:44.7633333+00:00

Hi @Stephanie Harris ,

As you said, there is currently no out-of-the-box way to implement it. For using CSS, jquery, html, (etc), it is more complicated. I have two suggestions for your consideration:

  1. As a workaround, I recommend you use Export to Excel from List. Then freeze the columns in the excel file to view the data. Moreover, the data has a one-way connection to the original list. Periodically refreshing the workbook pulls in changes that have been made in the list. This should meet your needs.
  2. Regarding this matter, it is recommended that you submit feedback. Microsoft values its customer feedback and a lot of features have been developed and suggested by customers via feedback.

Thank you for your support and understanding!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Was this answer helpful?

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Stephanie Harris 40 Reputation points
    2024-04-19T15:26:08.5466667+00:00

    Thanks for the excel tip, Yanli.

    Regarding the feedback, I didn't add a new suggestion/feedback, I just found an already existing feedback and added a comment. Here is the link: https://feedbackportal.microsoft.com/feedback/idea/e2d1924a-8790-ee11-a81c-000d3a02ba69

    Thanks for your help!

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.