SharePoint Online and Microsoft Lists offers a multitude of features to enhance collaboration and streamline data management. One such feature is the Quick Property Editing (Edit in Grid view), which allows users to bulk edit metadata for multiple list items directly from the list view. While this feature can improve efficiency, there are scenarios where disabling it becomes necessary. In this blog post, we’ll explore various methods to achieve this in SharePoint Online.

From SharePoint UI

Follow below steps to disable quick edit (Edit in grid view) from SharePoint list UI:

1. Go to your SharePoint Online list.

2. Click on Settings (gear icon) from the top right corner and select List settings.

3. Click on Advanced settings link from List settings page.

4. From Advanced settings page, scroll down and set Quick property editing (Allow items in this list to be edited using Quick Edit and the Details Pane?) to No.

5. Click OK button at the bottom of advanced list settings page.

Using PnP PowerShell

You can use below PnP PowerShell script to disable Quick property editing (Grid view) from SharePoint Online list or document library:

# Display name of SharePoint online list or document library
$listName = "My SharePoint List"

# SharePoint online site URL
$siteUrl = Read-Host -Prompt "Enter your SharePoint site URL (e.g https://contoso.sharepoint.com/sites/pnppowershell)"

# Connect to SharePoint online site
Connect-PnPOnline -Url $siteUrl -Interactive

# Disable Quick property editing (Grid view) from SharePoint list
Set-PnPList -Identity $listName -DisableGridEditing $true

Write-Host "Done! :-)" -ForegroundColor Green

# Disconnect SharePoint online connection
Disconnect-PnPOnline

You can set -DisableGridEditing to $false to enable the quick edit (edit in grid view) back to your SharePoint list.

Using CLI for Microsoft 365

Use below CLI for Microsoft 365 script to disable Quick property editing (Edit in grid view) from SharePoint Online or Microsoft Lists:

# Display name of SharePoint online list or document library
$listName = "My SharePoint List"

# SharePoint online site URL
$siteUrl = Read-Host -Prompt "Enter your SharePoint site URL (e.g https://contoso.sharepoint.com/sites/cliformicrosoft365)"

# Get Credentials to connect
$m365Status = m365 status
if ($m365Status -match "Logged Out") {
    m365 login
}

# Disable Quick property editing (Grid view) from SharePoint list
m365 spo list set --webUrl $siteUrl --title $listName --disableGridEditing true

Write-Host "Done! :-)" -ForegroundColor Green

# Disconnect SharePoint online connection
m365 logout

You can set --disableGridEditing to false to enable the quick property editing (edit in grid view) for your SharePoint online list.

Learn more

• Enable or Disable the Return to Classic SharePoint link in SharePoint Online
• Set SharePoint site home page using PnP PowerShell and CLI for Microsoft 365
• Allow use of custom scripts in SharePoint Online using PowerShell
• SharePoint Online: Empty Recycle Bin using PnP PowerShell
• Enable or Disable the Social Bar (Like, Views, Save for later) for SharePoint sites

When you create a new list in SharePoint Online site, the list URL is automatically generated based on the name you provide while list creation. SharePoint uses a process called URL encoding to ensure that the URL is valid and does not contain any special characters that could cause problems.

URL encoding replaces special characters in the list name with a percent sign (%) followed by a code that represents the character. For example, if you create a list called My List & Tasks, SharePoint will encode the ampersand (&) as %26 and white space as %20 in the list URL. The resulting list URL will be something like:

https://<site-address>/Lists/My%20List%20%26%20Tasks/AllItems.aspx

There could be several reasons why you might want to change the SharePoint list URL after the list has been created. For example, removing special characters & their encoding (%26 or %20) from URL or changing it with short URL or to enhance the accessibility and usability of the list, by making it easier to remember or share with others. Whatever the reason, changing the SharePoint list URL should be done with caution, and only after careful consideration of the potential impact on the users and the overall system.

You can use below PnP PowerShell script to change SharePoint online list URL and rename the list after list creation:

# SharePoint online site URL
$siteUrl = "https://contoso.sharepoint.com/sites/SPConnect"

# Current display name of SharePoint list
$oldListName = "Images List"

# New list URL
$newListUrl = "Lists/LogoUniverse"

# New display name for SharePoint list
$newListName = "Logo Universe"

# Connect to SharePoint online site
Connect-PnPOnline -Url $siteUrl -Interactive

# Get the SharePoint list
$list = Get-PnPList -Identity $oldListName

# Move SharePoint list to the new URL
$list.Rootfolder.MoveTo($newListUrl)
Invoke-PnPQuery

# Rename List
Set-PnPList -Identity $oldListName -Title $newListName

Once you run above script successfully, you can navigate to SharePoint list using new URL:

Note: Changing the SharePoint list URL may have implications for any workflows, alerts, links referring to the list, or customizations that are associated with the list. So, it is recommended to test the changes in a non-production environment before implementing them in a live environment.

Learn more

• Update SharePoint Page Banner Image using PnP PowerShell
• SharePoint Online: Create a blank page without header & title
• Add/Update image columns in SharePoint/Microsoft Lists using PnP PowerShell
• SharePoint Online: How to change the placeholder text in the search box
• Enable/Disable SharePoint Online List Comments using PnP PowerShell