How to copy only numbers but not formulas in Excel

In Excel, only the content is copied, and the formula is not copied. That is, the copied content is pasted into the new cell. The formula of the original cell is not retained. You need to select it when pasting. "Paste value".

The method steps are as follows:

1. Open the EXCEL table that needs to be operated, select the cell that needs to be copied, and press "Ctrl C" on the keyboard to copy the cell content.

#2. Select the cells you want to paste, find "Pasteboard" on the "Home" tab, and click the drop-down menu button below "Paste".

#3. Select "Paste Value" in the pop-up paste option.

4. Return to the EXCEL table and you can find that the cell content with the formula has been successfully pasted into the new cell, but the formula of the original cell has not been pasted. .

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of How to copy only numbers but not formulas in Excel. For more information, please follow other related articles on the PHP Chinese website!