Delete a column from a list or library

You can delete most columns in a list or library if you aren't going to need them again on the site. When you delete a column it also deletes any data it contains. Unlike a deleted document, this data cannot be restored. If you want to keep the column and data, but just not show it, see Show or hide columns in a list or library.

Note: To delete a column from a list or library you, must at least be a member of the default Designers SharePoint group for the site.

Note: SharePoint Designer offers extensive custom settings such as specifying column width. For more info see Create a custom list view using SharePoint Designer. SharePoint Designer is a developer tool, and not intended for end users.

Delete a column from a list or library

Important:  This procedure deletes the column and any data in the column. Once you delete a column, you cannot restore the column from the Recycle Bin.

  1. If the list or library is not already open, click its name on the page or in the Quick Launch.

    If the name of your list or library does not appear on a page, click settings Office 365 Settings button , click Site Contents, and then click the name of your list or library.

  2. In the ribbon, click the List or Library tab. The name of the tab may vary depending on the type of list or library. For example, if your list is a calendar, the name of the tab is Calendar.

    The library and browse tab on the ribbon
  3. In the Settings group, click List Settings or Library Settings.

    SharePoint Library Settings buttons on Ribbon
  4. On the List Settings or Library Settings page, in the Columns section, click the name of the column that you want to delete.

  5. Scroll to the bottom of the Change Column page and then click 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. When prompted, click OK to save.

To learn how to format the text under column headings in lists, see Format the text under column headings in lists.

To add a column to a list or library, see Create a column in a list or library.

To change settings on a column to a list or library, see Change a column in a list or library.

See Show or hide a column in a list or library on a page for the steps to show or hide a column in a list or library as an alternative to deleting a column.

See Manage lists and libraries with many items for the steps to manage a list or library with many items.

See Add, change, or delete a list or library on a page for the steps to add, change, or delete a list or library from a page on a site.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×