Numbers
Numbers User Guide for iCloud
- Welcome
- What’s new in Numbers for iCloud
-
- Intro to Numbers for iCloud
- Intro to tables and other objects
- Create a spreadsheet
- Organize with sheets
- Change the sheet background
- Upload a spreadsheet
- Sync a spreadsheet
- Print a spreadsheet
- Change the spreadsheet view
-
- If you can’t find a spreadsheet
- Resolve spreadsheet conflicts
-
- Add or delete tables
- Select cells, rows, columns, or tables
- Add or change rows and columns
- Merge and unmerge cells
-
- Change the look of table text
- Change table gridlines and colors
- Format tables for bidirectional text
-
- Enter text and numbers
- Add formulas
- Change an existing formula
- Add checkboxes and other controls
- Clear cell content and formatting
- Format as currency or other data
- Use Formulas and Functions Help
-
- Alphabetize or sort data
- Filter data
-
- Intro to categories
- Add or edit categories
- Edit groups in a categorized table
- Summarize group data
-
- Intro to pivot tables
- Create a pivot table
- Add and arrange pivot table data
- Change how pivot table data is sorted and grouped
- Refresh a pivot table
- View the source data for a value
-
- Create or delete a chart
- Edit chart data
- Edit chart text and markings
- Change how data is displayed
- Change the chart background
- Change a chart’s type
-
- Add text to a spreadsheet
- Select text
- Copy and paste text
- Add bulleted or numbered lists
-
- Change the font, size, style, or color of text
- Add drop caps
- Raise and lower text
- Add a shadow to text
- Change text capitalization
-
- Adjust alignment and spacing
- Format columns of text
- Adjust character spacing
- Add borders and rules (lines)
- Add a background color to text
- Link to a website, email, phone number, or sheet
-
- Write in another language
- Change the text direction
- Create a spreadsheet with the formatting of a different language
-
-
- Add or replace images
- Add an image gallery
- Crop (mask) an image
-
- Add shapes and lines
- Edit shapes and lines
- Combine or break apart shapes
- Add text inside a shape
- Add video and audio
-
-
-
- Move and align objects
- Resize objects
- Rotate or flip objects
- Connect objects with a line
- Place objects inside a text box or shape
- Layer, group, and lock objects
- Customize the look of objects
- Add a title or caption
- Apply object styles
- Fill shapes and text boxes with colors or images
-
-
- Email a spreadsheet
-
- Intro to collaboration
- Invite others to collaborate
- Collaborate on a spreadsheet
- Change shared spreadsheet settings
- Stop sharing spreadsheets
- Shared folders and collaboration
- Use Box to collaborate
-
- Save, name, or duplicate spreadsheets
- Delete or recover spreadsheets
- Restore earlier versions
- Organize spreadsheets
- Password-protect spreadsheets
- Download spreadsheets
-
- Spell-check text
- Find and replace text
- Add or reply to comments
- Set your author name and color
- Keyboard shortcuts
- Legal notices and acknowledgements
- Copyright
Numbers for iCloud supports bidirectional text, so you can enter and edit text written from left to right (such as in English or Chinese) and from right to left (such as in Arabic or Hebrew) in the same spreadsheet.
Create a new spreadsheet or open an existing one, and make sure it contains at least one character typed in a right-to-left language.
For instructions on writing in other languages, see Write in another language.
Click in the paragraph whose text direction you want to change.
If you select multiple paragraphs, the text in all of them is formatted to match the first one you selected.
In the Format sidebar on the right, click the Style button near the top.
Click the Text Direction button to the right of the alignment buttons.
If you don’t see the Text Direction button, make sure that a right-to-left language is selected in the input menu, or that your spreadsheet includes right-to-left text.
The insertion point (or any selected text) moves to the other side, and the paragraph direction changes. The next paragraph continues in the same direction. To change its direction, click the direction button again.
If you’re working in a table, you can also reverse the direction of tables and sheets. See Format tables and sheets for bidirectional text.
See alsoWrite in another language in Numbers for iCloudCreate a spreadsheet with the formatting of a different language in Numbers for iCloud
Thanks for your feedback.