View original (French)

Pasting while respecting the destination formatting

Iama Posted messages 324 Status Membre -  
m@rina Posted messages 27198 Registration date   Status Modérateur 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 réponses

Réponse 1 / 3
m@rina Posted messages 27198 Registration date   Status Modérateur Last intervention   11 542
 
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
Iama Posted messages 324 Status Membre 14
 
Good idea m@rina,
failing a more radical solution, I'm on board.

Best regards
Alain
0
Iama Posted messages 324 Status Membre 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