How to Disable Quick Edit in SharePoint Online?

Requirement: Disable Quick Edit in SharePoint Online.

Quick edit is a great feature in SharePoint Online that allows users to quickly change list items and document metadata. While this is a convenient feature, there may be times when you need to disable Quick Edit for some reason. In this post, I will walk you through how to turn off Quick Edit for users in SharePoint Online. Let’s get started!

We have a project tracking list with the field “Project Health”, which is updated by an event receiver based on specific parameters and business logic. So, we made the field hidden in SharePoint Online using: SharePoint Online: How to Hide a Column from List Forms? However, users can go to the “Quick Edit” mode of the list and get the hidden field there! Although the column was hidden from New and Edit Forms, SharePoint Online quick edit still displays the hidden field, and we wanted to disable quick edit for the SharePoint Online list.

how to disable quick edit in sharepoint online

How to disable “Edit in Grid View” (Quick Edit) in SharePoint Online?

To disable quick edit in SharePoint Online, follow the below steps:

  1. Navigate to the List >> Click on Settings >> List settings
  2. Click on the “Advanced settings” link under the list settings page.
  3. In the Advanced Settings link, scroll down, and under the “Quick property editing” option, choose “No” for “Allow items in this list to be edited using Quick Edit?” and then click OK.

This disables quick edit in the SharePoint Online list, even in classic mode.

how to disable quick edit in sharepoint 2013

PowerShell to Disable Quick Edit in SharePoint Online

To turn off “Edit in grid view”, use this PowerShell script:

Import-Module Microsoft.Online.SharePoint.Powershell

#Set Parameters
$SiteURL="https://crescent.sharepoint.com/sites/Retail"
$ListName ="Projects"

#Get Credentials to connect
$Cred = Get-Credential

Try{
    #Setup the context
    $Ctx = New-Object Microsoft.SharePoint.Client.ClientContext($SiteURL)
    $Ctx.Credentials = New-Object Microsoft.SharePoint.Client.SharePointOnlineCredentials($Cred.Username, $Cred.Password)
    
    #Get the List
    $List = $Ctx.Web.Lists.GetByTitle($ListName)
    $Ctx.Load($List)

    #Disable Quick Edit
    $List.DisableGridEditing = $true
    $List.Update()
    $Ctx.ExecuteQuery()
    }
Catch {
    Write-host -f Red "Error:" $_.Exception.Message
}
enable edit in grid view sharepoint online

You can also use the PnP PowerShell script to disable the quick edit mode SharePoint Online list:

#Parameters
$SiteURL = "https://Crescent.sharepoint.com/sites/Marketing"
$ListName = "Projects"
 
#Connect to the site
Connect-PnPOnline $SiteURL -Interactive

#Get the List 
$List = Get-PnPList -Identity $ListName

#Disable Quick Edit in SharePoint Online List
$List.DisableGridEditing = $True
$List.Update()
Invoke-PnPQuery

To return the quick edit, just set the “DisableGridEditing” to “$False”.

Here is another article to hide quick edit in SharePoint On-premises, use: How to Disable Quick Edit in SharePoint?

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!

Leave a Reply

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