Sometimes, you have a large spreadsheet full of formulas, and you want to copy them exactly. Changing everything to absolute cell references (as described in the section on cell references) would be tedious, especially if you just want to change them back again afterward. Use this method to quickly move formulas with relative cell references elsewhere without changing the references. Here's our example spreadsheet, which needs to have column C duplicated to column D:     Example Spreadsheet     Column A Column B Column C Column D    row 1    944       Frogs       =A1/2         row 2    636       Toads       =A2/2         row 3    712       Newts       =A3/2         row 4    690       Snakes       =A4/2           If you're just trying to copy the formula in a single cell, skip to the last step ("Try alternate methods") in this section. On most versions of Excel, you can find this by clicking the Home tab at the top of the Excel window, then clicking Find & Select in the "Editing" portion of the tab. You can also use the keyboard shortcut, CTRL F. Enter "=", click "Find All," then enter another character into the "Replace with" box. This will automatically turn all formulas (which always begin with =) into text strings beginning with some other character. Always use a character that you have not used in your spreadsheet. For example, replace it with # or &, or a longer string of characters, such as ##&.     Example Spreadsheet     Column A Column B Column C Column D    row 1    944       Frogs       ##&A1/2         row 2    636       Toads       ##&A2/2         row 3    712       Newts       ##&A3/2         row 4    690       Snakes       ##&A4/2           Do not use the characters * or ?, since these will make later steps more difficult. You may now select any cells you wish to copy, then paste them into another location. Since they are no longer interpreted as formulas, they will be copied exactly.     Example Spreadsheet     Column A Column B Column C Column D    row 1    944       Frogs       ##&A1/2      ...

TL;DR in Chinese:
这个方法可以不修改单元格的引用。 打开查找窗口。 查找并将"="替换为其它字符。 复制并粘贴单元格。 再次使用查找和替换，将之前的替换更改回来。 尝试其它方法。