行编号选择自动填充到结束 [英] Row numbering selection auto-fill till the end

问题描述

我有一张桌子，上面有数千条线。我想通过在第一行旁边添加1 2 3来对行进行排列，然后选择这些并拖动直到结束，以增加数字填充。

如何自动填充到最后一行不用鼠标拖动几分钟？

解决方案

你知道如何双击自动填充句柄？如果将1,2放在前两个单元格中，则选择这两个单元格，然后双击右下角的小黑框，它应该自动执行您所要求的操作。它将填充与它相邻的填充单元格一样多的行。

例如，请参阅 http://office.microsoft.com/en-us/excel-help/fill-data-automatically-in-worksheet-cells-HP001216366.aspx

提示您还可以通过使用填充命令（在相关的
单元格）上填充相邻
单元格的公式编辑组中的首页选项卡）
或按CTRL + D填充下面的单元格或CTRL + R将单元格填充到
包含公式的单元格右侧。您可以通过
双击包含
公式的第一个单元格的填充句柄，自动向
填充公式，对其适用的所有相邻单元格。例如，单元格A1：A15和B1：B15包含数字，而
在单元格C1中键入公式= A1 + B1。要将该公式复制到单元格
C2：C15中，请选择单元格C1并双击填充句柄。

I have a table with thousands of lines. I want to number rows by adding 1 2 3 next to first rows, then to select these and drag till end to make a fill with increasing numbers.

How to autofill till last row without dragging with a mouse for several minutes?

解决方案

Do you know how to double-click the autofill handle? If you put 1,2 in the first two cells, then select both cells and double-click the little black box in the bottom right corner, it should "automagically" do what you are asking. It will fill for as many rows as there are filled cells adjacent to it. Quite a handy trick.

For example, see http://office.microsoft.com/en-us/excel-help/fill-data-automatically-in-worksheet-cells-HP001216366.aspx

Tips You can also fill the active cell with the formula of an adjacent cell by using the Fill command (on the Home tab in the Editing group) or by pressing CTRL+D to fill a cell below or CTRL+R to fill a cell to the right of the cell containing the formula. You can automatically fill a formula downward, for all adjacent cells that it applies to, by double-clicking the fill handle of the first cell that contains the formula. For example, cells A1:A15 and B1:B15 contain numbers, and you type the formula =A1+B1 in cell C1. To copy that formula into cells C2:C15, select cell C1 and double-click the fill handle.

这篇关于行编号选择自动填充到结束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！