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
Layer, group and lock objects in Numbers on Mac
You can work with and arrange the objects on a sheet in a number of ways:
Layer (or stack) objects to create the appearance of depth
Group objects to more easily move, resize or rotate them as a single unit
Lock objects to avoid inadvertently moving, modifying or deleting them
Drag an object so it overlaps with one or more other objects.
In the Format sidebar, click the Arrange tab at the top of the sidebar.
With the object selected, do one of the following:
Move the object one increment at a time: Click Forward or Backward.
Move an object to the very front or back of the stack: Click Front or Back.
You can select multiple objects to layer them all at once.
Tip: You can open the Arrange controls in a separate window that you can move anywhere. Choose View > Show Arrange Tools (from the View menu at the top of your screen, not from the View menu in the toolbar). You can also add buttons to the toolbar for Forward, Backward, Front and Back.
Group or ungroup objects
Lock or unlock objects
When an object is locked, you can’t move, delete or modify it in any way until you unlock it.
Click an object to select it or select multiple objects.
Do either of the following:
Lock: Choose Arrange > Lock (from the Arrange menu at the top of your screen).
Unlock: Choose Arrange > Unlock.
Alternatively, select one or more objects. In the Format sidebar, click the Arrange tab, then click Lock or Unlock (near the bottom of the sidebar).
Tip: You can add buttons to the toolbar for locking and unlocking objects.