How to Disable Quick Edit in SharePoint?

Requirement:  Disable quick edit in SharePoint 2016 list.

How to disable quick edit in SharePoint 2013 or SharePoint 2016?

A bit of background: 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 List forms using: How to Hide a Column from NewForm/EditForm in SharePoint?

Now the problem is that users can go to the “Quick Edit” mode of the list and get a hidden field there! Although the column was hidden from Edit and New Forms, SharePoint quick edit (which replaced the Datasheet view in previous versions of SharePoint) still displays the hidden field. So, we decided to disable the quick edit mode for the SharePoint list.

SharePoint how to disable quick edit:

To disable quick edit mode in SharePoint 2013 or SharePoint 2016, follow the below steps:

1. Go to the list settings >> Click on the “Advanced settings” link.
2. 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.

   

3. This disables quick edit in the SharePoint list.

Disable quick edit using PowerShell

Here is how we can disable quick edit SharePoint 2016 programmatically with PowerShell:

Add-PSSnapin Microsoft.SharePoint.PowerShell -ErrorAction SilentlyContinue

#Parameters
$WebURL="https://intranet.crescent.com"
$ListName="Projects"

#Get Web and List objects
$Web = Get-SPWeb $WebURL
$List = $Web.Lists.TryGetList($ListName)

$List.DisableGridEditing=$true
$List.Update()

CSS to disable quick edit in SharePoint

Alternatively, you can hide the Quick Edit button in the ribbon with CSS. Here is the CSS to hide SharePoint Quick edit:

<style>
#Ribbon\.List\.ViewFormat\.Datasheet-Large {
display:none;
}
</style>

Click on Settings Gear >> Edit Page >> Click on the “Add Web Part” link and then add a script editor web part. Edit the snippet and place this CSS code in it, Stop Editing to save your changes. For Libraries, use:

<style>
#Ribbon\.Library\.ViewFormat\.Datasheet-Large {
display:none;
}
</style>

To disable Quick edit in SharePoint Online, use: How to Disable Quick Edit in SharePoint Online?