programming4us
programming4us
MOBILE

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

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
11/20/2014 3:37:09 AM

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.

Image

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.

Image

>>>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.

Image

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.

Image

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

Image
Other  
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
REVIEW
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
programming4us
 
 
programming4us