SharePoint Document Issues

Fix SharePoint Grouped Views Displaying the Grouped Column

Bushra ParveenBushra Parveen Oct 9, 2026 869 views

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.

How to Hide the Grouped Column in SharePoint Online Expanded Views
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.
Before you start

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.

Solution 1Recommended

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.

1
Open View Options

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.

2
Select Format Current View

From the dropdown list, click on 'Format current view' to open the formatting pane on the right side of the screen.

3
Switch to Advanced Mode

At the bottom of the formatting pane, click the 'Advanced mode' link to switch from the basic designer to the code editor.

4
Apply Custom JSON

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.

Use JSON View Formatting to Hide the Column
JSON Compatibility: JSON formatting works on modern SharePoint Online lists. If you are using classic SharePoint views, this method will not be available.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
  2. 2. Install the Suite: Run the installer and follow the on-screen prompts to set up WPS Office on your device in seconds.
  3. 3. Open Your Office Files: Launch WPS Office and directly open your existing Word, Excel, or PowerPoint files without losing any formatting.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx, and more).Lightweight design ensures fast loading and smooth file management without heavy browser overhead.Tabbed viewing makes it easy to switch between multiple documents, spreadsheets, and PDFs in a single window.
microsoft office alternative - wps office

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.