Numbers User Guide for Mac
- What’s new in Numbers 13.2
- Intro to 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
- Wrap text to fit in a cell
- Highlight cells
- Filter data
- Alphabetise or sort data in a table
- Modify chart data
- Move and resize charts
- Select text and place the insertion point
- Use a keyboard shortcut to apply a style
- Format lists
- Add and edit equations
- Add a highlight effect to text
- Add links
- Add borders and rules (lines) to separate text
- Add 3D objects
- Add lines and arrows
- Animate, share or save drawings
- Set movie and image formats
- Change object transparency
- Fill shapes and text boxes with colour or an image
- Add a border to an object or sheet
- Add a caption or title
- Add a reflection or shadow
- Use object styles
- Resize, rotate and flip objects
- 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
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 tickbox next to “Capitalise words automatically”.
This setting applies only to Numbers, and not to other applications on your Mac.
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.
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.