Forum Discussion
VeeExcelLearn
Aug 14, 2022Brass Contributor
Can you freeze a column in SharePoint list
Is there a way to freeze theh first column in SharePoint lists?
You can create a report that consolidates data from multiple sheets in Excel.
Here's a step-by-step guide to accomplish this:
- Open a new worksheet where you want to create the report.
- Rename this worksheet to something like "Report" or "Consolidated Data."
- In the first column of the "Report" sheet, list the fields you want to include (e.g., First Name, Last Name, etc.).
- In the second column, enter the formula to retrieve the data from each individual sheet. Assuming your individual sheets are named "Sheet1," "Sheet2," and so on, the formula in cell B2 of the "Report" sheet would be: =Sheet1!B2
This formula retrieves the data from cell B2 of "Sheet1." Adjust the cell references accordingly to match your specific data layout.
5. Copy the formula in cell B2 and paste it down the column to retrieve data for all individuals from each sheet.
6. Repeat steps 4 and 5 for each field and each individual sheet, ensuring that the formulas reference the correct cells in each respective sheet.
7. Format the report as desired, applying any necessary formatting, headers, or styling to improve readability.
By following these steps, you can consolidate data from multiple sheets into a single report in Excel. Whenever you update the data in the individual sheets, the report will automatically reflect the changes.
5 Replies
Sort By
VeeExcelLearn 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.
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.
- Sandra_Abi-KhalilBrass Contributor
ganeshsanap What happened to this feature? Is it still planned to be released at some point? It is much needed.
Sandra_Abi-Khalil Here's the latest update on this feature:
Please consider giving a Like if my post helped you in any way.
- RobElliottSilver Contributor
VeeExcelLearn unfortunately not. You can vote for one of the requests for it https://feedbackportal.microsoft.com/feedback/search/06735c62-321c-ec11-b6e7-0022481f8472?q=freeze+column
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)