Export (0) Print
Expand All
ABS
AND
ASC
COS
DAY
DDB
EXP
FV
IF
INT
LEN
LN
LOG
MAX
Me
MID
MIN
MOD
NOT
IS
NPV
ODD
OR
PI
PMT
PV
SIN
SLN
SUM
SYD
T
TAN
VAR
Expand Minimize

Add, edit, or delete a column

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Do one of the following:

Add a column

  1. On the top link bar, click Documents and Lists .

  2. On the Documents and Lists page, click the list, document library, or discussion board in which you want to add a column.

  3. On the page that displays the list, document library, or discussion board, click Modify settings and columns .

  4. In the Columns section, click Add a new column .

  5. In the Name and Type section, in the Column name box, type a name for the column.

  6. Select the type of information you want to display in this column.

    Note: For more information about column types, see Information types and options .

  7. In the Optional Settings for Column section, specify the settings you want.

  8. At the bottom of the page, click OK .

Edit a column

  1. On the top link bar, click Documents and Lists .

  2. On the Documents and Lists page, click the list, document library, or discussion board in which you want to edit a column.

  3. On the page that displays the list, document library, or discussion board, click Modify settings and columns .

  4. In the Columns section, under Column (click to edit) , click the name of the column you want to change.

  5. In the Name section, in the Column name box, you can change the column name.

  6. Click the appropriate option button to change the type of information this column contains.

    Note: Some types of data cannot be converted when you change a column type. For example, if you change a column with multiple lines of text into a number column, the existing text data is lost.

  7. In the Optional Settings for Column section, you can change the settings.

  8. At the bottom of the page, click OK .

Delete a column

  1. On the top link bar, click Documents and Lists .

  2. On the Documents and Lists page, click the list, document library, or discussion board in which you want to delete a column.

  3. On the page that displays the list, document library, or discussion board, click Modify settings and columns .

  4. In the Columns section, under Column (click to edit) , click the name of the column you want to delete.

  5. At the bottom of the page, click Delete .

    Note: There are certain built-in columns, such as Title, that you cannot delete.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft