Use Paste Special to copy only formulas : Formula « Formula « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Formula
3. Formula

Select the cells containing the formulas. 
           Click the Copy button on the Home tab

Click where you want to paste the data. 
           Click the Paste button arrow and click Paste Special.

Click the Formulas button. Click OK.

6.1.Formula
	6.1.1.	Enter a Formula
	6.1.2.	Display Formulas in Cells
	6.1.3.	Copy a Formula Using AutoFill
	6.1.4.	Copy a Formula Using the Clipboard
	6.1.5.	Use Paste Special to copy only formulas
	6.1.6.	Use keyboard commands to recalculate formulas
	6.1.7.	Convert a Formula to a Value
	6.1.8.	Print formulas
	6.1.9.	Change Formula Options
	6.1.10.	Include a link in a formula
	6.1.11.	Hide or Show Formulas
	6.1.12.	Select the calculating options