Numbers User Guide for Mac
- Welcome
- What’s new in Numbers 14.2
-
- Get started with Numbers
- Intro to images, charts and other objects
- Create a spreadsheet
- Open or close spreadsheets
- Personalise templates
- Use sheets
- Undo or redo changes
- Save your spreadsheet
- Find a spreadsheet
- Delete a spreadsheet
- Print a spreadsheet
- Change the sheet background
- Touch Bar for Numbers
-
- Use iCloud with Numbers
- Import an Excel or text file
- Export to Excel or another file format
- Reduce the spreadsheet file size
- Save a large spreadsheet as a package file
- Restore an earlier version of a spreadsheet
- Move a spreadsheet
- Lock a spreadsheet
- Password-protect a spreadsheet
- Create and manage custom templates
- Copyright
Change text capitalisation in Numbers on Mac
You can set Numbers to automatically capitalise words at the beginning of sentences. You can also quickly make selected text all uppercase or lowercase or format text as a title, with the first letter of each word capitalised.
Capitalise sentences automatically
Choose Numbers > Settings (from the Numbers menu at the top of your screen).
Click Auto-Correction at the top of the settings window.
In the Spelling section, select the tick box next to “Capitalise words automatically”.
This setting applies only to Numbers, and not to other applications on your Mac.
Modify capitalisation with formatting
Go to the Numbers app
on your Mac, then open a spreadsheet.Select the text you want to change.
To change all the text in a text box or table cell, select the text box or table cell.
Note: Text typed in uppercase must be transformed to lowercase before formatting. See Modify capitalisation with transformations.
In the Format
sidebar, click the Text tab, then click the Style button near the top of the sidebar.In the Font section, click
, then click the Capitalisation pop-up menu and choose an option:
None: The text is left as you entered it, with no changes.
All Caps: All text is capitalised at the same height.
Small Caps: All text is capitalised with larger capitals for uppercase letters.
Title Case: The first letter of each word (except for prepositions, articles and conjunctions) is capitalised — for example, Seven Wonders of the World.
Start Case: The first letter of each word is capitalised — for example, Seven Wonders Of The World.
Modify capitalisation with transformations
Go to the Numbers app
on your Mac, then open a spreadsheet.Select the text you want to change, then choose Edit > Transformations (from the Edit menu at the top of your screen).
Choose an option to format selected text in all uppercase or all lowercase, or to capitalise the first letter of each word.