How to Enable Quick Editing in SharePoint Online – Vice & Versa

SharePoint provides a wide range of customization for a SharePoint site. This customization includes features that will help users use the site and view and edit content. However, a “Quick edit” feature in the SharePoint site lets users edit site content and metadata tags easily. If it is not enabled by default you can allow it using SharePoint. One question that can arise from here is how to enable quick editing in SharePoint Online.

What is Quick Edit in SharePoint?

In SharePoint, the Quick Edit feature enables users to easily edit the metadata tags of a SharePoint list and library. However, by using the Quick Edit feature, you can edit multiple items at once, this action makes it a useful tool for editing and updating bulk SharePoint site content.

Enable Quick Editing in SharePoint Online – Manual Steps

After understanding what is quick edit feature let’s understand how to enable quick editing.

Follow these steps to enable the Quick Edit feature:

• Step 1. Firstly, check whether the Quick Edit feature is already enabled or not.
• Step 2. Secondly, if it is not enabled then go to list settings. 
• Step 3. Thirdly, click on advanced settings.
• Step 4. Lastly, scroll down to the Quick Edit Option.
• Step 5. Finally, Select Yes and then click on OK.

Reasons: why Quick Edit is not showing

1. You have disabled the Group By option due to that the Quick Edit option is not Showing
2. If you have enabled any customized view set it to the Default view
3. For calculated columns, the Quick Edit feature will not work

After performing these steps your query regarding how to enable quick editing in SharePoint Online is solved.

PowerShell Method to Enable The Quick Editing

After performing the manual steps let’s see an automated step that can enable the quick editing in a few lines of code helpful for admins who are enabling the quick editing feature in bulk.

Note: To perform this step you need to be Admin or have Admin  Credentials. Also, you have to be very careful while performing this step because this step requires effort and proven technical skills.

1. Install SharePoint Online Management Shell:

Install-Module -Name Microsoft.Online.SharePoint.PowerShell

2. Now connect to the SharePoint Online

Connect-SPOService -Url https://yourdomain-admin.sharepoint.com
#enter your site URl in place of YourDomain

3. Set Quick Edit Permissions

# Variables
$siteUrl = "EnterYourSharePointSiteURL"
$listName = "EnterYourListName"
$groupName = "EnetrYourSharePointGroup"

# Connect to site
$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)
$ctx.Credentials = Get-Credential

# Get the list
$list = $ctx.Web.Lists.GetByTitle($listName)

# Get the group
$group = $ctx.Web.SiteGroups.GetByName($groupName)

# Get the role definition (e.g., Contribute, Edit)
$roleDefinition = $ctx.Web.RoleDefinitions.GetByType([Microsoft.SharePoint.Client.RoleType]::Contribute)

# Create a role assignment
$roleAssignment = New-Object Microsoft.SharePoint.Client.RoleAssignmentCreationInformation
$roleAssignment.PrincipalId = $group.Id
$roleAssignment.RoleDefinitionBindings.Add($roleDefinition)
# Add the role assignment to the list
$list.RoleAssignments.Add($roleAssignment)
$ctx.ExecuteQuery()

4. Check and Update list settings

Sometimes the custom settings or view can interrupt the enabling of the Quick editing feature, to avoid this set and update the list settings for tabular view.

$ctx = New-Object Microsoft.SharePoint.Client.ClientContext($siteUrl)
$ctx.Credentials = Get-Credential
# Get the list
$list = $ctx.Web.Lists.GetByTitle($listName)
# Ensure Quick Edit is available
$list.Views | ForEach-Object {
$_.TabularView = $true
$_.Update()
}
$ctx.ExecuteQuery()

After executing all these steps you have successfully learned how to enable Quick editing in SharePoint Online.

How to Disable Quick Edit in SharePoint Online?

Sometimes a user may need to use Group By view for that he needs to disable the Quick Edit Feature. Here are the steps to disable the quick edit feature:

• Step 1. Firstly, check if the Quick Edit feature is already disabled or not.
• Step 2. Secondly, if it is not disabled then go to list settings. 
• Step 3. Click on advanced settings.
• Step 4. Now scroll down to the Quick Edit Option.
• Step 5. Finally, select No and then click on OK.

You have successfully disabled the Quick Edit Feature.

Disable Quick Edit Using PnP PowerShell

After understanding how to enable quick editing in SharePoint Online let’s see PowerShell cmdlets to disable it. PnP PowerShell allows users to automate disabling the Quick edit feature.

Copy this cmdlet and Use it in PnP PowerShell -
#initialize startingParameters
$SiteURL = "site URL"
$ListName = "Enter Your Lits Name"
#Cmdlets to connect PnP to your site
Connect-PnPOnline $SiteURL -Interactive 
#Try to Fetch the List 
$List = Get-PnPList -Identity $ListName 
#cmdlets to disable the Quick Edit in SharePoint Online
$List.DisableGridEditing = $True
$List.Update()
Invoke-PnPQuery

After this Quck Feature is Disabled! Woohoo! You have successfully disabled it.

Conclusion

This blog discusses all the steps and methods to solve your query regarding how to enable quick editing in SharePoint Online. However, we have also mentioned the PowerShell method to enable this feature and provided a command to check whether any view or classic list is interrupting the enabling of this feature. Additionally, we have discussed the steps and processes to disable quick editing and PowerShell commands to automate the process.