When you copy cells containing formulas, the cell references within the formulas will be altered, unless they are made absolute by placing the $ symbol before the column or row reference - see the pages on Absolute and Relative Cell References for a detailed explanation of this.

Note that there are a few Excel copy and paste rules that you should be aware of: select the Ctrl key and while holding this down, press V). Using the keyboard shortcut, Ctrl + V (i.e.Selecting the Paste from the home tab of the Excel ribbon.Right clicking with the mouse and selecting 'Paste' from this menu.Click on the location where you want to paste the copied cell(s).select the Ctrl key and while holding this down, press C). Using the keyboard shortcut, Ctrl + C (i.e.Selecting the Copy option from the home tab of the Excel ribbon.Right clicking with the mouse and selecting 'Copy' from this menu.Select an Excel cell, or range of cells.The most simple Excel copy and paste uses the following steps: