To change the way you see the data on a worksheet. If you are trying to see if you left out any names from an employee list, it is much easier to check the list if it is sorted alphabetically.
Assuming "XLS" means MS Excel, you can import your XML data to Excel, then filter or sort as desired.
You can interrogate data in Excel 2007 by using the filter and sort options in Excel. This re-organizes the data in a way that makes it easy to analyze and evaluate the data.
To sort alphanumeric data like "P15-033-1" in Excel, first ensure the data is in a single column. Select the column, then go to the "Data" tab and click on "Sort." In the sort dialog, you can choose to sort by the column containing your alphanumeric data, and select either "A to Z" or "Z to A" for the desired order. Excel will sort the data based on the alphanumeric characters, treating numbers and letters appropriately.
You are able to sort linked data within any Excel document. If an error does occur check each columns formula so there Is agreement.
It can sort all standard data that can be entered into a spreadsheet. So it can sort numbers, dates, text and logical data (True/False).
The Data menu.
no only data can be sort from the excel sheet.. not in the file
The Sort feature.
Answer======> Ascending
Alphabetically?Go to data, then sort then ckick okay.Chat with me for more info.
Select Custom Sort and add as many sort levels as you like.
The sort feature allows you to look at the same data in different orders depending upon what information you seek. Excel allows you to sort by date, sort by text or numbers, sort by multiple columns, like listing values from highest to lowest or names in alphabetical order.