View original (French)

Pasting while respecting the destination formatting

Iama Posted messages 324 Status Member -  
m@rina Posted messages 27623 Registration date   Status Moderator Last intervention   -
Hello,

I would like to know if there is an option in Excel to enforce this type of paste instead of "Keep Source Formatting."

Tired of searching and doing the manual process regularly, I turn to you.

Best regards

Configuration: Windows Vista / Firefox 29.0

3 answers

  1.
    m@rina Posted messages 27623 Registration date   Status Moderator Last intervention   11 563
     
    Hello,

    All you need to do is add the command "Paste and keep source formatting" to the Quick Access Toolbar. That way, to paste, you will just have to click on this button.

    m@rina

    --
    How it works is a public forum. I do not respond to questions asked via private message.
    2
    1. Iama Posted messages 324 Status Member 14
       
      Good idea m@rina,
      failing a more radical solution, I'm on board.

      Best regards
      Alain
      0
    2. Iama Posted messages 324 Status Member 14
       
      I just tested it,
      unfortunately, it does not work when the copy is made from "a source other than Excel (website).

      But I will keep the button
      best regards
      0