vfp取得excel的句柄_如何使用填充句柄将顺序数据自动填充到Excel中

vfp取得excel的句柄

The Fill Handle in Excel allows you to automatically fill in a list of data (numbers or text) in a row or column simply by dragging the handle. This can save you a lot of time when entering sequential data in large worksheets and make you more productive.

Excel中的“填充手柄”使您只需拖动手柄即可自动在行或列中填充数据列表(数字或文本)。 在大型工作表中输入顺序数据时，这可以节省大量时间，并使您的工作效率更高。

Instead of manually entering numbers, times, or even days of the week over and over again, you can use the AutoFill features (the fill handle or the Fill command on the ribbon) to fill cells if your data follows a pattern or is based on data in other cells. We’ll show you how to fill various types of series of data using the AutoFill features.

如果数据遵循模式或基于以下内容，则可以使用“自动填充”功能(填充功能区上的填充手柄或“填充”命令)来手动填充数字，而不是一遍又一遍地手动输入数字，时间或一周中的几天。其他单元格中的数据。 我们将向您展示如何使用自动填充功能填充各种类型的数据系列。

将线性序列填充到相邻单元格中 (Fill a Linear Series into Adjacent Cells)

One way to use the fill handle is to enter a series of linear data into a row or column of adjacent cells. A linear series consists of numbers where the next number is obtained by adding a “step value” to the number before it. The simplest example of a linear series is 1, 2, 3, 4, 5. However, a linear series can also be a series of decimal numbers (1.5, 2.5, 3.5…), decreasing numbers by two (100, 98, 96…), or even negative numbers (-1, -2, -3). In each linear series, you add (or subtract) the same step value.

使用填充手柄的一种方法是将一系列线性数据输入到相邻单元格的行或列中。 线性序列由数字组成，其中下一个数字是通过在其前面的数字上添加“阶跃值”而获得的。 线性序列的最简单示例是1、2、3、4、5。但是，线性序列也可以是一系列十进制数(1.5、2.5、3.5…)，将数字减2(100、98、96) …)，甚至是负数(-1，-2，-3)。 在每个线性系列中，您要添加(或减去)相同的步长值。

Let’s say we want to create a column of sequential numbers, increasing by one in each cell. You can type the first number, press Enter to get to the next row in that column, and enter the next number, and so on. Very tedious and time consuming, especially for large amounts of data. We’ll save ourselves some time (and boredom) by using the fill handle to populate the column with the linear series of numbers. To do this, type a 1 in the first cell in the column and then select that cell. Notice the green square in the lower-right corner of the selected cell? That’s the fill handle.

假设我们要创建一列连续数字，在每个单元格中增加一个。 您可以键入第一个数字，按Enter键以转到该列的下一行，然后输入下一个数字，依此类推。 非常繁琐且耗时，尤其是对于大量数据。 通过使用填充手柄用线性数字序列填充列，我们将节省一些时间(和无聊)。 为此，请在该列的第一个单元格中键入1，然后选择该单元格。 请注意所选单元格右下角的绿色方块？ 那是填充句柄。

When you move your mouse over the fill handle, it turns into a black plus sign, as shown below.

将鼠标移到填充手柄上时，它将变为黑色加号，如下所示。

With the black plus sign over the fill handle, click and drag the handle down the column (or right across the row) until you reach the number of cells you want to fill.

在填充手柄上用黑色加号标记时，单击该手柄并将其向下拖动到列中(或在整个行中向右)，直到达到要填充的单元格数量。

When you release the mouse button, you’ll notice that the value has been copied into the cells over which you dragged the fill handle.

释放鼠标按钮时，您会注意到该值已复制到拖动填充手柄的单元格中。

Why didn’t it fill the linear series (1, 2, 3, 4, 5 in our example)? By default, when you enter one number and then use the fill handle, that number is copied to the adjacent cells, not incremented.

为什么不填充线性序列(在我们的示例中为1，2，3，4，5)？ 默认情况下，当您输入一个数字然后使用填充手柄时，该数字将被复制到相邻的单元格中，而不是递增。

NOTE: To quickly copy the contents of a cell above the currently selected cell, press Ctrl+D, or to copy the contents of a cell to the left of a selected cell, press Ctrl+R. Be warned that copying data from an adjacent cell replaces any data that is currently in the selected cell.

注意：要快速复制当前所选单元格上方的单元格内容，请按Ctrl + D，或者要将单元格内容复制到所选单元格的左侧，请按Ctrl + R。 请注意，从相邻单元格复制数据会替换所选单元格中当前存在的所有数据。

To replace the copies with the linear series, click the “Auto Fill Options” button that displays when you’re done dragging the fill handle.

要用线性系列替换副本，请在完成填充手柄后单击“自动填充选项”按钮。

The first option, Copy Cells, is the default. That’s why we ended up with five 1s and not the linear series of 1–5. To fill the linear series, we select “Fill Series” from the popup menu.

默认选项是“复制单元格”。 这就是为什么我们以5个1而不是1–5的线性级数结束的原因。 要填充线性序列，我们从弹出菜单中选择“填充序列”。

The other four 1s are replaced with 2–5 and our linear series is filled.

其他四个1被2-5代替，我们的线性序列被填充。

You can, however, do this without having to select Fill Series from the Auto Fill Options menu. Instead of entering just one number, enter the first two numbers in the first two cells. Then, select those two cells and drag the fill handle until you’ve selected all the cells you want to fill.

但是，您可以执行此操作而不必从“自动填充选项”菜单中选择“填充系列”。 而不是只输入一个数字，而是在前两个单元格中输入前两个数字。 然后，选择这两个单元格并拖动填充手柄，直到选择了要填充的所有单元格。<