6.1.4.Copy a Formula Using the Clipboard |
|
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.](../../Microsoft-Office-Excel-2007Images/Copy_Formula_Using_Clipboard___Select_Cell_That_Contains_Formula_C.PNG) |
Select one or more cells where you want to paste the formula.
Click the Paste button.
|
|
![Click the Paste button.](../../Microsoft-Office-Excel-2007Images/Copy_Formula_Using_Clipboard___Click_Paste_Button.PNG) |
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.](../../Microsoft-Office-Excel-2007Images/Copy_Formula_Using_Clipboard___Or_Click_Paste_Options_Button_And_T.PNG) |
To cancel the selection, press Esc to remove the marquee. |