excel日期怎么间隔填充

excel日期怎么间隔填充

If you're entering dates on an Excel worksheet, you don't have to enter each date individually. Just enter the first date, in the top cell. Then, if there is data in the next column, you can use the Fill handle to quickly enter the rest of the dates. See how to AutoFill Excel dates in series or same date, with just a couple of clicks.

如果要在Excel工作表上输入日期，则不必分别输入每个日期。 只需在顶部的单元格中输入第一个日期即可。 然后，如果下一列中有数据，则可以使用“填充”手柄快速输入其余日期。 只需单击几下，即可了解如何自动填充Excel系列或同一日期的日期。

Enter the first date in the date column -- cell A2 in this example. Then point to the Fill handle, which is the small black square at the bottom right corner of the selection.

在日期列中输入第一个日期-在此示例中为单元格A2。 然后指向“填充”手柄，该手柄是所选内容右下角的黑色小方块。

When the pointer changes to a small black plus sign, double-click.

当指针变为黑色小加号时，请双击。

When you double-click the Fill handle, Excel automatically fills the dates down to the first blank cell in the next column.

当您双击“填充”手柄时，Excel会自动将日期向下填充到下一列中的第一个空白单元格。

By default, the dates are entered in a series of 1 day intervals.

默认情况下，日期以一系列的1天间隔输入。

If you want all the date cells to have the same date, do one more step:

如果希望所有日期单元格都具有相同的日期，请再执行一步：

That is the keyboard shortcut for Fill Down. When you use that shortcut, Excel copies the date from the active cell (cell A2), into all the selected cells below.

那是Fill Down的键盘快捷键 。 当您使用该快捷方式时，Excel将日期从活动单元格(单元格A2)复制到下面的所有选定单元格中。

To see the steps for filling the dates, watch this very short video. The video shows how to create a date series with the Fill handle. Then it shows how to use a keyboard shortcut, to enter the same date in all the selected cells.

要查看填写日期的步骤，请观看此简短视频。 该视频显示了如何使用“填充”手柄创建日期系列。 然后说明如何使用键盘快捷键在所有选定的单元格中输入相同的日期。

I created this with the latest version of Camtasia Studio, which has a new feature that captures keyboard shortcuts, and can show the key combinations in the video.

我使用最新版本的Camtasia Studio创建的，它具有捕捉键盘快捷键并可以在视频中显示按键组合的新功能。

演示地址

See more Excel keyboard shortcut on my Contextures website. There is an interactive list of shortcuts that you can search and filter. You can also download an Excel workbook with a list of shortcuts.

在我的Contextures网站上查看更多Excel 键盘快捷键 。 有一个交互式的快捷方式列表，您可以搜索和过滤。 您还可以下载带有快捷方式列表的Excel工作簿。

______

______

翻译自: https://contexturesblog.com/archives/2010/05/19/autofill-excel-dates-in-series-or-same-date/

excel日期怎么间隔填充