Monday, 10 September 2012

Use Paste Special to copy only formulas

Select the cells containing the formulas. 
           Click the Copy button on the Home tab
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 where you want to paste the data. Click the Paste button arrow and click Paste Special. Click the Formulas button
Click the Formulas button. Click OK.
Click OK.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)