How to Copy an Excel Formula to a Different Sheet

by Shreya Mehta

At times, users may have formulas they need to use in multiple Microsoft Excel worksheets. It would be time consuming to manually construct the formula for each worksheet, especially when there are a number of formulas that must be applied to many worksheets. Microsoft Excel makes this task easier by allowing the user to simply copy and special paste the formula.

1

Go to the worksheet that has the formula you would like to copy. Right click on the cell with the formula and select "Copy."

2

Go to the worksheet where you want to paste the formula. Click on an empty cell. Right click on the cell and select "Paste Special."

3

Click on the radio button next to "Formulas" and click "OK." The formula will reference the appropriate cells in this worksheet.

About the Author

Shreya Mehta graduated from the University of Massachusetts with a Bachelors degree in business administration with a double concentration in finance and MIS. She attended Bentley College to obtain a MBA in finance and Masters in IT. She has been working for a financial software company for the past three years as an associate content manager.