In this article, we will explain how to paste values using Excel keyboard shortcuts. Copying and pasting is one of the easiest things to do in Excel and is totally helpful.
Your work gets a lot easier because we all know that Excel is a powerful tool that helps you to organize, analyze, and present data in a clear and concise manner. The common keyboard shortcut to copy is Ctrl + C, and to paste, Ctrl + V.
However, there are a lot of options, shortcuts, and key combinations. If you just want the value alone without copying the formula, formatting, etc. This is what we are going to teach you about keyboard shortcuts in Excel to paste values in this article.
What is the Excel Paste Values Shortcut?
The paste values shortcut is a useful feature and an easy way to paste values into another location. It allows you to quickly paste data into a spreadsheet without bringing over any formatting or formulas.
In addition to that, it is useful in many situations, like when you want to preserve the values of a cell or range of cells for later use or when you want to remove the formatting or formulas from a cell or range of cells.
What is Paste Values?
Paste values is the copying and pasting of data that will only insert the values and not the formatting. It will paste the value and allow you to extract text or a number from a cell.
Note: In the image above, we just have to copy and paste the value and its format.
Note: In the image above, we just have to copy and paste the value alone without the format.
If you want to know the formula with regard to the secret to the second image above, continue to read on.
What is Paste Special Menu in Excel?
Paste Values is one of the many pasting options that you can see in Excel. If you want to copy and paste something other than its format, “Paste Special” is the answer.
It has a wide range of choices or options to paste your data into another cell or location, and it is specific.
How to Use the Excel Paste Values Shortcut
Using the Excel paste values shortcut is quite simple and can literally be done with just a few keystrokes. Simply follow these steps to only paste values in Excel below:
- Select the cells that you want to copy.
- Press “Ctrl+C.”
- Select another cell where you want to paste your data.
- Press and hold “Ctrl” and “Alt,” and then press “V” on your keyboard to open the Paste Special menu.
- In the “Paste Special” dialog box, select “Values.”
- Then, click “OK.”
It’s that easy! With just a few keystrokes, you can paste data into your Excel spreadsheet without copying any unwanted formatting or formulas. Kindly refer to the video below.
Ways to access Paste Special in Excel
Here are some ways to utilize Paste Special in your Excel spreadsheet.
1. Paste Special command using right-click menu
- You just right-click the cell where you want to paste the copied data. As you can see, the six most popular paste options appear directly in the pop-up menu.
- 2. If you want more paste options, then click Paste Special in the context menu because it has 14 more paste options.
2. Paste Special button from Home Tab
- After you select and copy the data.
- Click another cell where you want to paste your copied data.
- Click the drop-down under “Paste.”
- Select “Paste Special,” and it will display the Paste Special dialog box where you can choose a different paste option.
3. Key Shortcut for Paste Special
You have to copy the data first and select another place where you want to paste the copied data. Then follow the different Excel paste values shortcut.
- Ctrl + Alt + V
- Menu Key + V
- Alt+ H+ V+ V
- Alt + E + S
Note: If you cannot find the menu key, it is located to the right of the spacebar, between Alt and the Windows logo and Ctrl.
Tips for Using the Excel Paste Values Shortcut
Here are the tips for using the Excel paste values shortcut that you should keep in mind:
- Make sure to copy the data first before using the paste values shortcut.
- You should think about the location of the cells where you’re going to paste your data because that will be the final place where your data will go in your spreadsheet. However, you can easily remove it if you want.
- You can use this paste values shortcut when you copy data from another source. Perhaps it will ensure that no unwanted formulas or formatting have been included.
Conclusion
This comprehensive guide about the Excel paste values shortcut is a simple yet totally useful feature. That can help you quickly and easily paste data into your Excel spreadsheet without copying any unwanted formatting or formulas.
We hope this guide was helpful to you, and we are happy to know that you did great. We would love to hear some thoughts on this tutorial and how you’ve been using it.
Thank you very much for continuing to read until the end of this article. In case you have more questions, feel free to comment. You can also visit our website for additional information.