SharePoint Document Issues

Fix SharePoint Edit in Grid View Disappears After Grouping

Steve K Sep 28, 2026 869 views

Question details

The user needs to find a way to use the Edit in grid view feature for bulk editing on a SharePoint list that has grouping applied.

How to Fix SharePoint Edit in Grid View Disappearing After Grouping

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: The user is attempting to bulk edit items in a large SharePoint list while keeping the list items grouped by a specific column.
Observed behavior: The 'Edit in grid view' button completely disappears when grouping is applied to the list view. Additionally, while filtering alone keeps the button visible, it can cause the grid view processing indicator to load infinitely on larger lists.

Before you start

Verify that you have the appropriate edit permissions for the SharePoint list and take note of the specific columns you are currently using to group your list items.

Solution 1Recommended

Create a Separate Ungrouped View for Bulk Editing

Since SharePoint's modern list experience intentionally disables grid editing on grouped views, the most efficient workaround is to maintain two separate views: one for browsing and one for bulk editing.

SharePoint currently does not support the 'Edit in grid view' feature when a list view contains grouped columns. To bypass this limitation without losing your preferred layout, you can quickly toggle between a grouped view for everyday browsing and an ungrouped view strictly for bulk editing data.

Save the current view as a new view

Click the 'View options' dropdown menu in the top right corner of your SharePoint list and select 'Save view as'. Name this new view something recognizable, like 'Bulk Edit View'.

Edit the new view to remove grouping

While in your newly created 'Bulk Edit View', click the 'View options' menu again and select 'Edit current view'. Scroll down the settings page to the 'Group By' section.

Apply 'None' to grouping settings

Change the 'First group by the column' dropdown to 'None' and click 'OK' at the top or bottom of the page to save the changes.

Switch views to edit

Whenever you need to bulk update items, use the View dropdown to switch to your 'Bulk Edit View'. The 'Edit in grid view' button will reappear for you to use.

Create a Separate Ungrouped View for Bulk Editing

Solution 2

Switch to Classic Experience for Quick Edit

If you are experiencing infinite loading issues while filtering large lists in modern grid view, switching to the classic experience allows you to use the legacy Quick Edit tool.

Free Microsoft Office alternative

Looking for a smoother document management experience?

While SharePoint list views are managed strictly within the Microsoft web ecosystem, handling the actual documents stored inside them shouldn't be a hassle. WPS Office provides a lightweight, highly compatible alternative to Microsoft Office for creating and editing all your downloaded SharePoint files.

1. Download WPS Office: Get the free WPS Office suite from the official website and install it on your device.
2. Download SharePoint Files: Select the documents you need from your SharePoint list or library and download them to your local computer.
3. Edit with Full Compatibility: Open the downloaded .docx, .xlsx, or .pptx files directly in WPS Office to edit them seamlessly without formatting issues.

Completely free to use with a lightweight installation packageFully compatible with Microsoft Word, Excel, and PowerPoint formatsFamiliar, tabbed user interface for a seamless transitionBuilt-in PDF editing tools for comprehensive document management

microsoft office alternative - wps office

Frequently Asked Questions

Why does 'Edit in grid view' disappear when I group items in SharePoint?

SharePoint's modern list experience currently does not support the 'Edit in grid view' functionality on views that have grouping applied. Grouping changes how the data is structured on the page, so SharePoint intentionally hides the grid edit button to prevent data entry conflicts.

Can I use 'Edit in grid view' if my SharePoint list is only filtered, not grouped?

Yes, applying filters alone does not remove the 'Edit in grid view' option. However, on larger lists with many items, applying a filter before entering grid view might cause a continuous loading indicator. In such cases, switching to the classic experience is recommended.

How do I exit the classic experience in SharePoint?

To return to the modern list view from the classic experience, click the 'Exit classic experience' link located at the bottom left corner of the screen. Alternatively, you can simply close the browser tab and reopen the SharePoint list from your site's homepage.

Document & File Issues