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
Open or create a work item list within Microsoft Excel.
For more information, see How to: Create a Work Item List.
On the Team tab, in the Work Items group, click Choose Columns.
The Choose Columns dialog box appears.
Note
In Microsoft Office Excel 2003, use the Team menu.
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.
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.
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.
Click OK.
The Microsoft Excel spreadsheet will reflect the changes.
To remove data columns in the work item list
Open or create a work item list within Microsoft Excel. For more information, see How to: Create a Work Item List.
On the Team tab, in the Work Items group, click Choose Columns.
The Choose Columns dialog box appears.
Note
In Microsoft Office Excel 2003, use the Team menu.
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 back the columns that are required for the work item.
The required columns associated with the work items types are bold in Available Columns.
Note
Click Reset to restore the dialog box to its original column selections.
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.
Click OK.
The Microsoft Excel spreadsheet will reflect the changes.