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

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

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


Download Practice Workbook


5 Quick Tricks to Copy Number Not Formula in Excel

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


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

Read More: How to Use Paste Special to Multiply Numbers in Excel


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

Read More: Formula to Copy and Paste Values in Excel Automatically


Similar Readings


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, Enter to have the copied cells without formula.

Copy Number not Formula

Read More: All Paste Options in Excel with Time Saving Shortcuts


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: Excel VBA to Copy Only Values to Destination (Macro, UDF, and UserForm)


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: VBA Paste Special to Copy Values and Formats in Excel (9 Examples)


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. You can visit our site for more articles about using Excel.


Related Articles

Naimul Hasan Arif

Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo