Copy all of these cells and paste them into the cells where you want to paste them. This will convert all formulas to text with the # sign at the front. In the Find and Replace window, type = in the Find what field, and # in the Replace with field. Select the Home menu, click on the Find & Select icon in the Editing group, and select Replace. Highlight all of the cells that contain the formulas you want to copy. You can paste the formula cells but keep the original referenced cells in those formulas by following the trick below. The only problem with strictly pasting formulas is that Excel will automatically update all the referenced cells relative to where you’re pasting them. If you want to copy and paste formula cells but keep the formulas, you can do this as well. Copy Formulas Without Changing References

This removes all of the relative formula complexity when you normally copy and paste formula cells in Excel. This will paste only the values (not the formulas) into the destination cells. Select the Values icon from the pop-up menu. Right-click the first cell in the range where you want to paste the values. Right-click any of the cells and select Copy from the pop-up menu. Select the cells with the values you want to copy. You can prevent this from happening and copy only the actual values using a simple trick. This is because, when you paste formula results, the formula automatically updates relative to the cell you’re pasting it into. One of the most annoying things about copying and pasting in Excel is when you try to copy and paste the results of Excel formulas.

Whether you want to copy and paste individual cells, rows or columns, or entire sheets, the following 15 tricks will help you do it faster and more efficiently.

How to paste list into excel cells