Change font to single size/style for entire spreadsheet in Numbers

Question

Change font to single size/style for entire spreadsheet in Numbers

I am trying to select all the cells of a spreadsheet to change all the text to a single, uniform font and size. It is a little distracting that entries copied and pasted from other apps (notes taken by me at different places and times) look a little different in the table.

I seem to be able to change it in selected cells, or as a new 'default' text for the spreadsheet, but even if I click that upper left circle symbol to select everything, changes to text via the format sidebar or selecting the 'text' menu do nothing.

MBP Tahoe 26.0.1

Numbers 14.4

MacBook Pro 16″, macOS 26.0

Posted on Oct 5, 2025 10:24 AM

Reply

Answer 1

Oct 5, 2025 12:45 PM in response to Donot_Haveone

No idea why, but reopening same spreadsheet and selecting all, this time the font style/size changes properly propagated through the entire spreadsheet. No idea why it worked this time and not last time. But basically no longer a question in need of an answer unless it happens again.

Reply

Answer 2

Badunit

Level 7

30,336 points

Oct 6, 2025 3:55 AM in response to Donot_Haveone

No idea here, either. It should have just worked.

In the future you might try Paste and Match Style instead of the normal Paste. Then you won't have to go back and change the text size of pasted in stuff. It is in the Edit menu or use the keyboard shortcut for it. I changed the shortcut to Shift Command V to make it easier (was Option Shift Command V). You can do that in System Settings->Keyboard->Keyboard Shortcuts->App Shortcuts. I did it for "all applications" because other apps have the same operation and shortcut combination. There was probably something else that had Shift Command V, but, whatever it was, I don't recall ever using it.

Reply

Answer 3

Oct 6, 2025 7:40 AM in response to Badunit

that's a good reminder for times when I'm working with my spreadsheet in numbers on the Mac. But I don't see that as an option in numbers on iOS and this is a spreadsheet that I use both ways.

Reply