Numbers
Table of Contents
Numbers User Guide for Mac
- Welcome
- What’s new in Numbers 14.1
-
- 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
-
- Change the spreadsheet view
- Customise the toolbar
- Show or hide the sidebar
- Change settings
- Set a default template
- Touch Bar for Numbers
-
- Use VoiceOver to create a spreadsheet
- Use VoiceOver to create formulas and autofill cells
-
- Add or delete a table
- Select cells, rows and columns
-
- Add or remove rows and columns
- Move rows and columns
- Resize rows and columns
- Merge or unmerge cells
-
- Change how table text looks
- Show, hide or edit a table title
- Change table grid colours
- Use table styles
- Resize, move or lock a table
-
-
- Add text to tables
- Add objects to cells
- Add stock information
- Autofill cells
- Copy, move or delete cell content
- Create a snapshot of a table
-
- Format dates, currency and more
- Create a custom cell format
- Add tickboxes and other controls to cells
- Format tables for bidirectional text
- Wrap text to fit in a cell
- Highlight cells
- Filter data
- Alphabetise or sort data in a table
-
- Intro to categories
- Add, edit or delete categories
- Change category groups
- Add calculations to summarise group data
-
- Intro to pivot tables
- Create a pivot table
- Add and arrange pivot table data
- Change how pivot table data is sorted, grouped and more
- Refresh a pivot table
- View the source data for a pivot table value
-
-
- Quickly calculate a sum, average and more
- Calculate values using data in table cells
- Use the Formulas and Functions Help
-
-
- Select data to make a chart
- Add column, bar, line, area, pie, doughnut and radar charts
- Add scatter and bubble charts
- Interactive charts
- Delete a chart
- Change a chart’s type
- Modify chart data
- Move and resize charts
-
- Change the look of data series
- Add a legend, gridlines and other markings
- Change the look of chart text and labels
- Add a chart border and background
- Use chart styles
-
-
- Select text
-
- Add text
- Copy and paste text
- Use dictation to enter text
- Use accents and special characters
-
- Format a spreadsheet for another language
- Use phonetic guides
- Use bidirectional text
- Use vertical text
-
- Change the font or font size
- Bold, italic, underline and strikethrough
- Change the colour of text
- Change text capitalisation
- Add a shadow or outline to text
-
- Intro to paragraph styles
- Apply a paragraph style
- Create, rename or delete paragraph styles
- Update or revert a paragraph style
- Use a keyboard shortcut to apply a style
-
- Adjust character spacing
- Add drop caps
- Raise and lower characters and text
- Format fractions automatically
- Create and use character styles
- Format dashes and quotation marks
- Format Chinese, Japanese or Korean text
-
- Set tab stops
- Align text
- Format text into columns
- Adjust line spacing
- Format lists
- Add and edit equations
- Add a highlight effect to text
- Add links
- Add borders and rules (lines) to separate text
-
-
- Add an image
- Add an image gallery
- Edit an image
-
- Add and edit a shape
- Combine or break apart shapes
- Draw a shape
- Save a shape to the shapes library
- Add and align text inside a shape
- Add 3D objects
- Add lines and arrows
- Animate, share or save drawings
-
- Add video and audio
- Record audio
- Edit video and audio
- Set movie and image formats
-
-
-
- Use rulers
- Position and align objects
- Use alignment guides
- Place objects inside a text box or shape
- Layer, group and lock objects
- 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
-
-
- Look up words
- Find and replace text
- Replace text automatically
- Check spelling
- Set author name and comment colour
- Highlight text
- Add and print comments
-
- Send a spreadsheet
- Intro to collaboration
- Invite others to collaborate
- Collaborate on a shared spreadsheet
- See the latest activity in a shared spreadsheet
- Change a shared spreadsheet’s settings
- Stop sharing a spreadsheet
- Shared folders and collaboration
- Use Box to collaborate
-
- 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
-
- Transfer spreadsheets with AirDrop
- Transfer spreadsheets with Handoff
- Transfer spreadsheets with the Finder
-
- Keyboard shortcuts
- Keyboard shortcut symbols
- Copyright
You can adjust text in a table cell, text box or shape so that it’s aligned to the left or right, centred, or aligned on both the left and right (justified).
Align and justify text
Select any portion of the text or click a text box or shape with text; if you’re working in a table, click a table cell or selectaroworcolumn.
In the Format sidebar, click the Text tab.
Click the Style button near the top of the sidebar, then click the alignment buttons you want.
Set text margins
Text in a text box, shape or table cell has a default amount of space between the text and the object that contains it. You can adjust that spacing by setting a different margin. You can also indent the first line of paragraphs to create a visual break that helps readers scan text.
Select the text whose margins you want to modify.
Do any of the following:
In the ruler, drag the margin marker (the blue triangle) and the first line indent marker (the blue rectangle) to where you want them. If you can’t see rulers, click in the toolbar, then choose Show Rulers.
Click the Style button near the top of the sidebar, then click one of the default indent buttons in the Alignment section to increase or decrease the indent of an entire paragraph.
Click the Text tab at the top of the sidebar, click the Layout button below the paragraph style, then click the disclosure arrow next to Indents.
See alsoFormat lists in Numbers on MacAdjust line spacing in Numbers on Mac
Thanks for your feedback.