How to: Add or Remove Columns in the Work Item List

Work item lists within Microsoft Excel include a Column Chooser dialog box. This dialog box lets you add, remove, and arrange the data fields that you want to display in the list. The following procedures describe how to add, arrange, and remove data columns in a work item list within Microsoft Excel. For more information, see Working with Work Item Lists in Microsoft Excel.

Required Permissions

To perform these procedures, you must be a member of the Readers group or have the View work items in this node permission set to Allow. For more information, see Team Foundation Server Permissions.

To add and arrange data columns in the work item list

  1. Open or create a work item list within Microsoft Excel.

    For more information, see How to: Create a Work Item List.

  2. On the Team menu, click Choose Columns.

    The Choose Columns dialog box appears.

    Note

    In Microsoft Office Excel 2007, the Team menu is located on the Add-Ins tab on the ribbon.

  3. In Work Item Type, choose the type of items that you want to pick data columns for, the default is All Work Item Types. This option filters the types of columns that are displayed under Available Columns.

  4. In Available Columns, either click the data column that you want to include and then click > (Add). You may also click Add Required to include those columns that are required for the work item.

    The required columns associated with the work items types are marked (Required).

    Note

      Click Reset to restore the dialog box to its original column selections.

  5. In Selected Columns, highlight any data columns that you want to change the order for and then click the up or down arrow as appropriate.

    The order of the columns listed in the list box will be reflected in the Microsoft Excel list.

  6. Click OK.

    The Microsoft Excel spreadsheet will reflect the changes.

To remove data columns in the work item list

  1. Open or create a work item list within Microsoft Excel. For more information, see How to: Create a Work Item List.

  2. On the Team menu, click Choose Columns.

    The Choose Columns dialog box appears.

    Note

    In Microsoft Office 2007, the Team menu is located on the Add-Ins tab on the ribbon.

  3. In Selected Columns, either click or highlight the data columns that you want to remove from the list box and then click < (Remove). You may also click Add Required to add columns that are required for the work item.

    The required columns associated with the work items types are marked (Required) in Available Columns.

    Note

      Click Reset to restore the dialog box to its original column selections.

  4. In Selected Columns, highlight any data columns that you want to change the order for and then click the up or down arrow as appropriate. The order of the columns listed in the list box will be reflected in the Microsoft Excel list.

  5. Click OK.

    The Microsoft Excel spreadsheet will reflect the changes.

See Also

Other Resources

Working with Work Item Lists in Microsoft Excel