EXCEL formula

EXCEL in the formula in C1 = A1 * B1, C2 = A2 * B2, C3 = A3 * B3 …….456,789 in a one must enter it?

enter the formula in c1, the cursor moved to the lower right color when the cursor into a “ten”, holding down the left go down to care.do not have to, enter C1 The project, the mouse into the lower right corner C1, a special logo with the left mouse button point to live it to drop (a few cells to enter the formula on the number of cells and Latin America, and Latin America can also be horizontal).Be Pull off the grid will automatically generate the formula.No.
In c1 as long as you enter = A1 * B1, will be c1 drag down.C2 = A2 * B2, C3 = A3 * B3 ….drag sentence Will be able to handle
fill C1 = A1 * B1, after a direct input to drag down, is boosting the bottom right corner that pull down the cross, you want to have been taken to the cells.
Other C1 = A1 * B1 in this way can enter:(=) Click on cell A1 (*) click on the cell B1, brackets for the content of the handwriting.

Leave a Reply