copying formula. When you copy a formula from one cell to another cell, the address of the pasted formula will change according to its row. This is called “Relative Cell Reference” (Refer Figure . ).
Example: While pasted it becomes = B3* C3 Originally typed formula = B2*C2 Row number Figure . Copy and Paste formula to multiple cells . . Copy a formula from one cell and paste it in multiple cells: (For illustration - Refer Figure .
) Step : Copy the formula from H2 using Ctrl + C or E dit → Copy (or) click “ Copy” icon. Figure . Copy and Paste forumla to Multiple cells Step : Select all cells (i.e. H3 to H11) in which you want to paste the addition formula.
Step : Paste the copied formula using Ctrl + V or Edit → Paste (or) Click “Paste” icon. . Open the worksheet which was created in Illustration . .
Add one more column heading “Average” in I1 . Create a formula to find the average of all marks in I2. . Apply the formula to the remaining cells.
. Save the changes and close the file WorkShop Practice: . Auto Fill Feature: You have learnt how to copy and paste a formula from one cell to other cells in the previous section. The process of Copy and Paste can be replaced by a click and drag and it is called as “ Auto Fill ”.
This is an alternate way to copy and paste. Auto Fill feature fills the contents from one cell to all the dragged cells. The content may be a data or formula. If you fill a relative formula, all the addresses of filled formulae will be changed.
Drag Fill Handle Figure . Drag fill handle Cell pointer’s “ Drag fill handle ” is used to auto fill. Just click and drag this handle to fill the contents. It can be dragged towards right or down.
Same can be achieved by Edit → Fill → Down (or) Edit → Fill → Right. . . Auto Fill Series: Auto Fill is