SharePoint Document Issues

How to Fix Missing Edit Option for SharePoint List Columns

Nimra MalikNimra Malik Oct 16, 2026 872 views

Question details

Users are unable to modify or delete certain SharePoint list columns because the Edit option is completely missing from the column dropdown menu.

How to Fix Missing Edit Option for SharePoint List Columns
Product
SharePoint
Device & OS
not provided
Scenario
Attempting to modify column properties or delete existing columns directly from a modern SharePoint list view.
Observed behavior
The 'Edit' option is visible in the dropdown menu for some list columns, but missing for others, preventing any modifications.
Before you start

Verify that you have 'Full Control' or 'Design' permissions for the SharePoint site and list, as restricted permission levels will hide administrative editing capabilities.

Solution 1Recommended

Modify System-Managed or Built-In Columns via List Settings

Use the backend List settings menu, as built-in SharePoint columns (like 'Title' or 'Created By') restrict direct editing and deletion from the modern frontend view.

SharePoint automatically generates several system columns when a list is created. These columns are structurally necessary and generally do not support direct deletion. Their context menus in the modern view often lack the 'Edit' or 'Delete' options.

To modify the properties of these columns (such as renaming them or making them optional), you must bypass the modern view and access the classic List Settings page.

1
Access Site Settings

Open your SharePoint list and click the Gear icon (Settings) located in the top right corner of the navigation bar.

2
Open List Settings

Select 'List settings' from the dropdown menu to open the backend configuration page.

3
Locate the Column

Scroll down to the 'Columns' section and click on the name of the column that is missing the Edit option.

4
Modify Column Properties

Adjust the available settings (like the column name or requirement rules) and click 'OK'. If the 'Delete' button is missing at the bottom of this page, the column is permanently locked by SharePoint.

Modify System-Managed or Built-In Columns via List Settings
Built-in Column Limitations: You cannot delete the default 'Title' column. However, you can rename it and set 'Require that this column contains information' to 'No' to hide it from standard data entry forms.
Free Microsoft Office alternative

Easily Manage Your Exported SharePoint Data with WPS Office

While SharePoint lists require a Microsoft 365 environment, you can easily manage, analyze, and edit all your exported list data offline using WPS Office. It provides a lightweight, highly compatible suite for spreadsheets and documents without the heavy subscription fees.

  1. 1. Export SharePoint Data: In your SharePoint list, click the 'Export' button on the top command bar and select 'Export to Excel' to download your list data as a .iqy or .xlsx file.
  2. 2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded spreadsheet file directly to view your list columns offline.
  3. 3. Analyze Offline: Use WPS Spreadsheet’s familiar formulas, sorting, and formatting tools to manage your data without relying on a browser.
Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formats.Easily format and analyze exported SharePoint list data using advanced pivot tables and formulas in WPS Spreadsheet.Completely free, lightweight, and features a familiar tabbed interface for seamless migration.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I delete the 'Title' column in my SharePoint list?

The 'Title' column is a built-in, required system column necessary for the structural integrity of a SharePoint list. While you cannot delete it, you can rename it or make it optional by going to List Settings, clicking on 'Title', and changing the 'Require that this column contains information' setting to 'No'.

Does JSON column formatting affect my ability to edit column settings?

Yes. Advanced JSON formatting applied to a column or view can alter how the interface behaves in the modern SharePoint experience, sometimes inadvertently overriding or hiding the default context menus. Temporarily removing the JSON code will typically restore the missing Edit option.

How do I edit a calculated column if the option is missing in the modern view?

If the Edit option is absent from the column header dropdown in the modern view, click the Gear icon, select 'List settings', scroll to the Columns section, and click the calculated column's name. You can safely update its parameters and formulas directly on that backend settings page.