Create, change, or delete a column in a list or library

Columns help your group categorize and track information, such as the department name or project number. You have several options for the type of column that you create, including a single line of text, a drop-down list of options, a number that is calculated from other columns, or even the name and picture of a person on your site.

What do you want to do?

Create a column

Change the settings for a column

Delete a column

Create a column

Note   The following procedure begins from the list or library page to which you want to add the column. If the list or library is not already open, click its name on the Quick Launch. If the name of your list or library does not appear, click View All Site Content, and then click the name of your list or library.

  1. On the Settings menu settings menu, click Create Column.

  2. In the Name and Type section, type the name that you want in the Column name box.

  3. Under The type of information in this column is, select the type of information that you want to appear in the column.

  4. In the Additional Column Settings section, type a description in the Description box to help people understand the purpose of the column and what data it should contain. This description is optional.

  5. Depending on the type of column that you selected, more options may appear in the Additional Column Settings section. Select the additional settings that you want.

  6. To add the column to the default view, which people on your site automatically see when they first open a list or library, click Add to default view.

  7. Click OK.

Top of Page

Change the settings for a column

You can change the settings for a column, such as the name of the column. Depending on the type of column and the type of list, you can make additional changes, such as the amount of text a user can enter.

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

    If the name of your list or library does not appear, click View All Site Content, and then click the name of your list or library.

    1. Do one of the following:

      • On the Settings menu settings menu, click List Settings or the settings option that you want.

      • On a blog site, under Admin Links, click Manage Posts to display the posts list. On the Settings menu, click List Settings.

  2. Under Columns, click the name of the column that you want to change.

  3. Change the settings that you want, and then click OK.

Note   You can specify that a column is indexed, which can make it faster to switch views of lists or libraries that span multiple folders. To view the settings for a list or library, on the main page for customizing settings, click Indexed Columns. Select the column that you want to index, and then click OK.

Top of Page

Delete a column

Important   This procedure deletes the column and any data in the column.

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

    If the name of your list or library does not appear, click View All Site Content, and then click the name of your list or library.

    1. Do one of the following:

      • On the Settings menu settings menu, click List Settings or the settings option that you want.

      • On a blog site, under Admin Links, click Manage Posts to display the posts list. On the Settings menu, click List Settings.

  2. Under Columns, click the name of the column that you want to delete.

  3. Click Delete.

    You may need to scroll to the bottom of the page to see the Delete button.

  4. When you are prompted with a warning and if you are sure that you want to delete the column, click OK.

Note   Lists and libraries contain certain required columns that can't be deleted, such as the Title or Name column. If the column cannot be deleted, the Delete button is not available. If you cannot delete a column, but you do not want the column to appear in a view, you can hide it. Find links to more information about hiding columns in the See Also section.

Top of Page

Applies To: SharePoint Server 2007, SharePoint Server



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language