HomeGoogleGoogle SheetsSorting cells by text, number, and date

13.4. Sorting cells by text, number, and date

Directions: There are four options to view the resources below: try it, view it, watch it, or print it. Click the drop down menu titled "Try-It Interactive" to select your preferred viewing method. Then, click start.


11 STEPS

1. The first step is to open yoru desired sheet and find the data you want to sort.

Step 1 image

2. Click and highlight the cells you want to sort (a nice short cut is to click the first cell, hold "Shift", and click the last cell; all cells in between will highlight)

Step 2 image

3. Click Data

Step 3 image

4. Click Sort range by A-Z to organize Alphabeitcally.

Step 4 image

5. To sort by number from least to greatest, you follow the same process. Highlight your desired cells first.

Step 5 image

6. Click Data

Step 6 image

7. Click Sort range by A-Z to organize from smallest to largest number OR Z-A for largest to smallest number.

Step 7 image

8. It is a similar process for dates highlight your desired date cells.

Step 8 image

9. With your mouse, click Data

Step 9 image

10. Click Sort range by Columb A-Z for earliest to latest dates, or Z-A for latest to earliest dates.

Step 10 image

11. That's it. You're done. You now know the basics of sorting numbers, dates, and text.

Step 11 image

Here's an interactive tutorial

https://www.iorad.com/player/1737439/Google-Sheets---Sorting-cells-by-text--number--and-date



Downloads

Knowledge Tags