Ctrl + V . . Cut and Paste Data Select the cell or cells you want to cut Select Edit → Cut or Click “ Cut” icon from the standard toolbar or Press Ctrl + X Move the cell pointer to the cell in which you want to paste. Select Edit → Paste or Click “Paste ” icon or Press Ctrl + V .
. Copy and Paste Formula The process of Copy and Paste data is used for 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 Chapter . .
Copy a formula from one cell and paste it in multiple cells: (For illustration - Refer . ) 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 this addition formula. Step : Paste the copied formula using Ctrl + V or Edit → Paste (or) Click “Paste” icon. . Open the spreadsheet 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 Self 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