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. The Quick Edit feature allows users to quickly and easily edit the metadata of a list or library. Quick Edit allows users to edit multiple items at once, making it a useful tool for updating and maintaining data in SharePoint.

What if the Quick Edit is disabled? In this guide, we will show you how to enable Quick Edit in SharePoint Online, so that you and your team can quickly and easily make updates to your lists and libraries.

How to Enable Quick Edit 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, the quick edit option is disabled. Remove the “Group By” selection by setting it to none.
  3. Change the View style to default: Changing the 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 Checkboxes” 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

In conclusion, enabling the Quick Edit feature in SharePoint Online is a simple process that can be accomplished by following a few steps. By going to the SharePoint site, and navigating to the list or library settings, you can turn on the Quick Edit option. This allows more efficient editing of items and documents in a list or library. By enabling the Quick Edit feature, users can make changes directly from the view, which can save time and improve the user experience.

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

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

  • It seems they removed ‘quick edit’ and replaced it with ‘edit in grid view’.

  • verified these setting and still no quick edit icon. the only thing changing the view for a specific list to the default view was add these specific columns to the every other document library in the channel and that is NOT what i want. there has got to be an easier way than to having to constantly change the view every time we go into that folder and/or edit in the grid. which, by the way, editing in the grid usually causes more errors and time wasted because it’s inevitable that there’s an “error” in one of the cells even though there is clearly nothing different than the cells around it.

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