View original (French)

Default paste setting

Solved
Nak -  
 Nak -
Hello,

Following a new position, I am required to perform numerous copy/pastes using Excel. I haven't found how to change the default settings for pasting.

I would like the default setting for my documents to be "Match Destination Formatting" instead of "Keep Source Formatting."

My version of Excel: "Microsoft Office Home and Business 2013" Version "15.0.5031.1000"

Thank you in advance!

Configuration: Windows / Chrome 67.0.3396.99

2 answers

Answer 1 / 2
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 783
 
Hello,

We cannot change the functionality of Paste
However, we can use Paste Special, Values or Formulas as appropriate, which can be accessed directly by right-clicking.

--
Best regards
Patrice
0
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Bonjour
(hi Patrice)... or by using the option icons when right-clicking on the cell, it's very convenient for full paste, values, formulas, transpose, link
But I don't know if it's available before 2013.
0
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 783
 
Hello Forum,
Hello Vaucluse, the Paste Options icons have been available since Excel 2010.
0
Nak
 
Thank you very much for your response, and have a great day!
0