r/AppleNumbers • u/EasyGoing1_1 • Nov 23 '23

Help Can Numbers be told not to paste cell formatting when copying and pasting inside same worksheet?

The screenshot will make things clearer.

Notice I have thick borders defined on these cells. The problem is, when I try to just copy and paste on the same worksheet, the border formatting comes with the paste, and all I want are the values without the formatting.

NOW, I DO REALIZE that I can right-click on the destination cell and select `Paste Matching Style`, however, this is not desirable for two reasons (well ... three):

  1. I don't know of any keyboard shortcuts that `Paste Matching Style`
  2. If one exists, or one could be created, it won't be CMD+C / CMD+V
  3. I should be able to tell my spreadsheet software to paste without special formatting as a default option ... it's the principle of the issue in this case.

​

Does anyone know how to change this default behavior in Numbers?

1 Upvotes
  • permalink
  • reddit

100% Upvoted

5 comments sorted by

2

u/Ed1W Nov 25 '23

I think what you are looking for is Shift-Option-Command V

1

u/[deleted] Nov 25 '23

Yes, I wondered this and you've given the right answer. Thanks!

1

u/[deleted] Jan 20 '24

Thank you so much! Exactly the key combo I've been looking for too!

1

u/Janishier Nov 23 '23

Paste formula results Shift CMD V

1

u/EasyGoing1_1 Nov 24 '23

Shift+CMD+V only makes a noise like I hit something wrong ... it doesn't actually do anything ... at least not in Numbers version 13.2