Numbers User Guide for Mac
- 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
- Use VoiceOver to create a spreadsheet
- 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 rules (lines) to separate text
- Add lines and arrows
- Animate, share or save drawings
- Set movie and image formats
- Change object transparency
- Fill objects 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
Place objects inside a text box or shape in Numbers on Mac
You can place images, image galleries, videos, shapes and equations inside a text box or shape. The inner (nested) object automatically appears inline with any text in the outer text box or shape (parent object), so that it sits with and moves with the text as you type.
Place objects inline with text in a text box or shape
If you haven’t already added a text box or shape to your sheet, or haven’t added the object you want to paste inside it, click the object buttons in the toolbar to add the objects you want to work with.
Select the object you want to nest inside a text box or shape, then press Command-X to cut it.
If the object is on the sheet, click to select it; if it’s inline with text, double-click to select it.
Double-click the text box or shape where you want to paste the object so the insertion point appears inside it, then press Command-V to paste the object.
The pasted object is nested inside the parent object. If you see a clipping indicator at the bottom of the object, you need to resize it to see all its contents.
To add text after the nested object, click inside the parent object so you see the insertion point, then type.
If you accidentally select the nested object (three selection handles appear), click outside it to move the insertion point into the parent object.
Tip: If the nested object is a shape, you can place an image, shape or equation inside it. Select the nested object, double-click inside it to see the insertion point, then type or paste the new text or object inside it.
Move an inline object to the sheet
You can move an inline object to the sheet so that it’s no longer nested inside another object.
Double-click the inline object to select it.
In the Format sidebar, click the Arrange tab.
Click Move to Sheet.