如果您已有电子表格，并且需要在Microsoft Excel或Excel Online中按日期对数据进行排序，则可以按照此分步指南进行操作。您不必使用任何函数或公式^{(use any function or formula)}来根据您的要求对数据进行排序。

Excel中如何按日期排序

要在Microsoft Excel^{(Microsoft Excel)}中按日期对数据进行排序，请执行以下步骤 -

1. 使用 Excel 打开电子表格。
2. 用鼠标选择日期列。
3. 单击排序和筛选^{(Sort & Filter)}按钮。
4. 选择从最早到最新或从最新到最旧^{(Newest to Oldest)}排序^{(Sort Oldest to Newest)}。
5. 选择展开选择^{(Expand the selection)}。
6. 单击排序^(Sort)按钮。

让我们详细检查这些步骤。

在您的计算机上使用Microsoft Excel打开电子表格。之后，您应该会看到一个包含所有日期的列。您需要选择所有具有日期的单元格。换句话说，您不应该选择标题行。

然后，确保您位于“主页”^(Home)选项卡中。如果是这样，您可以看到一个名为Sort & Filter的按钮。单击此按钮后，您应该单击从最旧到最新^{(Sort Oldest to Newest )}排序或从最新到最旧排序^{(Sort Newest to Oldest)}选项。

由于必须根据日期列更改电子表格的其他数据，Microsoft Excel应在此时向您显示警告。您需要确保选择了展开选择^{(Expand the selection )}选项。如果是，您可以单击排序^{(Sort )}按钮。

现在，您的日期应该按日期排序。

如何在Excel Online中按日期对数据进行排序^{(Excel Online)}

要在Excel Online^{(Excel Online)}中按日期对数据进行排序，请执行以下步骤 -

1. 使用 Excel Online 打开电子表格。
2. 按Ctrl+ A选择整个电子表格。
3. 单击主页^(Home)选项卡中的排序和筛选^{(Sort & Filter)}按钮。
4. 选择自定义排序^{(Custom Sort)}选项。
5. 在我的数据有标题^{(My data has headers)}框中打勾。
6. 选择日期列、单元格值^{(Cell Values)}和升序排序^{(Sort Ascending)}或降序排序^{(Sort Descending)}。
7. 单击确定^(OK)按钮。

继续阅读以了解有关这些步骤的更多信息。

首先，使用Excel Online打开电子表格并选择整个工作表。如果您不知道该过程，可以按照我们的Microsoft Excel 提示和技巧^{(Microsoft Excel tips and tricks)}指南了解。

现在，确保您位于“主页”^{(Home )}选项卡中。在这里，您可以找到一个名为Sort & Filter的选项。单击此按钮后，您需要选择自定义排序^{(Custom Sort )}选项。

之后，从“列”列表中选择日期列，从“^{(Column )}排序^{(Sort On )}依据”列表中选择“单元格值^{(Cell Values)}”，然后从“顺序^(Order)”列表中选择“升序排序^{(Sort Ascending )}”或“降序排序^{(Sort Descending)}” 。最后，单击确定^{(OK )}按钮。

您的数据应按日期排序。

就这样！希望能帮助到你。

How to Sort by Date in Excel

If you already have a spreadsheet and you need to ѕort dаta by date in Microsoft Excel or Excel Online, you can follow this step by step guide. You do not hаve to use any function or formula to sort data as per your requirements.

How to Sort by Date in Excel

To sort data by dates in Microsoft Excel, follow these steps-

1. Open the spreadsheet with Excel.
2. Select the date column with your mouse.
3. Click the Sort & Filter button.
4. Select Sort Oldest to Newest or Newest to Oldest.
5. Select Expand the selection.
6. Click the Sort button.

Let’s check out these steps in detail.

Open the spreadsheet with Microsoft Excel on your computer. After that, you should see a column containing all the dates. You need to select all the cells that have a date. In other words, you should not choose the header row.

Then, make sure that you are in the Home tab. If so, you can see a button called Sort & Filter. After clicking this button, you should click the Sort Oldest to Newest or Sort Newest to Oldest option.

As the other data of the spreadsheet must be changed according to the date column, Microsoft Excel should show you a warning at this point. You need to ensure that the Expand the selection option is selected. If yes, you can click the Sort button.

Now, your date should be sorted by date.

How to sort data by date in Excel Online

To sort data by date in Excel Online, follow these steps-

1. Open spreadsheet with Excel Online.
2. Press Ctrl+ A to select the whole spreadsheet.
3. Click the Sort & Filter button in the Home tab.
4. Select the Custom Sort option.
5. Make a tick in the My data has headers box.
6. Select the date column, Cell Values, and Sort Ascending or Sort Descending.
7. Click the OK button.

Read on to know more about these steps.

At first, open the spreadsheet with Excel Online and select the whole sheet. In case you do not know the process, you can follow our Microsoft Excel tips and tricks guide to know.

Now, make sure that you are in the Home tab. Here you can find an option called Sort & Filter. After clicking this button, you need to select the Custom Sort option.

After that, choose the date column from the Column list, select Cell Values from Sort On list, and choose Sort Ascending or Sort Descending from the Order list. At last, click the OK button.

Your data should be sorted by date.

That’s all! Hope it helps.

Related posts

• 如何在Excel and Google Sheets中显示Current Date and Time

• 如何将Serial Number转换为Excel中的Serial Number至Date

• Excel中如何按日期排序

• 快速将日期和时间戳添加到 Excel 工作表

• 如何在Excel中使用Percentile.Exc function

• 如何在Excel中使用DCOUNT and DCOUNTA Function

• 如何在Excel中使用INT and LCM Functions

• 如何在Excel中使用ISODD function

• 如何在Excel中创建Organization Chart

• Excel中Mean的Calculate Standard Deviation and Standard Error

• 如何在Excel中添加Country or Area Code至Phone Number List

• 如何在Excel中使用Rept Function

• 如何将一列拆分为Excel中的多列

• 如何在Excel使用EDATE and EOMONTH Functions

• 如何在Windows 11/10中创建Tournament Bracket

• 如何更改Excel worksheet Tab的颜色

• 如何计算在Excel的Yes or No entries数

• 如何使用NETWORKDAYS function在Excel

• 如何在Excel创建和使用Form Controls

• 如何在Excel中使用DGET function