How to Fix Missing Edit Option for SharePoint List Columns
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.

- 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.
Verify that you have 'Full Control' or 'Design' permissions for the SharePoint site and list, as restricted permission levels will hide administrative editing capabilities.
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.
Open your SharePoint list and click the Gear icon (Settings) located in the top right corner of the navigation bar.
Select 'List settings' from the dropdown menu to open the backend configuration page.
Scroll down to the 'Columns' section and click on the name of the column that is missing the Edit option.
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.

Remove Conflicting JSON Column Formatting
Clear custom JSON code applied to the column, which may override or break the default SharePoint context menus.
Check Features that Auto-Generate Columns
Identify if the column was generated by a Power Automate flow, Power Apps integration, or a Calculated/Lookup formula.
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. 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. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded spreadsheet file directly to view your list columns offline.
- 3. Analyze Offline: Use WPS Spreadsheet’s familiar formulas, sorting, and formatting tools to manage your data without relying on a browser.

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.




