Delete a column in a list or library

Delete a column in a list or library

Microsoft SharePoint list columns help you group, categorize, and track information, such as department names and project IDs. You can modify the columns in lists and libraries, and when you no longer need a column in a list or library, you can delete it. Or you can delete a site column from SharePoint. If you're using Microsoft Teams, see Get started with Lists in Microsoft Teams.

  1. Go to the list or library that you want to delete a column from.

    Or from a SharePoint site, select Settings Settings button from SharePoint Online , Site Contents, and then select the name of your list or library.

  2. Select the column header for the column that you want to delete, and from the menu, select Column settings > Edit.

    The Edit column pane in SharePoint with the Delete option selected

  3. At the bottom of the Edit Column pane, select Delete.

  4. To delete the column and the data in the column permanently, select Delete.

    Note: Lists and libraries contain required columns that can’t be deleted, such as the Title or Name. If the column can’t be deleted, the Delete button is not available. To hide the column, select the column header, then Column settings and then Hide this column.

  1. Go to the list or library.

  2. For example, from a SharePoint site, select Settings > Site Contents, and then select the name of your list or library.

  3. On the ribbon, select the List or Library tab.

  4. In the Settings group, select List Settings or Library Settings.

  5. On the List Settings or Library Settings page, in the Columns section, select the name of the column that you want to delete.

  6. Scroll to the bottom of the Change Column pane, and then select Delete

  7. To delete the column and the data in the column permanently, select OK.

    Note: Lists and libraries contain required columns that can’t be deleted, such as the Title or Name. If the column can’t be deleted, the Delete button is not available. If you can’t delete a column, but you don’t want the column to appear in a view, you can hide it from the view.

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×