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.