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 SharePoint Online’s quick edit missing issue:

  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 - SharePoint Expert with Two decades of SharePoint Experience. Love to Share my knowledge and experience with the SharePoint community, through real-time articles!

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

  • Same here as jerryB

  • 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?


Leave a Reply

Your email address will not be published. Required fields are marked *