Microsoft Excel Work Item List Types

Provides an overview of the different kinds of work item lists.

How to: Change Project Structure and Iterations in Microsoft Excel

Describes how to edit the project structure and iterations in Microsoft Excel.

How to: Create a Work Item List

Explains the steps used to create a work item within Microsoft Excel.

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

Describes how to use the column picker to choose which columns of data you want displayed for work items within Microsoft Excel.

How to: Connect a Work Item List to a Work Item Query

Explains the steps used to bind a work item list created in Microsoft Excel to a work item query within a team project.

How to: Change a Query List into an Input List

Describes how to change the refresh options for a work item list.

How to: Update a Work Item List from a Query

Describes how to update a work item list that is bound to a work item query.

How to: Remove Work Items in Microsoft Excel

Describes how to remove work items using Microsoft Excel.

How to: Change Multiple Work Items in Microsoft Excel

Describes how to make changes to several work items at once in Microsoft Excel.

How to: Work Offline in Microsoft Excel

Describes how to work on your work items in Microsoft Excel when not connected to the Team Foundation Server. 

Tasks

Other Resources