Change column options

Azure Boards | Azure DevOps Server 2019 | TFS 2018 | TFS 2017 | TFS 2015 | TFS 2013

Each column corresponds to a work item field. You can add and remove columns from work item lists to show the fields of interest to you. Or, you can drag a column to a new position. Your settings persist for each page you customize and are only valid for your views.

Specifically, you can perform the following actions from the following list views:

Action Backlogs Sprint backlogs Queries Work items
Add or remove a column field Yes Yes Yes Yes
Add or remove a rollup column Yes No No No
Sort on a column No No Yes Yes
Action Backlogs Sprint backlogs Queries Work items
Add or remove a column field Yes Yes Yes Yes
Sort on a column No No Yes Yes
Action Backlogs Sprint backlogs Queries
Add or remove a column field Yes Yes Yes
Sort on a column No No Yes

Tip

Unlike a query result, you can't sort a backlog by a column. However, you can use the Create Query link on each backlog to create a query that you can sort on any field column you choose.

You can add most fields listed in the Work item field index. All fields defined within the project collection or organization are available for selection, even those fields that aren't used for your particular project. You can view the list of fields defined for your collection from Organization Settings>Process>Fields

You can add most fields listed in the Work item field index. All fields defined within the project collection or organization are available for selection, even those fields that aren't used for your particular project. If your project uses the Inherited process model, you can view the list of fields defined for your collection from Organization Settings>Process>Fields

You can add most fields listed in the Work item field index. All fields defined within the project collection or organization are available for selection, even those fields that aren't used for your particular project.

About persistence

Once you set the column options for a specific view, your settings persist until you change them. The following notes apply to specific views.

  • Column options you set for a backlog apply only to the active team and backlog. Options you set for the product backlog differ from the options you set for a portfolio backlog.
  • Column options you set for a Sprint backlog persist for all sprints you select until you change them.
  • Column options you set for a query persist when you save the query.
  • Column options you set for one of the supported Work items views persists for a specific view only, such as Assigned to me, Following, Mentioned, and so on.
  • Column options you set for a backlog apply only to the active team and backlog. Options set for the product backlog differ from those you set for a portfolio backlog.
  • Column options you set for a Sprint backlog persist for all sprints you select until you change them.
  • Column options you set for a query persist when you save the query. For Shared queries, your settings can get overwritten when someone else saves different column option settings.

Open Column options

Start by opening the Column Options dialog. If you don't see the option, choose the … and choose from the options provided.

Open column options

Open column options

Add or remove columns

In the Column options dialog, choose Add a column to add a field that isn't shown. To change the order of the fields, drag-and-drop the field where you want it within the set of selected fields. And, to remove a field, choose the delete icon.

Note

The following dialog is available from TFS 2018.2 and later versions.

Column options dialog

Find the field you want to add from the Available columns set and choose > (greater-than character) to move it into the Selected columns list. You can then change the order of the columns with the up arrow/down arrow up and down arrows. To remove a field, select it and then choose the < (less-than character).

Column options dialog, TFS

Add or remove rollup columns

Rollup columns can display progress bars or the sum of numeric fields of child items. You can add them to any product or portfolio backlog. To learn more, see Display rollup progress or totals.

Sort on a column

You can sort query results and Work items views. From the Column options dialog, choose Sorting. Add or remove a column field and drag and drop it into the order you want. Choose the up or down arrows to choose whether it sorts in ascending or descending order.

Column options, Sorting page dialog

Use keyboard shortcuts to change the column order, column width, or sort options

You can change the column order, column size, or sort options by using the following keyboard commands:

  • To change the column order, choose the field and drag it to a new location
  • To resize a column, choose the column divider to the right of the field and drag to a new location
  • For query results:
    • Add the field as a column in order to sort by that field
    • To sort by a column, hold down the shift key and click on the field
    • To reverse the sort order, shift-click on the field
    • To sort by multiple columns, shift-click on each column in the order you want to sort

For additional keyboard shortcuts, enter ? to display available shortcuts based on the page you're on.