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
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