Copy a Formula Using the Clipboard : Formula « Formula « Microsoft Office Excel 2007 Tutorial






Select the cell that contains the formula. 
           Click the Home tab. Click the Copy button.
Select the cell that contains the formula. Click the Home tab. Click the Copy button.
Select one or more cells where you want to paste the formula. 
           Click the Paste button.
Click the Paste button.
Or Click the Paste Options button, and then select what type of formatting option.
Or Click the Paste Options button, and then select what type of formatting option.

To cancel the selection, press Esc to remove the marquee.









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