Excel drop-down filling formula can enter the filling range in the name box, select the filling area, then select the formula edit bar, press Ctrl Enter, you can fill the formula to the to-be-filled area. You can also calculate the first row of results, select the result cell until the mouse turns into a black cross, hold down the left button and drag down to complete the formula filling.
The specific steps are as follows:
Method 1:
1. Fill in the formula in B1 down to the 20th row, and enter B1 in the name box: B20, then press Enter, select the B1:B20 area:
2. Select the formula edit bar and press Ctrl Enter
The formula is filled to 20 rows:
Method 2:
1. Enter "=A1*B1" in cell C1 For the multiplication formula, press Enter to confirm and you will get the result of multiplying A1 and B1:
2. Use the mouse to select the "C1" cell until the mouse turns black. When the cross appears, hold down the left button and drag down to copy the multiplication formula:
For more Excel-related technical articles, please visit Excel Basic tutorial column!
The above is the detailed content of How to drop down and fill formulas in excel. For more information, please follow other related articles on the PHP Chinese website!