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
- Personalize 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
- Customize 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 colors
- 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 checkboxes and other controls to cells
- Format tables for bidirectional text
- Wrap text to fit in a cell
- Highlight cells
- Filter data
- Alphabetize or sort data in a table
-
- Intro to categories
- Add, edit, or delete categories
- Change category groups
- Add calculations to summarize 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, donut, 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 color of text
- Change text capitalization
- 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 color 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 color
- 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 resize an object freely, to modify its proportions any way you like, or proportionally, to make it larger or smaller without changing its essential shape. You can also set it to have specific dimensions. You can rotate or flip any object except a table, chart, or image gallery.
Resize an object
Click an object or group of objects to select it.
If you don’t see white squares around the object, the object is locked; you must unlock it before you can resize it.
To choose whether the object resizes freely or proportionally, in the Format sidebar, click the Arrange tab at the top of the sidebar, then do one of the following:
Resize freely: Make sure the “Constrain proportions” checkbox (below Size) is unselected.
Resize proportionally: Make sure the “Constrain proportions” checkbox (below Size) is selected.
Note: Groups containing certain objects can only be resized proportionally. These objects include images and movies that have been rotated, shapes that have a green dot when selected, and 3D objects.
Do one of the following:
Resize freely: Drag a selection handle on the top, bottom, or sides (not a corner) of the object.
This action is possible only if Constrain Proportions is turned off (see step 2, above).
Resize proportionally: Drag a corner selection handle diagonally.
Resize to specific dimensions: In the Arrange tab at the top of the sidebar on the right, enter values in the Width and Height fields, or click the arrows next to the fields.
Rotate an object
Note: You can’t rotate a table, chart, or image gallery. If you want to rotate a 3D object, see Add 3D objects.
Click the object to select it, or select multiple objects.
In the Format sidebar, click the Arrange tab.
Drag the Rotate wheel, or enter a degree value in the adjacent field to specify the angle at which you want to rotate the object.
Tip: You can also press the Command key while your pointer is over a white square on the object, then drag to rotate.
Flip an object
Note: You can’t flip a table, chart, image gallery, or 3D object.
Click the object to select it, or select multiple objects.
In the Format sidebar, click the Arrange tab.
Click a Flip button (near the Rotate wheel) to flip the object vertically or horizontally.
Tip: You can add these buttons to the toolbar: Flip Horizontal and Flip Vertical.
See alsoMask (crop) a photoPosition and align objects in Numbers on Mac
Thanks for your feedback.