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

Method 1 – Use the Paste Special Command

Steps:

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

Copy Number not Formula

  • Select a cell and right-click on it.
  • Select Paste Special.

Copy Number not Formula

A Paste Special wizard will appear.

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

We will have the copied number without a formula.

Copy Number not 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.

Copy Number not Formula

  • 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.

Copy Number not Formula


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.

Copy Number not Formula


Method 4 – Using a Mouse Trick

Steps:

  • Select the cells and put the cursor at the edge of the selected area to get a four-headed arrow cursor.

  • Right-click and hold, then drag the cursor to the intended cell.
  • Pick Copy Here as Values Only.

Copy Number not Formula

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.

Copy Number not Formula

  • Double-click on the sheet name to get the 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.

Copy Number not Formula


Download the Practice Workbook


Related Articles


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

Get FREE Advanced Excel Exercises with Solutions!
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo