Windows Phone 8 : Microsoft Office Mobile - Excel (part 6) - Sorting a Column, Filtering

Sorting a Column

Excel Mobile makes it easy to sort a column of data either alphabetically or numerically. To sort a column, follow these steps:

1. Tap the header for the column you want to sort.

2. Tap the Sort icon.

3. Verify that the Sort By field lists the appropriate column.

4. Tap the Sort Order field and choose either Ascending or Descending.

5. Tap the Exclude Header Row check box if your selection includes a header row that you don’t want to include in the sort.

6. Tap Done.

---

>>>Go Further: Multi Level Sorting

Just as you can sort a single column of data, Excel Mobile enables you to sort multiple columns. To do so, select more than one column before tapping the Sort button. Then, on the Sort screen, tap the More Options button, which enables you to include up to two more columns in your sorting criteria.

---

Filtering

Excel Mobile contains a powerful filtering mechanism that you can use to hide all the spreadsheet data except for the specific data you are interested in. You can filter spreadsheet data by completing these steps:

1. Tap a cell on the top row of the spreadsheet.

2. Tap the Menu icon.

3. Tap Apply Filter.

4. Tap the icon in the top cell of the column you want to filter.

5. Tap the desired filter options. The filter data should be the data that you want to view, while hiding everything else.

6. Tap Done.

7. All data is hidden except for the filter or filters you have selected.