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

37,448 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

Data pasted into Numbers copied from Google Sheets is getting transposed and missing Hi, I regularly copy a section of a Google Sheets spreadsheet into a Numbers document Since updating to Sonoma, when attempting to do this same task, the information is getting transposed a bit, but also missing quite a bit. If I copy a section that includes data from three rows, when pasting into Numbers it will only paste into one column and only a few of the cells appear. Update - Now, all of the data appears, but in a single cell and every cell that was copied is showing as a new line within that cell. Maybe someone knows about the problem already?
1220 4
I am new to Numbers. Have made SIMPLE spreadsheets in Excel for years. How/Where can I learn easy ways to use Numbers? I am new to Numbers. Have made SIMPLE spreadsheets in Excel for years. How/Where can I learn easy ways to use Numbers?I am new to Numbers.
734 2
Can't paste cells from Numbers into Pages I created a spreadsheet in Numbers and when I select and copy the cells of the sheet and try to paste them into Pages, it won't paste. The content is in the clipboard because I'm able to paste into other programs. I've just updated the OS and Numbers but that didn't fix it. I've also tried creating a table in Pages and pasting into the table but that doesn't work either. The great irony here is that if I export it to XLSX and copy from Excel, I can paste into Pages from Excel! I'm on a 2022 Macbook Pro.
2901 3

2 replies

Top-ranking reply

SGIII

Level 8

37,448 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?