Excel copy-paste: always match destination formatting

ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Excel copy-paste: always match destination formatting

Message par ForumBot »

Excel copy-paste: always match destination formatting
ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Re: Excel copy-paste: always match destination formatting

Message par ForumBot »

Can't set the default, but more convenient than fiddling with the paste options after each paste:


If you press the Backspace or F2 key before pasting text it will paste
the text only, retaining the existing formatting.

source: [http://appscout.pcmag.com/business-financial/272436-always-match-destination-formatting](http://appscout.pcmag.com/business-financial/272436-always-match-destination-formatting)

*I wonder why this works?*
Répondre

Revenir à « Excel & VBA »