The easiest way to sort is to simply select any cell in the column you want to sort by and then click either the Sort Ascending or Sort Descending buttons in the Sort * Filter group of the Data tab on the Ribbon. The Sort Ascending button sorts from A to Z (it’s the one with A on top and Z on the bottom). Technically speaking, it sorts from zero to Z, but that wouldn’t make as good an icon. The Sort Descending button sorts from Z to A (okay, Z to zero), and it’s the one with Z on top and A on the bottom. Figure 19-14 shows data sorted in descending order by year.

FIGURE 19-14
Sort the list or table to change its order.

The drawback to this method, as with so many things that are simple to use, is that it lacks real power.

Often, you’ll find that you need to sort by more than one column. For instance, you might need to sort a customer database by both state and product ordered so you can determine which products are selling best in which states. Or you might want to sort the weather database by year and temperature.

To sort by multiple columns, follow these steps:

1. Select any cell in the list or table.
2. Select Data?Sort & Filter?Sort in the Ribbon. If you failed to select a cell in the database, Excel will tell you it can’t find it. In that case, go back to Step 1.
3. Specify sort levels in the Sort dialog box (see Figure 19-15). Click the Add Level button to
   specify each new sort level, then use the Column, Sort On, and Order drop-down lists to specify the field, type of cell information, and sort order for the sort.
4. Click the OK button to apply the sort.

FIGURE 19-15
Use this dialog box to set up a more advanced sort.

• How to Find IP Address on Computer [/caption]Each and every device that is connected to internet is associated with a unique number which is referred to as...
• Keyword Tool Supercharger The Google AdWords Keyword Tool is a great tool to help you identify popular keywords that can help with search...
• Restore Wordpress Database How to Restore your Wordpress Database The easy and secure way, using phpMyAdmin. A good backup copy of your database...
• Excel How-to: Creating a Pivot Table A pivot table is a merely a summary of data in a format that you can manipulate to suit your...
• Age Your Financial Attitude for Greater Happiness It seems that old, white male Republicans have an edge on happiness.  Before you go "ewwwwww - who wants to...