How to Copy Number Not Formula in Excel (5 Quick Tricks)

Get FREE Advanced Excel Exercises with Solutions!

Regarding working with Microsoft Excel, we use different formulas and multiple features to format cells. Sometimes, we might need to copy just the values, not the formulas. In this article, I am going to explain 5 simple yet effective ways on how to copy number without formula in Excel.

For more explanation, I have arranged a dataset where I have recorded the share values along with the months.

Copy Number not Formula


Copy Number Not Formula in Excel: 5 Quick Tricks

It’s not that difficult to copy number without formula in Excel. You will be able to understand it after reading the following procedures.

I have applied the COUNT, AVERAGE, and MEDIAN functions to calculate count, mean, and median values.


1. Use of Paste Special Command

If you have ever copied and pasted text or other data in Microsoft Excel, you know that sometimes you want to paste just the values, and other times you want to paste everything (including formatting, formulas, and comments). To make your life easier, Excel has a Paste Special command that lets you choose how you want to paste the information.

Steps:

  • First of all, select the entire area that you want to copy. Here, I have selected cells B9:C11.
  • Then, copy that area.

Copy Number not Formula

  • Next, select a cell and right-click on the mouse.
  • From the available options, 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 formula.

Copy Number not Formula


2. Application of Paste as Value Feature

Another effective way to copy number without formula is to use the Paste Value option from the Home tab. The whole procedure is described below.

Steps:

  • Select the entire area that you want to copy. Here, I have 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 on Values from Paste Values section.

Then, we will have our desired output in the selected cell.

Copy Number not Formula


3. Keyboard Shortcut to Copy Number Not Formula

Keyboard Shortcut is the simplest way to copy number, not formula.

Steps:

  • Copy the required cells.

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

Copy Number not Formula


4. Adoption of Simple Mouse Trick

We can also use the mouse to copy number without formula. The whole procedure is described below.

Steps:

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

  • Now, keep pressing on the right side of the mouse and move it to the selected location.
  • After that, pick Copy Here as Values Only.

Copy Number not Formula

Now, we will have the copied number, not the formula.

Read More: [Fixed]: Right Click Copy and Paste Not Working in Excel


5. Use of VBA Macro Code

Visual Basic Analysis (VBA) is the most advanced way to copy number without formula.

Steps:

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

Copy Number not Formula

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

  • Now, input the following code in the code writing section to have a duplicate sheet in a new worksheet without formula.
Sub CopyInAnotherWorkbook()
ActiveSheet.Copy
Cells.Copy
Range("A1").PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = False
End Sub
  • After that, click on the Run button.

Now, we will have a duplicate sheet in a new worksheet without formula.

Copy Number not Formula

Read More: [Fixed!] CTRL C Not Working in Excel


Download Practice Workbook


Conclusion

At the end of this article, I like to add that I have tried to explain 5 simple yet effective ways on how to copy number without formula in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below.


Related Articles


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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
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