excel sheet how to fill down in sequence, except dragging with the mouse.

and previous versions: "Fill" "Fill Down".

Version: Start-Fill-Down.

or upward, etc., the position is in the upper right corner, see the figure below:

For example, enter 1,2 in the A1 and A2 cells respectively and then select the A1 and A2 cells at the same time, in the lower right corner of the A2 grid, double-click after the mouse becomes a black cross, if there is data in column B, the rows with data in the sequence are automatically filled, for.

Enter the start number first, select ,——Fill - Sequence - Set the parameters (e.g. the sequence is generated in: column; Type: Isovariance sequence; Steps: 1; Stop Value: 100) - OK.

My usual methods are:

a1=1b1=a1+1

Copy the B1 cell, then hold down the shift key and click the down arrow to the end cell position, and then press enter.

I don't usually want to use a mouse to operate).

Another way is to compile with macros, A2 is not empty then A1=1, B2 is not empty then A2 + 1, and then you can cycle down in turn.

Double-click the fill handle to automatically fill the row where the data is located if there is data on both sides.

If there is data in front, you can directly double-click to fill the small cross button, you can also select the cell you want to fill, try it in the menu bar "-Fill --- Fill Down--- you will understand.

If the Excel workbook does not enable the cell drag and drop function, you cannot drag and drop the fill sequence. The following describes how to enable the Excel fill handle and cell drag and drop function, and the specific steps are as follows:

1. If you select a cell, a black cross will not appear in the lower right corner of the cell, then you cannot use the cell drag and drop function to fill the serial number downward, as shown in the figure below.

2. In the open Excel workbook, click the [Office] button, and select the [Excel Options] button in the pop-up menu.

3. As shown in the figure below, through the operation of the previous step, the system pops up the [Excel Options] dialog box.

4. In the pop-up [Excel Options] dialog box: select the [Advanced] option on the left; In the content on the right, select the Enable Fill Handle and Cell Drag-and-Drop option pointed by the blue arrow, and click the OK button after setting.

5. Through the above steps, move the cursor to the lower right corner of the cell and a black cross will appear, click the cell and drag the mouse to fill the number column into the cell.

These two problems are actually the same problem, and they are caused by the fact that the formula is not automatically calculated. The solution is given below:

Materials Required: Excel 2007 Presentation.

1. These two problems are not automatically calculated by formulas, and here is a demonstration of the first problem, as shown in the figure below, c1=a1*b2, filled down.

2. As shown in the figure below, the filled formulas are all =a1*b1.

3. When the mouse double-clicks a cell, the formula will be automatically applied, such as the c8 cell of the dot, then it will become =a8*b8.

4. The solution is as follows, click the "Office button" in the upper left corner (other version point files).

5. Click "Excel Options" in the pop-up menu.

6. Enter the "Formula" tab, check the "Automatic Recalculation" function, and click "OK".

7. After setting up automatic recalculation, fill the C1 cell downwards again.

8. As shown in the figure below, this time the formula was automatically filled successfully, and the problem was solved.

Excel** cannot drag the serial number, you can use the Ctrl key of the keyboard to pull down and drag to fill the serial number.

The specific steps are as follows:

1. In any blank cell in Excel**, enter the first number that needs to be filled with the serial number, such as 1.

2. Hold down the "Ctrl" key on the keyboard, move the mouse to stay in the lower right corner of the first cell, when the cursor becomes "+", click the mouse and drag it down, a dotted box and numbers appear below, release the mouse to drag the serial number to fill in the corresponding position.

3. Return to excel**, in excel**, the operation of dragging and filling the serial number has been realized.

Excel Tips:

1. Select the data to the right.

Select the data cell to the right, shortcut: shift+ctrl+

Select the entire row of cells to the right, shortcut: shift+ctrl+ and hold shift+ctrl, then press the arrow key again:

2. Select the data below.

Select the data cell downward, shortcut: shift+ctrl+

Select the entire column of cells downward, shortcut: shift+ctrl+ and hold shift+ctrl, then press the arrow key: again

3. Select the current data region to the right and below.

Shortcut: shift+ctrl+end

4. Quickly locate to the header or footer.

Quickly locate to cell A1 in the header and use CTRLL+HOME to shortcut key

Quickly navigate to the bottom of the table, shortcut key: Ctrl+End

5. Switch Windows windows.

Shortcut: Alt+Tab You can press Tab continuously to switch windows.

Move the cursor to the lower right corner of the formula grid, change it to "+", and then drag it with the left.

Click on "Tools" - option --- recalculate--- check "Auto Recalculate" - OK.

Automatic recalculation of the workbook is turned off.

Click on the menu: Tools - Options.

In the Recalculate window, select Automatic Recalculation

Tools - Options - Recalculation - Automatic Recalculation.

First, enable automatic "automatic recalculation": Tools - Options - Recalculation - Automatic Recalculation.

Second: If you can't drag and drop, it may be because the format of a column is wrong, you can try to adjust the format by formatting.

If not, you can continue to ask, or send me a private message.

1. First of all, you need to click the Chinese tab in the menu bar, as shown in the figure below.

2. Next, you need to click on the option command, as shown in the figure below.

3. Next, you need to select Advanced Commands in the Excel Options window, and then select Custom List Command on the right side, as shown in the figure below.

4. Import the sequence in the custom sequence, and at this time, you only need to enter any sequence name to fill the custom sequence downward, as shown in the following figure.

Enter =row(a1) in a cell

Hold down the Ctrl key and pull down at the same time to return 1,2,3,4....

Summary. Take advantage of what can be dragged to quickly fill a data sequence in a cell in Excel.

The above ** is the specific steps of the operation, you can <> one by one in accordance with the steps of the leakage and excavation beam

Hope it's good for you and I hope you can give me a thumbs up.