Fix SharePoint Grouped Views Displaying the Grouped Column
Question details
Users want to permanently hide the column used for grouping in a SharePoint list so it does not reappear as a standard column when the group is expanded.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Viewing and managing grouped lists in SharePoint Online.
- Observed behavior
- The field used to group the list is displayed as the grouping header, but when the group is expanded, the same field reappears as a standard column. Hiding it via standard view settings only works temporarily.
Note that Microsoft considers this behavior 'by design' because the grouped field acts as both a header and underlying list data. To hide it permanently, you will need basic familiarity with applying JSON column or view formatting.
Use JSON View Formatting to Hide the Column
Apply custom JSON code to your list view to override the default display settings and hide the grouped column when expanded.
Because the standard SharePoint UI does not provide a permanent toggle to hide the grouped column within an expanded view, applying advanced view-formatting JSON is the most effective workaround. Results may vary slightly depending on your specific list setup.
Navigate to your SharePoint list. In the top right corner of the list, click on the 'View options' dropdown menu, which is usually named after your currently active view.
From the dropdown list, click on 'Format current view' to open the formatting pane on the right side of the screen.
At the bottom of the formatting pane, click the 'Advanced mode' link to switch from the basic designer to the code editor.
Paste your custom JSON payload designed to hide the specific column (for example, utilizing SharePoint's FAQ accordion JSON samples or setting display styles to none for that column). Click 'Save' to apply the formatting.

Submit Feature Feedback to Microsoft
Since the duplicate display is a built-in feature, submitting feedback is the primary way to encourage Microsoft to add a native toggle switch.
Need a More Intuitive Document Management Experience?
If navigating complex SharePoint lists and Microsoft Office workarounds is slowing you down, try WPS Office. It provides a lightweight, highly compatible alternative for processing documents, spreadsheets, and presentations with an intuitive interface that just works.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the Suite: Run the installer and follow the on-screen prompts to set up WPS Office on your device in seconds.
- 3. Open Your Office Files: Launch WPS Office and directly open your existing Word, Excel, or PowerPoint files without losing any formatting.

Frequently Asked Questions
Why does SharePoint show the grouped column twice?
Microsoft designed SharePoint lists to retain the grouped column as standard list data. This ensures that the individual item metadata remains fully intact and visible even when items are visually grouped by that header.
Can I permanently hide the grouped column using standard list settings?
No. While you can uncheck the column in the 'Show/Hide columns' menu, this change is only temporary for grouped views. Once a group is expanded, SharePoint automatically re-displays the column to show the item's underlying data.
Does JSON formatting work for all SharePoint lists?
View-formatting JSON is widely supported for modern SharePoint Online lists. However, results can vary based on specific view configurations, column types, and your organization's security settings regarding custom scripting.




