'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Can You Limit SharePoint Edit in Grid View by User Group?
Question details
SharePoint list owners want to restrict the 'Edit in Grid View' bulk editing capability to a specific user group while allowing another group to edit only individual items without accessing the grid view.
- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Managing user group permissions to separate bulk editing access from individual item editing access in a SharePoint list.
- Observed behavior
- SharePoint allows administrators to enable or disable 'Edit in Grid View' globally for everyone via Advanced Settings, but it does not natively support hiding or restricting Grid View for selected users while retaining their individual item editing rights.
Ensure you have Site Owner or Full Control permissions for the specific SharePoint list to access and modify Advanced Settings and list permissions.
Disable 'Edit in Grid View' for the Entire List
Since SharePoint cannot restrict this feature by user group, you can disable bulk editing for everyone to prevent unauthorized mass changes while maintaining individual item editing.
This method turns off the Quick Property Editing feature at the list level. No users, including administrators, will see the 'Edit in Grid View' button, but they can still click on individual items to edit them in the properties pane.
Navigate to your SharePoint list, click the gear icon (Settings) in the top-right corner, and select 'List settings'.
Under the 'General Settings' column on the settings page, click on 'Advanced settings'.
Scroll down to the 'Quick property editing' section. Select the 'No' radio button to disable the feature.
Scroll to the bottom of the page and click 'OK' to apply the changes to your list.
Use Custom Permission Levels to Restrict Item Editing
While you cannot isolate the Grid View button, you can adjust permissions so specific groups cannot edit items at all, restricting them to read-only access.
Experience a Lightweight and Free Office Suite with WPS Office
Managing granular permissions and lists in enterprise tools like SharePoint can sometimes be rigid. If you are looking for a streamlined, everyday productivity suite, WPS Office provides a familiar interface, high compatibility, and excellent tools for managing data offline without the heavy administrative overhead.
- 1. Download the Installer: Visit the official WPS Office website and download the free installer for your operating system.
- 2. Install WPS Office: Run the downloaded file and follow the straightforward on-screen prompts to set up the software.
- 3. Start Creating: Open WPS Office to instantly start viewing, creating, and editing your documents and spreadsheets without complex permission configurations.
Frequently Asked Questions
Will disabling Quick Property Editing affect individual item edits in SharePoint?
No, disabling Quick Property Editing only removes the 'Edit in Grid View' option used for bulk edits. Users with the appropriate 'Contribute' or 'Edit' permissions can still click on individual items and update them via the standard properties pane.
Can I hide the 'Edit in Grid View' button using JSON formatting?
No, JSON view formatting in SharePoint is designed to customize the display of columns and rows within the list area. It cannot interact with or hide native command bar buttons like 'Edit in Grid View' based on specific user groups.
How do I submit a feature request to Microsoft for group-based grid view control?
You can submit feature requests by navigating to the official Microsoft Feedback portal for SharePoint online. The Microsoft product team regularly reviews user feedback to evaluate future platform updates and capabilities.
Can Power Apps be used to bypass this bulk editing limitation?
While Power Apps cannot modify the native 'Edit in Grid View' button, you can use it to create a highly customized list form. By designing a custom app interface, you can enforce stricter, group-based logic on how data is viewed and edited outside the standard SharePoint grid view.
