Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • This has nothing to do with hitting "CTRL+V" Commented Apr 15, 2021 at 0:40
  • This seems to always keep the source formatting rather than match the target formatting, which is the opposite of what was asked. Commented Jun 23, 2021 at 10:57
  • @AdamV The "paste and match destination format" option can be found directly beneath. Commented Jul 15, 2021 at 9:58
  • The "paste and match Destination formatting" is no longer available in excel 365 Version 2302. Sad, making this your ctrl+V shortcut would be the best solution. (there are only 7 paste options now) Commented Apr 10, 2023 at 16:27