How to Copy an Excel Formula to a Different Sheetby 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.
Go to the worksheet that has the formula you would like to copy. Right click on the cell with the formula and select "Copy."
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."
Click on the radio button next to "Formulas" and click "OK." The formula will reference the appropriate cells in this worksheet.