Permission & Access Issues

Enable Quick Edit for SharePoint Online List and Library Users

Bushra ParveenBushra Parveen Nov 13, 2026 868 views

Question details

Enable eligible SharePoint Online users to use Quick Edit for list or library items.

Enable Quick Edit for SharePoint Online List and Library Users
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the relevant permissions

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.

2
Check an affected user

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.

3
Update access at the right level

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.

4
Test Quick Edit

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.

Grant users a permission level that includes Edit Items
Choose permissions carefully: Contribute includes other permissions in addition to Edit Items. If that access is broader than required, use an appropriate custom permission level and review the user's effective permissions.
Free Microsoft Office alternative

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.

Edit exported list data in a familiar spreadsheet interfaceCompatible with Microsoft Excel formats, including XLSXFree and lightweight for everyday document workFamiliar tools make moving from Microsoft Office easier
microsoft office alternative - wps office

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.