Delete a column in a SharePoint list or library

Delete a column in a SharePoint list or library

SharePoint columns help you group, categorize, and track information, such as the department name or project number. There are columns for lists and libraries, just like there are columns for sites. If you're no longer using a list or library, you can delete it. (You can also delete a site column from SharePoint.)

  1. Go to the list or library.

    For example, 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.

    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.

  4. Select Delete to delete the column and the data in the column permanently.

  1. Go to the list or library.

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

  2. In the ribbon, select the List or Library tab.

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

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

  5. Scroll to the bottom of the Change Column pane and then 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. 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.

  6. Select OK to delete the column and the data in the column permanently.

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.

×