How to sort data increase / decrease by date on Excel - Blog knowledge sharing

    Note: Please read the article carefully before proceeding! If in the process of using you encounter any errors, such as broken download links, slow loading blog, or unable to access a certain page on the blog ... then please inform me here. Thanks!

    If you are an accountant, a human resource manager, or your job involves inventory of goods, etc., then determining the order of values ​​by date (ascending, descending) will Support us a lot in summarizing and setting group values, depending on your job requirements.

    Yes, and in today's Excel lesson, I will share with you a little trick on filtering and sorting values ​​by increasing, or descending by day - month - year on a spreadsheet using built-in filters. on Excel. Help you set up Excel spreadsheets more quickly and conveniently.

    Read more:

    #first. Sort data by increasing date

    + Step 1: First, open the Excel file you need to process.

    excel-to-format-data-excel-date-at-excel (1)

    + Step 2: Here, you create a selection of date data on the spreadsheet by bôi đen vùng dữ liệu as shown below => and then open the tab Data up => and select:

    • Sort A to Z (sorted in ascending order).
    • Sort Z to A (sorted in descending order).

    For example, here I will arrange in ascending order offline.

    excel-to-format-data-excel-date-at-excel (2)

    + Step 3: Dialog box Sort Warning displayed, you click on Expand the selection => then press Sort to execute.

    excel-to-format-data-excel-date-at-excel (3)

    Results: The dates in the spreadsheet have been sorted in ascending order, from the oldest to the youngest.

    excel-to-format-data-excel-date-at-excel (4)

    #2. Sort data by descending dates

    Similarly, to sort in descending order, you choose is Sort Z to A as shown below.

    excel-to-format-data-excel-date-at-excel (5)

    At the dialog box Sort Warning you ticked on Expand the selection => and click Sort.

    excel-to-format-data-excel-date-at-excel (6)

    Finally, we sorted the spreadsheet values ​​by descending date.

    excel-to-date-data-excel-format-format (7)

    # 3. Epilogue

    Okay that's it, I have detailed instructions for you How to use the Sort filter How to sort Excel worksheet data in date format in ascending or descending order simply, and easily.

    Here the tutorial article How to sort data by date in Excel, my would also like to pause. Hope this tip will be helpful to you.

    Good luck.

    CTV: Luong Trung - Blogchiasekienthuc.com

    Note: Was this article helpful to you? Do not forget to rate the article, like and share it with your friends and relatives!

    Không có nhận xét nào