How to Copy Number Not Formula in Excel: 5 Quick Methods

Method 1 – Use of Paste Special Command

Steps:

• Select the entire area that you want to copy. We selected cells B9:C11.
• Copy that area.

• Select a cell and right-click on the mouse.
• From the available options, select Paste Special.

A Paste Special wizard will appear.

• From the Paste group, choose Values and press OK.

We will have the copied number without a formula.

Method 2 – Application of Paste as Value Feature

Steps:

• Select the entire area that you want to copy. We selected cells B9:C11 and copy that area.

• Go to the Home tab.
• From the ribbon, pick the Paste option.
• Click Values from Paste Values section.

We will have our desired output in the selected cell.

Method 3 – Keyboard Shortcut to Copy Number, Not Formula

Steps:

• Copy the required cells.

• Choose a suitable location to paste.
• Press Ctrl + Alt + V, V, and Enter to have the copied cells without the formula.

Method 4 – Adoption of Simple Mouse Trick

Steps:

• Select the entire cells and put the cursor at the edge of the selected area to have four-headed arrows.

• Keep pressing on the right side of the mouse and move it to the selected location.
• Pick Copy Here as Values Only.

We will have the copied number, not the formula.

Method 5 – Use of VBA Macro Code

Steps:

• Go to Developer.
• Click on Visual Basic from the ribbon.

• Double-click on the sheet name to have space for code writing.

• Input the following code in the code writing section to have a duplicate sheet in a new worksheet without a formula.

Sub CopyInAnotherWorkbook()
ActiveSheet.Copy
Cells.Copy
Range("A1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub

• Click on the Run button.

We will have a duplicate sheet in a new worksheet without a formula.

Download Practice Workbook

Related Articles

• [Solved] Excel Copy Paste Loses Formatting
• [Fixed!] Cannot Copy Merged Cells in Excel
  
• [Fixed!] Paste Link Not Working in Excel
• [Fixed!] Copy and Paste Not Working Between Workbooks in Excel
  
• [Fixed!]: Microsoft Excel Cannot Paste the Data as Picture
  

<< Go Back to Copy-Paste Not Working | Copy Paste in Excel | Learn Excel