How to copy and retain the original formula in excel

If you want to know more about excel, you can click: Excel Tutorial

##How to keep the formula unchanged when copying and pasting in excel? Below I will share my method, I hope it will be useful to everyone!

1. First open an excel table, and then select the formula you want to copy, as shown in the figure below

2. Click the right button of the mouse and "Copy", as shown in the figure below

3. Select the appropriate position in the table to paste, As shown in the picture below

4. Then click the right button of the mouse and "Paste Special", as shown in the picture below

5. A new page will pop up, then select "Formula", then click "OK", and that's it!

The above is the detailed content of How to copy and retain the original formula in excel. For more information, please follow other related articles on the PHP Chinese website!