How do I paste data into a Numbers spreadsheet without also pasting in the style of the text?

I want to know how to be able to paste information into a Numbers spreadsheet without also pasting in the styling of the text such as font, text colour, background colour, etc.

Thanks.

MacBook Pro 15″, macOS 13.3

Posted on May 21, 2023 2:05 AM

Top-ranking reply

SGIII

Level 8

36,434 points

Posted on May 21, 2023 4:59 AM

Try using Edit > Paste and Match Style.

There is a keyboard shortcut for that (listed in the menu if you forget it): option-shift-command-v.

View in context

Similar questions

How do I copy many lines of text from TextEdit to Numbers? Hi. When I copy and paste many lines of text from TextEdit (⌘A ⌘C) to Numbers spreadsheet (select the first cell of the column then ⌘V) they are pasted not properly. So how do I paste them into one column (A) properly? What am I doing wrong??
1405 3
Formatting in Numbers when Copy Pasting Hello everyone, I'm currently creating a spreadsheet in Numbers in which people will need to copy and paste text from another document. The other document has the text in another formatting and when we copy and paste the formatting is kept instead of using the one of the new spreadsheet. I know there is a way to copy and paste without keeping the formatting using a different shortcut, but I was wondering if anyone knew of a way to force the formatting in a table or spreadsheet when copy and pasting without having to use another shortcut ? I'm not sure if I was clear in my explanation but I hope someone has a solution :D Thanks !
4041 3
can the text in Numbers table be converted to text in Pages? How can I convert information in a Numbers spreadsheet to a Pages document without the table formatting. That is, I want to take information from the cells of a spreadsheet and convert to text in a non-spreadsheet application (Pages, for instance) for paragraph formatting? I've inherited information that is in a spreadsheet that should have bee composed in a text document and need to convert it without rekeying the text.
597 2

2 replies

Top-ranking reply

SGIII

Level 8

36,434 points

May 21, 2023 4:59 AM in response to Community User

Try using Edit > Paste and Match Style.

There is a keyboard shortcut for that (listed in the menu if you forget it): option-shift-command-v.

May 21, 2023 7:49 PM in response to SGIII

Works perfectly!

Thank you.

How do I paste data into a Numbers spreadsheet without also pasting in the style of the text?