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

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.


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.


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.

Most View
Microsoft SharePoint 2010 Web Applications : Presentation Layer Overview - Ribbon (part 1)
The Cyber-athletic Revolution – E-sports’ Era (Part 1)
Windows Server 2003 : Implementing Software Restriction Policies (part 4) - Implementing Software Restriction Policies - Creating a Path Rule, Designating File Types
Sql Server 2012 : Hierarchical Data and the Relational Database - Populating the Hierarchy (part 1)
Two Is Better Than One - WD My Cloud Mirror
Programming ASP.NET 3.5 : Data Source-Based Data Binding (part 3) - List Controls
Windows 8 : Configuring networking (part 5) - Managing network settings - Understanding the dual TCP/IP stack in Windows 8, Configuring name resolution
Nikon Coolpix A – An Appealing Camera For Sharp Images (Part 2)
Canon PowerShot SX240 HS - A Powerful Perfection
LG Intuition Review - Skirts The Line Between Smartphone And Tablet (Part 2)
Popular Tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 Adobe Indesign Adobe Flash Professional Dreamweaver Adobe Illustrator Adobe After Effects Adobe Photoshop Adobe Fireworks Adobe Flash Catalyst Corel Painter X CorelDRAW X5 CorelDraw 10 QuarkXPress 8 windows Phone 7 windows Phone 8 BlackBerry Android Ipad Iphone iOS
Top 10
Review : Acer Aspire R13
Review : Microsoft Lumia 535
Review : Olympus OM-D E-M5 Mark II
TomTom Runner + MultiSport Cardio
Timex Ironman Run Trainer 2.0
Suunto Ambit3 Peak Sapphire HR
Polar M400
Garmin Forerunner 920XT
Sharepoint 2013 : Content Model and Managed Metadata - Publishing, Un-publishing, and Republishing
Sharepoint 2013 : Content Model and Managed Metadata - Content Type Hubs