Delete a Column in Microsoft Lists

This guide shows you how to permanently remove a column from a Microsoft Lists view or the underlying list. You’ll learn the exact steps, what happens to the data in that column, and how to avoid common pitfalls. No special admin permissions are required—any member with edit rights can delete columns.

What You’ll Need

• A Microsoft Lists list where you have Edit or Full Control permissions (the default for members).
• Access to the list through the Microsoft Lists web app, Teams, or SharePoint.
• Confirmation that the column is not a system-required column (like Title or ID) and is not referenced by any list workflows or Power Automate flows that would break.

Step-by-Step

1. Open your list in Microsoft Lists (either from the Microsoft 365 app launcher, Teams, or SharePoint).
2. Click the column header of the column you want to delete. A drop-down menu appears.
3. Select Column settings (or Edit on some versions). This opens the column’s settings pane.
4. In the settings pane, scroll to the bottom and click Delete. A confirmation dialog appears.
5. Read the warning: it tells you that all data in the column will be permanently removed. If you’re sure, click Delete again.
6. The column disappears from the list immediately. If you were in a specific view, it’s removed from that view; if the column was part of the list’s core schema, it’s gone from all views.

Common Mistakes

• Deleting a column that has a lookup or choice dependency. Other lists or columns may reference it, causing errors. Always check for dependencies first.
• Confusing “Hide from view” with “Delete.” Hiding only removes it from the current view; the data stays. Deleting removes the column and its data permanently.
• Not saving a backup. If you might need the data later, export the list to Excel before deleting.
• Deleting a column that’s part of a list template or content type. This can affect other lists created from the same template.

Tips

• Before deleting, create a new view without the column to see how the list looks—this is a non-destructive way to test.
• If the column is used in a Power Automate flow, edit the flow first to remove references, then delete the column.
• Use the “Column settings” > “Edit” option to rename or change the column type if you only need to repurpose it—this avoids data loss.
• For a quick check, click the column header and select “Column settings” to see if the Delete option is greyed out—this indicates a system column that cannot be removed.

Troubleshooting

Delete option is greyed out or missing. This usually means the column is a system column (like Title) or you lack edit permissions. If you have edit rights and it’s still greyed, check if the column is part of a content type—you may need to remove it from the content type first.

Error when deleting: “Column is in use.” This indicates a dependency. Search for the column name in any Power Automate flows, Power Apps, or other lists’ lookup columns. Remove those references, then try again.

Column deleted but reappears. This can happen if the column is defined in a site content type that’s applied to the list. Go to the list settings, find the content type, and remove the column from that content type, then delete it again.

Data disappears but you need it back. If you have a backup (exported Excel file), you can re-create the column and import the data. Otherwise, check if the list has versioning—but note that column deletions are not typically recoverable via version history.

Frequently Asked Questions

Can I delete a column that has data in it?

Yes, but the data is permanently deleted. Be sure to export the list first if you might need that data later.

What’s the difference between deleting a column and hiding it?

Hiding a column removes it from the current view only—the data remains in the list. Deleting removes the column and all its data from the entire list.

Can I delete multiple columns at once?

No, Microsoft Lists does not support bulk deletion of columns. You must delete each column individually.

Will deleting a column affect other lists or apps?

If the column is used as a lookup column in another list, or referenced in Power Automate or Power Apps, those references will break. Check dependencies before deleting.

Can I undo a column deletion?

There is no built-in undo. Once deleted, the column and its data are gone. You can only recover by re-creating the column and manually re-entering data from a backup.

Why can’t I delete the “Title” column?

The Title column is a system-required column in most lists. You can rename it, but you cannot delete it. It’s used for the item’s display name and is essential for list functionality.

Related

• Axis Bank Digital Savings Account: Steps & Checks
• Ultrawide Monitor Not Detected: Fixes That Work
• Scrolling Screenshots in Firefox: Full-Page Capture Guide