HOW EXCEL FORMULAS ARE POPULATED DOWNWARDS AS A WHOLE

The steps are shown in the following figure:

1. Double-click to open the excel you want to process.

<>3. After selection, move the mouse to the lower right corner of the selection box to appear a plus icon, then click the mouse and drag down until the last row needs to be filled.

Fill the formula down, just move the mouse to the bottom right corner of the top formula cell, at this time, the mouse arrow will change into a cross shape, take the opportunity to double-click to automatically fill the formula down.

As shown in the figure below, in the amount column, I need to fill down the formula to H product:

The cell is positioned to the D2 cell, move the mouse to the lower right corner of the cell, and wait until the arrow changes to a cross shape

The formula is automatically populated to the H product:

The formula for cells b1 to b5 is changed to :

indirect("sheet2!i"&(int((row()-1)/5)+3))

indirect("sheet2!bm"&(int((row()-1)/5)+3))

indirect("sheet2!df"&(int((row()-1)/5)+3))

indirect("sheet2!ex"&(int((row()-1)/5)+3))

indirect("sheet2!gp"&(int((row()-1) 5)+3)), then select five cells of b1 b5 and fill the formula downward.

1.Ctr+D fills the formula downwards.

Ctr+R fills the formula to the right.

2.Select the first formula cell and double-click it in the lower right corner of the cell.

After making the first common formula, move the cursor to the lower right corner of the formula grid, change it to "+", hold down the left button, and drag the mouse down to generate the same formula (only the line number in the formula will change).

If you are very sure about the formula, you can select a column of spaces first, directly enter the first formula, after the formula is entered, press Ctrl+Enter, and all the selected grids will generate formulas, which is the same as the effect of dropping down.

The way to quickly fill down or right in Excel.

Excel** automatically fills in formulas without dragging the mouse down, which can be achieved by selecting the lower cell and using the key combination "Ctrl+D".

The steps of the method are as follows:

1. Open the Excel** that needs to be operated, enter the correct formula in the first cell and press enter to the result.

2. Select the cell containing the formula and the cell area below it that needs to be filled, and press the "Ctrl" and "D" keys of the keyboard at the same time to fill the formula of the cells below.

3. Return to excel** and find that the excel** formula is automatically filled through the keyboard operation.

Double-click the small black cross in the lower right corner of the cell where the formula is located to quickly fill it without dropping down.

To quickly pull down and fill the excel formula, you can enter the formula in the cell, press and hold the small square of the cell to pull down and fill.

Tools Raw Materials:

ASUS Chosen FA506IV

windows10

office excel2019

1. Double-click the cell.

Open the document and double-click the E2 cell.

2. Enter the formula.

Enter the formula in the formula bar and click the tick icon.

3. Pull down small squares.

Press the small square in the bottom right corner of cell E2 to pull down.

4. The filling formula is completed.

Release the mouse, the drop-down is done, and the formula is filled to the cells below.

1. Open Excel** and enter some values in columns A and B.

2. Enter the formula in C1: =A1+B1 (use the addition formula to illustrate as an example). Not blind.

3. After clicking Enter to generate the calculation result, Shenlu moves the cursor of the mouse to the lower right corner of the cell.

4. After double-clicking the position with the mouse, you can fill the formula of C1 down to the position where the data calculation is finished.

The function (which doesn't actually move any cells or change the selected area more noisily, it just returns a reference.) The offset function can be used for any bumper function that requires a reference as a parameter. Defense.

Enter the following formula and fill in the formula down:

The offset(A$1,(row(A1)-1)*10,) formula means: take A1 cell as the base, move the first cell down, and the base cell is offset by 10 cells.

Functions (The result of the index function is a reference, and when used in other formulas, its interpretation is the same.) Depending on the formula used, the return value of index can be used as a reference or as a value. ）

Enter the following formula and fill in the formula down:

index(a:a,(row(a1)-1)*10+1)<>