Enable Quick Edit for SharePoint Online List and Library Users
Question details
Enable eligible SharePoint Online users to use Quick Edit for list or library items.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- A site administrator wants standard users to edit list or library items using Quick Edit.
- Observed behavior
- Administrators can see Quick Edit, but standard users cannot.
You need permission to manage access on the SharePoint site, list, or library. Identify an affected user and check whether the list or library has unique permissions rather than inheriting them from the site.
Grant users a permission level that includes Edit Items
Use this approach when standard users cannot see Quick Edit because their effective permissions do not allow them to edit items.
Open the affected SharePoint list or library, select Settings, and open List settings or Library settings. Select Permissions for this list or Permissions for this document library.
On the permissions page, select Check Permissions, enter the user's name, and select Check Now. Review the user's effective permission levels and whether the list or library inherits permissions.
On the relevant site, list, or library permissions page, select the user or group and choose Edit User Permissions. Assign a permission level that includes Edit Items, such as Contribute, and select OK. If permissions are inherited, make the change at the parent level or, when appropriate, stop inheriting permissions first.
Ask the user to refresh the list or library and look for Edit in grid view or Quick Edit on the command bar. Have the user edit an item to confirm access.

Check whether grid editing is enabled for the list
Use this check if users have Edit Items permission but still cannot access Quick Edit.
Edit exported SharePoint list data with WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility. Open an exported list workbook in WPS Spreadsheets for a smooth transition to spreadsheet editing. WPS does not change SharePoint permissions or enable Quick Edit.

Frequently Asked Questions
Why can administrators see Quick Edit when standard users cannot?
Quick Edit requires permission to edit items. On the list or library permissions page, use Check Permissions to see whether an affected user has a permission level that includes Edit Items.
What permission level lets users edit SharePoint items?
The built-in Contribute permission level includes Edit Items, along with other permissions. An administrator can also use a suitable custom permission level that includes Edit Items.
Does changing site permissions update every list and library?
It affects lists and libraries that inherit permissions from the site. A list or library with unique permissions must be reviewed and updated at its own permissions page.
What is Quick Edit called in the modern SharePoint interface?
In the modern experience, the command is commonly labeled Edit in grid view. Look for it on the list or library command bar.
Can WPS Office enable Quick Edit in SharePoint Online?
No. A SharePoint administrator must manage the relevant permissions and settings. WPS Spreadsheets can open compatible exported workbooks, but it does not change SharePoint access.




