Permission & Access Issues

Fix Missing SharePoint Grid View with Item-Level Permissions

Aamir Naveed AkramAamir Naveed Akram Oct 23, 2026 869 views

Question details

Users need to use the 'Edit in grid view' and 'New' buttons in a SharePoint list, but these commands are unavailable when users only have edit permissions for selected items.

How to Enable SharePoint Grid View with Item-Level Permissions
Product
SharePoint
Device & OS
not provided
Scenario
Attempting to bulk edit or create items in a SharePoint list using Grid View.
Observed behavior
The 'Edit in grid view' and 'New' buttons are completely hidden or disabled for users who lack list-level Edit permissions.
Before you start

Verify that you have Site Administrator or Full Control permissions for the SharePoint site, as modifying list inheritance and user permissions requires elevated access.

Solution 1Recommended

Restore List-Level Permissions to Enable Grid View

Since SharePoint requires list-level Edit permissions for Grid View, you must remove unique item permissions and grant list-wide access to affected users.

SharePoint natively hides the 'Edit in grid view' and 'New' buttons if a user only has edit permissions for specific items. To make these features visible again, you must delete unique permissions and provide standard Edit access to the entire list. Currently, Microsoft does not provide a supported way to enable grid view while strictly restricting users to selected rows.

1
Navigate to List Settings

Open your SharePoint list, click the gear icon (Settings) in the top-right corner of the page, and select 'List settings' from the dropdown menu.

2
Access Permissions

Under the 'Permissions and Management' column, click on 'Permissions for this list'.

3
Remove Unique Permissions

In the Permissions ribbon, click 'Delete unique permissions' to restore inherited permissions from the parent site.

4
Grant List-Level Access

If you are not using inherited permissions, click 'Grant Permissions' in the ribbon and assign 'Edit' access to the necessary users or groups.

Restore List-Level Permissions to Enable Grid View
Security Consideration: Granting list-level Edit access allows users to view and edit other items in the list. If strict row-level security is legally or operationally required, users must edit items individually rather than using Grid View.
Free Microsoft Office alternative

Looking for Flexible Data Management? Try WPS Office

If SharePoint's strict list permission limitations are hindering your team's workflow, consider managing your data tables with WPS Spreadsheet. It offers an incredibly lightweight, fully compatible environment for your data without the rigid constraints of SharePoint list views.

  1. 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Open Your Data: Export your SharePoint list to Excel and open the file seamlessly in WPS Spreadsheet.
  3. 3. Protect Specific Ranges: Go to the 'Review' tab and use 'Allow Users to Edit Ranges' to easily set up granular, item-level editing permissions without breaking view capabilities.
Highly compatible with Microsoft Excel (.xlsx) formats and SharePoint data exportsLightweight application that runs smoothly on all devicesAdvanced worksheet protection allowing granular editing permissions for specific rangesCompletely free to download with a familiar, easy-to-use interface
QA img-9

Frequently Asked Questions

Can I enable 'Edit in grid view' for specific items only in SharePoint?

No. SharePoint currently requires users to have Edit permissions at the list level to use the 'Edit in grid view' feature. There is no supported way to enable the grid view button while restricting users' access to only specific rows.

Why is the 'New' button missing in my SharePoint list?

The 'New' button disappears if a user does not have list-level Edit permissions. When users are only granted item-level permissions, SharePoint hides the button because they lack the authority to create new list entries at the root level.

How do I check if my SharePoint list has unique permissions?

Navigate to List Settings > Permissions for this list. If the list has unique permissions, you will see a yellow banner stating 'This list has unique permissions', and the 'Delete unique permissions' option will be visible in the top ribbon.