How to Enable Quick Edit in SharePoint Online?

Problem: SharePoint Online quick edit missing!

How to Enable Quick Edit in SharePoint Online? 

The “Edit in grid view” feature provides a flexible Excel-like interface to bulk edit/update list items in SharePoint Online. Here is the troubleshooting checklist to fix the quick edit missing issue in SharePoint Online.

  1. Check if Quick Edit is enabled: To enable quick edit in SharePoint Online, you need to navigate to List Settings >> Advanced settings page >> Scroll down and under the quick edit option, choose “Yes” and then click OK.
    SharePoint Online quick edit missing
  2. Remove the Group By: If you have Group by enabled in your list views, You got to remove it! If you group list or library items in SharePoint Online, quick edit option is disabled. remove “Group By” selection by setting it to none.
  3. Change the View style to default: Changing view style to “Shaded”, “Newsletter” or something else disables Quick Edit. Change it to “default” in view settings.
  4. Enable ‘Allow individual item” check boxes: In view settings make sure, “Allow Individual Items Check boxes” is enabled.    sharepoint 2013 quick edit this control is currently disabled
  5. Calculated columns won’t work in quick edit.
  6. If you have multiple lines of text field, make sure it’s set to plain text. Otherwise, You won’t be able to edit the filed value in Quick edit.

If quick edit missing in SharePoint On-premises, refer: Fix: Quick Edit Disabled in SharePoint Issue

Salaudeen Rajack

Salaudeen Rajack is a SharePoint Architect with Two decades of SharePoint Experience. He loves sharing his knowledge and experiences with the SharePoint community, through his real-world articles!

2 thoughts on “How to Enable Quick Edit in SharePoint Online?

  • July 29, 2021 at 11:43 PM

    Same here as jerryB

    Reply
  • July 15, 2021 at 1:57 AM

    verified all these settings still no quick edit icon. I do have an edit in grid view icon but i can’t paste multiple rows from excel it will only do one at a time. Any ideas?

    Reply

Leave a Reply