Document Outline

• 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