How to paste values in Excel?

Tips-&-Tricks Mar 27, 2019

Paste Value

Another trick for the users who don't know how to paste values. Pasting values is the most used in excel user's life. People with more data interaction get more interaction with paste values. So here we come with the solution of how to apply paste value on data.

Follow the steps -
Copy the Source table/range and select destination and then use CTRL + ALT + V to open Paste Special user form and click on value option of paste special window then press OK to get the result on destination like in below tagged image (paste value)

See the result on destination

Paste Value

Hope you understood the application.


Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be excel expert, connect us on:

9599408486 / 8929231250

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.