Sort and filter list

AutoFilter arrow will be automatically added to the top of the list header row.
Using the "list" command to create a list, will automatically list to add the AutoFilter arrow. In this lecture, you will learn how to use AutoFilter arrows to sort and filter the list data.
(A) how to sort
Click the "descending order" to see the latest orders.
AutoFilter arrow, just click on the column and select the Sort command in the menu that appears, you can sort any column in the list. The sort function by clicking the AutoFilter button is another new feature in MS Office 2010 in Excel.
Suppose you sort in descending on the "Date" column sort so that you can see the latest order, click the arrow on the "Date" header, and then click the "descending order" so that you can.
(B) How to screening
"Pankin in order to filter the list to only display Pankin sales.
As simple as the filter list data and sort the list data. Simply click the AutoFilter arrow and choose to. Excel 2010 will automatically display only the specified data. For example, you can filter by name to view Pankin all sales rather than sales for all. Alternatively, you can filter by date, to view a specific date sales and their sales staff. No matter which column of the specified data, Excel 2010 will display only the column, and a list of all the filtered rows in the other columns.
Can add to the list on the right, rather than add to the list on the left.
Using the "list" command, the worksheet can have more than one list. Can add or delete rows in a list, but not add or delete rows in the list next to it, this is a new feature in Excel 2010.
You can also use the "list" command for each list will automatically provide its own AutoFilter arrows on these lists alone to sort. Office Standard 2010 versions of Excel before, you can only have a list with an AutoFilter arrow. In Excel 2010, when you click on each list, can activate the AutoFilter arrow in the list.
Note, however, if you have a list of the two side by side, and filtered a list, another list looks like filtered AutoFilter to hide entire rows, rather than just hide the screening list line.