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

  1.
    Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
     
    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
    1. 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
    2. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 784
       
      Hello Forum,
      Hello Vaucluse, the Paste Options icons have been available since Excel 2010.
      0
    3. Nak
       
      Thank you very much for your response, and have a great day!
      0