Setting sort options in a list view in SharePoint Workspace 2010

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

To set sorting options in a list view:

  1. Enter the Designer.

  2. Click the list view in which you want to set sorting options.

  3. Click the Sort and Group tab.

  4. Click the column field to which you want to apply a sort.

  5. Check sorting options as follows:

    • To sort all list items in ascending or descending order, check Sort these values, and then select the sort order you want.

    • To set a secondary sort order, check Then sort by, click a field in the drop-down menu, and then select the sort order you want.

    • To force all items to be sorted into a flat view without hierarchies, check List all items, including Response items, in a flat view without hierarchies.

      This sort type is useful in cases in which you simply want to show all items in ascending or descending order, and ignore parent/child relationships among items.

    • To group items with the same value, check Group items with the same value into an expandable section.

      Additionally, you can sort items within each group according to a secondary sort.

      In the example below, the "Food Group" field is checked as the primary sort in ascending order, and the "Item Type" is checked as the secondary sort in descending order. Additionally, "Food Group" field is set for grouping same values into an expandable section. Finally, the "Food Group" column is set to show a twisty: On the Columns tab, the option Show a twisty in this column when this row is expandable is checked.

      A grouped sort with a secondary sort column

      If you are grouping items according to a Date/Time field, click the Group Dates By menu, and then click the time value you want.

  6. If you want the view to open with the currently selected sort options check Make this the default sort when the view is first opened.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.