How to make Ctrl + D become Paste Value?

[putritersenyum]

If we use Ctrl + D, it will paste cell's content with it's format. How to make it just paste value?

[ExcelsBiggestFan]

Hold CTR+ALT+V then press V, then Enter.

https://support.office.com/en-us/art...7-b7af7d8e813e

[putritersenyum]

ExcelsBiggestFan, it's not work.

[ExcelsBiggestFan]

You have to let go of CTRL+ALT+V after you have pressed then all at the same time. The press v then press enter.

The link I provided also shows you pictures of what you should see.

[putritersenyum]

ok, thanks it works.

[ExcelsBiggestFan]

Welcome