How To Copy And Paste Formulas In Excel From One Workbook To Another

Copy and paste formulas in Excel from one workbook to another refers to the process of copying a formula from one Excel workbook to another Excel workbook. This can be done by selecting the cell containing the formula in the source workbook, copying the formula, and then pasting it into the destination workbook. Rather than having to manually enter the same formula into each workbook, you can simply copy and paste it from one workbook to another. This can also help to reduce errors that can occur when manually entering formulas. Additionally, if the formula needs to be updated, you can update it in the source workbook and then copy and paste it into the destination workbook, rather than having to update each workbook individually.

In our data set first and last names are written and we used a function (Concat) to invert them in the first workbook. In the second workbook again we have different names (first and last) and we want to invert the name as we have done in the first workbook but in a different palace (column) so we copied the same formula to have the same results. In this tutorial we will learn how to copy and paste formulas in excel from one workbook to another. For this we used the Copy and Paste option along with Find and Select option as the first method and second method is by using Paste Formula. Following steps will guide you to use Copy, Paste and Find and select options.

Method 1 : By using find and select

Step 1 – Select the Range of cell

Select the range of cells that have used the formula to be copied

Step 2 – click on Replace option

Click on find and select option in Home tab and a dropdown menu will appear
From this menu click on Replace option and a dialog box will appear

Step 3 – Fill the dialog box

In the dialog box, Type “=” in the box next to Find what option
In the dialog box, Type “#” in the box next to Replace what option
Click on Replace All to see the changings in selected data

Step 4 – Copy the Data

Right click on selected range of cell and a dropdown menu will appear
From this menu click on Copy

Step 5 – Select the Range of Data

After copying the range of cell in first workbook,open the second workbook(where formula is to be pasted)
After opening second workbook Select the range of cell on which you want to apply the copied formula

Step 6 – Paste the Data

After selecting the range of cell right click on selected cells and a dropdown menu will appear
From the drop down menu click on formula below paste option to get the required results