Forum Discussion
Solved
How to change all cells to "Paste Special" Values
I am using Excel Office 365 and I have multiple data sources to input on a large spreadsheet from another spreadsheet, when I use CTRL+V to paste, I have to change the Paste to use "Values Special Pa...
there is no setting in Excel to change the default paste behaviour.
But you can use a keyboard shortcut to paste only values:
1. Do a Ctrl+V as you did before
2. Then hit again only Ctrl, and after that, only V
It's not ideal, but much quicker than using the context menue with the mouse.
there is no setting in Excel to change the default paste behaviour.
But you can use a keyboard shortcut to paste only values:
1. Do a Ctrl+V as you did before
2. Then hit again only Ctrl, and after that, only V
It's not ideal, but much quicker than using the context menue with the mouse.
