Share via

When I copy and paste data from one Excel sheet to another, why can't I paste and "Keep Destination Formatting"?

Anonymous
2023-05-30T03:15:17+00:00

I am using Office 365 on MacOs Ventura 13.4. The "Keep Destination Formatting" option is not even available in the Paste Special menu.

Microsoft 365 and Office | Excel | For home | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-03T04:03:59+00:00

    Thanks Sneha, but Command+Option+V just opens the Paste Special options and as such, has no option to apply destination formatting in my circumstance which goes back to the original question in this thread. I have as you suggested, provided feedback looking to the future, but for now I have ceded to current capability and have created a macro which converts the source data to the format I want in the destination sheet.

    3 people found this answer helpful.
    0 comments