Using Google™ Spreadsheets

Section 7. Sorting Data

Often, you want your data to appear in a sorted order. You might want to sort your data by date, for example, or by quantity or dollar value. Fortunately, Google Spreadsheets lets you sort your data either alphabetically or numerically, in either ascending or descending order.

Executing a Sort

Sorting data in Google Spreadsheets is a two-step operation. You first have to "freeze" the header row(s) of your spreadsheet, then you identify the column by which you want to sort. Google will then order all the "unfrozen" (non-header) rows of your spreadsheet in whichever order (ascending or descending) you specified.

Here's how to do it:

1. Click the Sort tab, as shown in Figure 19.

   Figure 19 Getting ready to sort via the Sort ...