To use the Fill option for an entire column. Note: If you directly use Ctrl+V or choose normal paste option instead of this you will also get the same result.Įxcel has its own fill option to copy text, formulas, and other things in a range of cells.
By doing this you will get the below result.After this select the rest of the cells of Column C and in the Paste Option, select Formulas.After applying the formula =A2*B2 copy the formulated cell.One of the easy processes of inserting a formula for the entire column is copying the formulated cell and pasting it into the entire column. =IF("", "") Copying and Pasting the Formula for the Entire Column As there is no value inserted in cell A11 or B11 there will be no insertion of the formula by double-clicking in cell C11. The double-clicking will automatically insert the formula from C2 to C10. Like, in this example you will need to apply the formula from cell C2 to cell C10. The most interesting thing about this double-clicking is that it will automatically apply the formula to the cells where you actually need the formula to be applied.
After you apply the formula in a cell double-click the plus sign in the fill handle with the left button of your mouse that appears in the corresponding cell. This is the easiest process for inserting the formula for the entire column. To check the result that you are looking for, select any cell and you will see the formula appears on top of the worksheet.Now, after you release the pressing in your mouse the result will appear in your worksheet.Pressing on the left button of your mouse drag this fill downwards. moving the cursor of the mouse you will see the (+) sign in the rightmost corner of cell C2. Select Cell C2 to get the Fill Handle.By this, you will get the Area for the corresponding row. One of the easy processes of inserting a formula for the entire column is dragging down the Fill Handle of the formulated cell. This green box is known as the Fill Handle. Whenever you select a cell, you will get to see a green box surrounds that specific cell. Related Readings Dragging Down the Fill Handle