1
reader helped!

This helped me

How to Sort by Date on Google Sheets on iPhone or iPad

This How.com.vn teaches you how to sort a group of dates in the Google Sheets app for iPhone and iPad.

Steps

  1. How.com.vn English: Step 1 Open Google Sheets.
    It's the app with the icon that resembles a green document with a table in the middle.
  2. How.com.vn English: Step 2 Open a Google Sheets document.
    Tap an existing Google Sheets document associated with your account to open it.
    • You can also tap
      How.com.vn English: Android Google New
      to create a new blank spreadsheet.
  3. How.com.vn English: Step 3 Select a range of cells with dates.
    Select any additional cells you want to sort with the dates. Dates should be typed in mm/dd/yyyy format. You can select a range of cells in several ways:
    • Tap the letter at the top of a column to select an entire column.
    • Tap the numbers to the left to select an entire row.
    • Tap the empty gray cell in the top-left corner to select the entire sheet.
    • Tap a specific cell, then drag the blue dot (handle) in the corner to expand the selection.
  4. How.com.vn English: Step 4 Tap ⋯.
    It's the three-dot icon in the top-right corner. This opens a drop-down menu.
  5. How.com.vn English: Step 5 Tap Create a filer.
    It's near the middle of the drop-down menu, just under the "Explore" option.
    • If you manually selected your range of cells by dragging the selection earlier, the top-most cell will be designated the filter's title and will not be sorted.
  6. How.com.vn English: Step 6 Tap the green triangle.
    It's the green triangle icon with three lines above the dates. This will open the filter menu.
  7. How.com.vn English: Step 7 Tap a sorting option.
    Tap one of the following sorting options under the "Sort and filter" menu:
    • A→Z: This will sort the dates in chronological order (oldest dates to newest dates).
    • Z→A: This will sort the dates in reverse-chronological order (newest dates to oldest dates).
    Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit

      Advertisement

      About this article

      How.com.vn English: Travis Boylls
      Written by:
      How.com.vn Technology Writer
      This article was co-authored by How.com.vn staff writer, Travis Boylls. Travis Boylls is a Technology Writer and Editor for How.com.vn. Travis has experience writing technology-related articles, providing software customer service, and in graphic design. He specializes in Windows, macOS, Android, iOS, and Linux platforms. He studied graphic design at Pikes Peak Community College. This article has been viewed 17,004 times.
      How helpful is this?
      Co-authors: 3
      Updated: May 15, 2018
      Views: 17,004
      Article SummaryX

      1. Open Google Sheets.
      2. Open a Google Sheets document.
      3. Select a range of cells that include dates.
      4. Tap
      5. Tap Create a filter.
      6. Tap the green triangle icon above the dates.
      7. Tap A→Z, or Z→A under Sort and filter.

      Did this summary help you?

      Thanks to all authors for creating a page that has been read 17,004 times.

      Is this article up to date?

      ⚠️ Disclaimer:

      Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
      Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.

      Notices:
      • - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
      • - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
      • - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
      • - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.

      Advertisement