# How to Copy Formula to Another Sheet in Excel (4 Methods)

## Method 1 – Apply Keyboard Shortcuts to Copy a Formula to Another sheet in Excel

Steps:

• Press Ctrl+C to copy a selected cell.

• Go to another sheet, and press Ctrl+V to paste.

Â

• The value is modified on another sheet while the formula remains the same.

• Use the AutoFill tool to fill the next cells.

## Method 2 – Use the Formula Bar to Copy Formula to Another sheet in Excel

Steps:

• Copy the formmula from the first sheet.
• Press the Esc key.

• Paste the formula to another sheet.

• Use the AutoFill tool to fill the blank cells.

## Method 3 – Use the Clipboard Group to Copy Formula to Another sheet in Excel

Steps:

• Select a cell and from the Clipboard Group, click on the Copy option.

• In another sheet, select the Paste option from the Clipboard Group.
• From the Paste option, select the Formulas(F) option.

• AutoFill the cells with the same formula.

## Method 4 – Use Find & Replace Option to Copy Formula to Another sheet in Excel

Steps:

• Select the cells.

• Press Ctrl+H to open the Find and Replace dialog.
• In the Find what box cell type equal to (=)
• In the Replace with box, type the â€˜nothereâ€™.
• Click on Replace All.

• Click OK.

• Click Close.

• Copy the cells as shown in the below screenshot.

• Paste it into another sheet.

• In the Find what box type â€˜nothereâ€™.
• In the replace with box type equal to (=)
• Click to Replace All.

• Click on OK.

• Click on Close.

• You will see that the formula is copied to another sheet.

Note: After copying the formula into a new sheet, we may see that the first sheet will change. To fix the sample data set we have to follow the rules below.

Steps:

• Type â€˜nothereâ€™ in the Find what.
• Enter the equal (=) sign in the Replace with.
• Click on Replace All.

• Click OK.

• Click on the Close option.

• The values are returned in the previous format.

## Related Articles

<< Go Back to Copy Formula in Excel | Excel Formulas | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Bhubon Costa

Bhubon Costa, B.Sc. in Naval Architecture & Marine Engineering from Bangladesh University of Engineering & Technology, has worked with the ExcelDemy since 2021. Currently, he has been working as a reviewer. Notably, he has written over 90 articles and led several VBA content development teams. He has a great passion for the fields of data analytics and data science. His areas of expertise include Excel VBA, Power Query, Pivot Table, Power BI, MySQL, PostgreSQL, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF