How to arrange incremental dates in Excel
When working on Excel, editing and reformatting data on days, months and years is often required. Excel supports users with rich features to reformat the date, month, and year in the data table, such as customizing the incremental or descending timeline depending on the table's requirements.
Adjusting the mode of increase or decrease the time in Excel can immediately use the built-in feature in the Data tab. And in the Data tab, users can choose from a variety of tools to reformat the time data according to their discretion. In the following article, Network Administrator will summarize the ways to arrange incremental time in Excel.
- Summary of expensive shortcuts in Microsoft Excel
- Instructions for printing two-sided paper in Word, PDF, Excel
- You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!
We will proceed to reformat the Year of Birth column in the Excel data table as shown below.
Method 1:
In this list, click on any location of the time column, here is the Year of Birth, then click on the Data tab and select the item A> Z.
Soon, we will see the data in the Year of Birth column arranged in ascending order based on the year of birth data in the column.
Method 2:
Step 1:
Also at this interface, we click on the Data tab and then click on the Sort feature on the interface.
Step 2:
The interface of the Sort table appears. Here part Sort by we will enter the data to be processed as column Year of birth , Sort On is Values and Order section we will choose Oldest to Newest, to sort data on day, month, year on Excel. Then click OK below.
Soon the user will also get the results of the date, month and year data sorted in ascending order.
Method 3:
Step 1:
Also at the data table interface, we also click on the Data tab and then use the Filter feature to filter data on Excel.
Step 2:
In the time data column, click on the triangle icon and select Sort Oldest to Newest in the list that appears.
Finally we also get the Year of Birth column arranged in ascending order as shown in the table below.
Thus, in order to be able to reformat the date, month and year data in Excel in ascending order, you can use up to 3 different ways. The above methods also apply when the user needs to arrange the time in descending order, we just need to press Z> A with way 1 and select the Newest to Oldest for both way 2 and way 3. This is the basic and simple operation to perform, because you do not need the support of calculation functions, but immediately use the features available in Excel.
I wish you all success!
You should read it
- 14 time-saving tips when using Microsoft Excel
- Change the slash to a dot in Excel format
- Guide to full Excel 2016 (Part 8): Learn about Number Formats
- Instructions on how to fix reverse dates in Excel
- How to add units to cells in Excel
- Instructions for searching and replacing in Excel tables
- How to automatically update the Excel file editing time
- MS Excel 2003 - Lesson 3: Manipulating data in spreadsheets
- Instructions to stamp negative numbers in Excel
- Microsoft Excel test P5
- How to display 0 in front of a number in Excel
- MS Excel 2003 - Lesson 2: Format spreadsheet data
Maybe you are interested
How to get data from web into Excel
What information does a VPN hide? How does it protect your data?
How to transfer data between 2 Google Drive accounts
6 Data Collecting Apps You Need to Delete for Better Privacy
How to master numerical data in Google Sheets with the AVERAGE function
How to delete white space in a table in Word - Appears right below the data