Copy and Paste is one of the vital tools used in Excel. This tool transfers the dataset from one part of Excel to another. It saves the user from retyping the dataset again. However, even the formula is copied when you copy a cell containing a formula. Sometimes, you may only need the value and not the formula. This article will guide you on ways that you can use to paste numbers without formulas.
Using the Clipboard tool
Here are the steps to follow:
1. Open the Excel application and then open the workbook that contains the dataset your dataset.
2. Click on the cell that contains the number you need to copy. If the numbers are in more than one cell, highlight the cells with numbers you wish to copy.
3. Click the Home tab on the ribbon and locate the Clipboard section. From the section, click on the Copy button.
4. Click where you need to paste the numbers. Select several cells if the numbers are in more than one cell.
5. Click the Home tab on the ribbon and locate the Clipboard section. From the section, click the Paste drop-down button. From the menu, choose the Values Icon.
Using the Right-Click Tool
Steps:
1. Open the Excel application and then open the workbook that contains the dataset your dataset.
2. Click on the cell that contains the number you need to copy. If the numbers are in more than one cell, highlight the cells with numbers you wish to copy.
3. Right-click on the selected cell(s). Then, choose the Copy button.
4. Click where you need to paste the numbers. Select several cells if the numbers are in more than one cell.
5. Right-click on the selected cell(s). Then, choose the Values icon and the Paste Options button. That is all you need to do to paste the numbers without formulas.
Using Paste Special Tool
Steps:
1. Open the Excel application and then open the workbook that contains the dataset your dataset.
2. Click on the cell that contains the number you need to copy. If the numbers are in more than one cell, highlight the cells with numbers you wish to copy.
3. Click the Home tab on the ribbon and locate the Clipboard section. From the section, click on the Copy button.
4. Click where you need to paste the numbers. Select several cells if the numbers are in more than one cell.
5. Click the Home tab on the ribbon and locate the Clipboard section. From the section, click the Paste drop-down button. From the menu, choose the Paste Special Button.
6. In the Paste Special dialogue box, toggle on the Values in the Paste section. Finally, hit the OK button.
Using Keyboard Shortcuts
Steps:
1. Click on the cell that contains the number you need to copy. Then, press the CTRL + C keys to copy the number(s).
2. Click where you need to paste the number(s).
3. Press the CTRL + SHIFT + V keys to paste the number without the formula.