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 tab.


2.

Click the Freeze Rows button and select how many rows you want to include as the spreadsheet's header, as shown in Figure 20. (In most cases, it's just one row.) When you freeze a header row, it no longer scrolls with the rest of the spreadsheetand is not included in any sort.

Figure 20. Choosing which rows to freeze.


3.

Identify which column you want to sort by, and move the cursor to any cell within that column.

4.

To sort in ascending order, click the A>Z button; to sort in descending order, click the Z>A button.

The A>Z and Z>A sorts don't just sort by letter; they also sort by number. An A>Z sort will arrange numerical data from smallest to largest; a Z>A sort will arrange numerical data from largest to smallest.




Using Google Spreadsheets
Using Google Spreadsheets
ISBN: B000P28WL2
EAN: N/A
Year: 2007
Pages: 78

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net