Sort or filter the rows in a worksheet in order to make it easier to browse the rows or find a specific item.

Please note that you can sort or filter rows only in the following types of worksheets:

• The Project Tags, Shared Tags, and System Tags datasheets;
• The Translation Table worksheet;
• All task worksheets except Report and Script, which do not have rows; and
• All communication worksheets.

None of the other worksheets have rows to sort or filter.

Sorting is done alphanumerically, by the selected column, in either ascending (0–9, A–Z) or descending (Z–A, 9–0) order.

Figure 1. Alarm worksheet rows in their original order

Figure 2. Alarm worksheet rows sorted by Type

Filtering is done according to whatever string you enter in the selected column. Only the rows that match the string will be displayed.

Figure 3. Alarm worksheet rows filtered where Tag Name is “Tag3″

Figure 4. Alarm worksheet rows filtered where Type is “Lo”

Tip: You can still delete rows while they are sorted or filtered.

To sort or filter rows:

1. To sort the rows, click the header of the column by which you want to sort. Click once to sort in ascending order, and then click again to sort in descending order. The current order (i.e., the direction of the sort) is indicated by the arrow to the right of the column name.
   Note: You cannot sort by multiple columns.
2. To undo the sorting and restore the rows to their original order, click the header of the first (numbered) column.
3. To filter the rows, type the string that you want to match in the top (zero) row of the worksheet and then press either Tab or Return.
   You may include * and ? as wildcard characters in your string:

   • * matches any number of characters, including none. For example, Tag* would match Tag, Tag3, Tag34567, TagA, and Tag_TEMP.
   • ? matches exactly one character. For example, Tag? matches Tag3 and TagA, while Tag????? matches Tag34567 and Tag_TEMP.

   Also, you may filter by multiple columns. Only the rows that match the filter strings in all columns will be displayed.

4. To undo the filtering and restore the rows to their original order, delete the string that you typed and then press either Tab or Return.