Numbers
Numbers Help
Numbers User Guide
Contents
Preface: Welcome to Numbers ’09
Chapter 1: Numbers Tools and Techniques
Chapter 2: Creating, Saving, and Organizing a Numbers Spreadsheet
Chapter 3: Using Tables
Chapter 4: Working with Table Cells
Chapter 5: Working with Table Styles
Chapter 6: Using Formulas in Tables
Chapter 7: Creating Charts from Data
Chapter 8: Working with Text
Chapter 9: Working with Shapes, Graphics, and Other Objects
Chapter 10: Adding Address Book Data to a Table
Chapter 11: Sharing Your Numbers Spreadsheet
Chapter 12: Designing Your Own Numbers Spreadsheet Templates
Index
Numbers Help
Numbers ’09
Numbers > en_US
Numbers User Guide
Contents
Preface: Welcome to Numbers ’09
Chapter 1: Numbers Tools and Techniques
Spreadsheet Templates
The Numbers Window
Zooming In or Out
The Sheets Pane
Print View
Full-Screen View
The Toolbar
The Format Bar
The Inspector Window
Formula Tools
The Styles Pane
The Media Browser
The Colors Window
The Fonts Window
The Warnings Window
Keyboard Shortcuts and Shortcut Menus
Chapter 2: Creating, Saving, and Organizing a Numbers Spreadsheet
Creating a New Spreadsheet
Importing a Document from Another Application
Using CSV or OFX Files in a Spreadsheet
Opening an Existing Spreadsheet
Password-Protecting a Spreadsheet
Saving a Spreadsheet
Undoing Changes
Locking a Spreadsheet So It Can’t Be Edited
Automatically Saving a Backup Version
Saving a Copy of a Spreadsheet
Finding an Archived Version of a Spreadsheet
Saving a Spreadsheet as a Template
Saving Spotlight Search Terms for a Spreadsheet
Closing a Spreadsheet Without Quitting Numbers
Using Sheets to Organize a Spreadsheet
Adding and Deleting Sheets
Reorganizing Sheets and Their Contents
Changing Sheet Names
Dividing a Sheet into Pages
Setting a Spreadsheet’s Page Size
Adding Headers and Footers to a Sheet
Arranging Objects on a Page in Print View
Setting Page Orientation
Setting Pagination Order
Numbering Pages
Setting Page Margins
Chapter 3: Using Tables
Working with Tables
Adding a Table
Using Table Tools
Resizing a Table
Moving Tables
Naming Tables
Enhancing the Appearance of Tables
Defining Reusable Tables
Copying Tables Among iWork Applications
Selecting Tables and Their Components
Selecting a Table
Selecting a Table Cell
Selecting a Group of Table Cells
Selecting a Row or Column in a Table
Selecting Table Cell Borders
Working with Rows and Columns in Tables
Adding Rows to a Table
Adding Columns to a Table
Rearranging Rows and Columns
Deleting Table Rows and Columns
Adding Table Header Rows or Header Columns
Freezing Table Header Rows and Header Columns
Adding Table Footer Rows
Resizing Table Rows and Columns
Alternating Table Row Colors
Hiding Table Rows and Columns
Sorting Rows in a Table
Filtering Rows in a Table
Creating Table Categories
Defining Table Categories and Subcategories
Removing Table Categories and Subcategories
Managing Table Categories and Subcategories
Chapter 4: Working with Table Cells
Putting Content into Table Cells
Adding and Editing Table Cell Values
Working with Text in Table Cells
Working with Numbers in Table Cells
Autofilling Table Cells
Displaying Content Too Large for Its Table Cell
Using Conditional Formatting to Monitor Table Cell Values
Defining Conditional Formatting Rules
Changing and Managing Your Conditional Formatting
Adding Images or Color to Table Cells
Merging Table Cells
Splitting Table Cells
Formatting Table Cell Borders
Copying and Moving Cells
Adding Comments to Table Cells
Formatting Table Cell Values for Display
Using the Automatic Format in Table Cells
Using the Number Format in Table Cells
Using the Currency Format in Table Cells
Using the Percentage Format in Table Cells
Using the Date and Time Format in Table Cells
Using the Duration Format in Table Cells
Using the Fraction Format in Table Cells
Using the Numeral System Format in Table Cells
Using the Scientific Format in Table Cells
Using the Text Format in Table Cells
Using a Checkbox, Slider, Stepper, or Pop-Up Menu in Table Cells
Using Your Own Formats for Displaying Values in Table Cells
Creating a Custom Number Format
Defining the Integers Element of a Custom Number Format
Defining the Decimals Element of a Custom Number Format
Defining the Scale of a Custom Number Format
Associating Conditions with a Custom Number Format
Creating a Custom Date/Time Format
Creating a Custom Text Format
Changing a Custom Cell Format
Reordering, Renaming, and Deleting Custom Cell Formats
Chapter 5: Working with Table Styles
Using Table Styles
Applying Table Styles
Modifying Table Style Attributes
Copying and Pasting Table Styles
Using the Default Table Style
Creating New Table Styles
Renaming a Table Style
Deleting a Table Style
Chapter 6: Using Formulas in Tables
The Elements of Formulas
Performing Instant Calculations
Using Predefined Quick Formulas
Creating Your Own Formulas
Adding and Editing Formulas Using the Formula Editor
Adding and Editing Formulas Using the Formula Bar
Adding Functions to Formulas
Handling Errors and Warnings in Formulas
Removing Formulas
Referring to Cells in Formulas
Using the Keyboard and Mouse to Create and Edit Formulas
Distinguishing Absolute and Relative Cell References
Using Operators in Formulas
The Arithmetic Operators
The Comparison Operators
Copying or Moving Formulas and Their Computed Values
Viewing All Formulas in a Spreadsheet
Finding and Replacing Formula Elements
Chapter 7: Creating Charts from Data
About Charts
Creating a Chart from Table Data
Changing a Chart from One Type to Another
Moving a Chart
Switching Table Rows and Columns for Chart Data Series
Adding More Data to an Existing Chart
Including Hidden Table Data in a Chart
Replacing or Reordering Data Series in a Chart
Removing Data from a Chart
Deleting a Chart
Sharing Charts with Pages and Keynote Documents
Formatting Charts
Placing and Formatting a Chart’s Title and Legend
Resizing or Rotating a Chart
Formatting Chart Axes
Formatting the Elements in a Chart’s Data Series
Showing Error Bars in Charts
Showing Trendiness in Charts
Formatting the Text of Chart Titles, Labels, and Legends
Formatting Specific Chart Types
Customizing the Look of Pie Charts
Changing Pie Chart Colors and Textures
Showing Labels in a Pie Chart
Separating Individual Wedges from a Pie Chart
Adding Shadows to Pie Charts and Wedges
Rotating 2D Pie Charts
Setting Shadows, Spacing, and Series Names on Bar and Column Charts
Customizing Data Point Symbols and Lines in Line Charts
Showing Data Point Symbols in Area Charts
Using Scatter Charts
Customizing 2-Axis and Mixed Charts
Adjusting Scene Settings for 3D Charts
Chapter 8: Working with Text
Adding Text
Selecting Text
Deleting, Copying, and Pasting Text
Formatting Text Size and Appearance
Making Text Bold, Italic, or Underlined
Adding Shadow and Strikethrough to Text
Creating Outlined Text
Changing Text Size
Making Text Subscript or Superscript
Changing Text Capitalization
Changing Fonts
Adjusting Font Smoothing
Adding Accent Marks
Viewing Keyboard Layouts for Other Languages
Typing Special Characters and Symbols
Using Smart Quotes
Using Advanced Typography Features
Setting Text Alignment, Spacing, and Color
Aligning Text Horizontally
Aligning Text Vertically
Setting the Spacing Between Lines of Text
Setting the Spacing Before or After a Paragraph
Adjusting the Spacing Between Characters
Changing Text and Text Background Color
Setting Tab Stops to Align Text
Setting a New Tab Stop
Changing a Tab Stop
Deleting a Tab Stop
Changing Ruler Settings
Setting Indents
Setting Indentation for Paragraphs
Changing the Inset Margin of Text in Objects
Creating Lists
Generating Lists Automatically
Formatting Bulleted Lists
Formatting Numbered Lists
Formatting Ordered Lists
Using Text Boxes, Shapes, and Other Effects to Highlight Text
Adding Text Boxes
Presenting Text in Columns
Putting Text Inside a Shape
Using Hyperlinks
Linking to a Webpage
Linking to a Preaddressed Email Message
Editing Hyperlink Text
Inserting Page Numbers and Other Changeable Values
Automatically Substituting Text
Inserting a Nonbreaking Space
Checking for Misspelled Words
Working with Spelling Suggestions
Searching for and Replacing Text
Chapter 9: Working with Shapes, Graphics, and Other Objects
Working with Images
Replacing Template Images with Your Own Images
Masking (Cropping) Images
Reducing Image File Sizes
Removing the Background or Unwanted Elements from an Image
Changing an Image’s Brightness, Contrast, and Other Settings
Creating Shapes
Adding a Predrawn Shape
Adding a Custom Shape
Editing Shapes
Adding, Deleting, and Moving the Editing Points on a Shape
Reshaping a Curve
Reshaping a Straight Segment
Transforming Corner Points into Curved Points and Vice Versa
Editing a Rounded Rectangle
Editing Single and Double Arrows
Editing a Quote Bubble or Callout
Editing a Star
Editing a Polygon
Using Sound and Movies
Adding a Sound File
Adding a Movie File
Placing a Picture Frame Around a Movie
Adjusting Media Playback Settings
Reducing the Size of Media Files
Manipulating, Arranging, and Changing the Look of Objects
Selecting Objects
Copying or Duplicating Objects
Deleting Objects
Moving and Positioning Objects
Moving an Object Forward or Backward (Layering Objects)
Quickly Aligning Objects Relative to One Another
Using Alignment Guides
Creating Your Own Alignment Guides
Positioning Objects by x and y Coordinates
Grouping and Ungrouping Objects
Connecting Objects with an Adjustable Line
Locking and Unlocking Objects
Modifying Objects
Resizing Objects
Flipping and Rotating Objects
Changing the Style of Borders
Framing Objects
Adding Shadows
Adding a Reflection
Adjusting Opacity
Filling Objects with Colors or Images
Filling an Object with a Solid Color
Filling an Object with Blended Colors (Gradients)
Filling an Object with an Image
Working with MathType
Chapter 10: Adding Address Book Data to a Table
Using Address Book Fields
Mapping Column Names to Address Book Field Names
Adding Address Book Data to an Existing Table
Adding Address Book Data to a New Table
Chapter 11: Sharing Your Numbers Spreadsheet
Printing a Spreadsheet
Exporting a Spreadsheet to Other Document Formats
Exporting a Spreadsheet in PDF Format
Exporting a Spreadsheet in Excel Format
Exporting a Spreadsheet in CSV Format
Sending Your Numbers Spreadsheet to iWork.com public beta
Sending a Spreadsheet Using Email
Sending a Spreadsheet to iWeb
Sharing Charts, Data, and Tables with other iWork Applications
Chapter 12: Designing Your Own Numbers Spreadsheet Templates
Designing a Template
Defining Table Styles for a Custom Template
Defining Reusable Tables for a Custom Template
Defining Default Charts, Text Boxes, Shapes, and Images for a Custom Template
Defining Default Attributes for Charts
Defining Default Attributes for Text Boxes and Shapes
Defining Default Attributes for Imported Images
Creating Initial Spreadsheet Content for a Custom Template
Predefining Tables and Other Objects for a Custom Template
Creating Media Placeholders for a Custom Template
Predefining Sheets for a Custom Template
Saving a Custom Template
Index
Numbers
Dansk
Deutsch
English
Español
Suomi
Français
Italiano
日本語
한글
Nederlands
Norsk (bokmål)
Polski
Português (Brasil)
Português
Русский
Svenska
简体中文
繁體中文