Document Outline

• Contents
• Welcome to the NumbersUser’sGuide
• Numbers Tools and Techniques
  • Spreadsheet Templates
  • The Numbers Window
  • Spreadsheet Viewing Aids
    • Zooming In or Out
    • The Sheets Pane
    • Print View
    • Alignment Guides
  • The Styles Pane
  • The Toolbar
  • The Format Bar
  • The Inspector Window
  • Formula Tools
  • The Media Browser
  • The Colors Window
  • The Font Panel
  • The Warnings Window
  • Keyboard Shortcuts and Shortcut Menus
• Working with a Numbers Spreadsheet
  • Creating, Opening, and Importing Spreadsheets
    • Creating a New Spreadsheet
    • Importing a Document
    • Opening an Existing Spreadsheet
  • Saving Spreadsheets
    • Saving a Spreadsheet
    • Undoing Changes
    • Automatically Saving a Backup Version of a Spreadsheet
    • Saving a Spreadsheet as a Template
    • Saving Search Terms for a Spreadsheet
    • Saving a Copy of a Spreadsheet
    • Closing a Spreadsheet Without Quitting Numbers
  • Using Sheets to Organize a Spreadsheet
    • Viewing Sheets
    • Adding and Deleting Sheets
    • Reorganizing Sheets and Their Contents
    • Changing Sheet Names
  • Dividing a Sheet into Pages
    • Setting a Spreadsheet’s Page Size
    • Using Headers and Footers
    • Arranging Objects on a Page
    • Setting Page Orientation
    • Setting Pagination Order
    • Numbering Pages
    • Setting Page Margins
• Using Tables
  • About Tables
  • Working with Tables
    • Adding a Table
    • Using Table Tools
    • Resizing a Table
    • Moving Tables
    • Naming 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
    • Selecting Table Cell Borders
  • Working with Content in Table Cells
    • Adding and Editing Cell Values
    • Working with Text in Cells
    • Working with Numbers in Cells
    • Working with Dates in Cells
    • Displaying Content Too Large for Its Cell
    • Formatting Cell Values
      • Using the Number Format
      • Using the Currency Format
      • Using the Percentage Format
      • Using the Date and Time Format
      • Using the Fraction Format
      • Using the Scientific Format
      • Using the Text Format
      • Using a Checkbox and Other Control Formats
    • Monitoring Cell Values
    • Adding Images or Color to Cells
    • Autofilling Table Cells
  • Working with Rows and Columns
    • Adding Rows
    • Adding Columns
    • Rearranging Rows and Columns
    • Deleting Table Rows and Columns
    • Using a Table Header Row or Column
    • Using a Footer Row
    • Hiding Rows and Columns
    • Resizing Table Rows and Columns
    • Alternating Row Colors
  • Working with Table Cells
    • Merging Table Cells
    • Splitting Table Cells
    • Formatting Table Cell Borders
    • Copying and Moving Cells
    • Adding Comments
  • Reorganizing Tables
    • Sorting Table Cells
    • Filtering Rows
• Working with Table Styles
  • Using Table Styles
  • Applying Table Styles
  • Modifying a Table’s Style
    • 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
• Using Formulas and Functions in Tables
  • Using Formulas
    • A Tour of Using Formulas
    • Performing Instant Calculations
    • Adding a Quick Formula
      • Performing a Basic Calculation Using Column Values
      • Performing a Basic Calculation Using Row Values
    • Removing a Formula
    • Using the Formula Editor
      • Adding a New Formula with the Formula Editor
      • Editing a Formula with the Formula Editor
    • Using the Formula Bar
      • Adding a New Formula with the Formula Bar
      • Editing a Formula with the Formula Bar
    • Using Cell References
      • Adding Cell References to a Formula
      • Copying or Moving Formulas with Cell References
    • Applying a Formula Once to Cells in a Column or Row
    • Handling Errors and Warnings
  • Using Operators
    • Performing Arithmetic Operations
    • Understanding the Arithmetic Operators
    • Understanding the Comparison Operators
  • Using Functions
• Using Charts
  • About Charts
  • Adding a Chart
  • Editing Charts
    • Changing the Plotting Orientation
    • Changing the Data Plotted in a Chart
      • Adding Data to a Chart
      • Adding Data to a Chart from Multiple Tables
      • Removing Data from a Chart
      • Replacing a Data Series
    • Deleting a Chart
    • Moving a Chart
    • Changing a Chart from One Type to Another
  • Formatting General Chart Attributes
    • Using a Legend
    • Using a Chart Title
    • Resizing a Chart
    • Rotating Charts
    • Adding Labels and Axis Markings
      • Showing Axes and Borders
      • Using Axis Titles
      • Showing Data Point Labels
      • Formatting the Value Axis
      • Placing Labels, Gridlines, and Tick Marks
    • Formatting the Elements in a Data Series
    • Formatting Titles, Labels, and Legends
    • Adding Descriptive Text to a Chart
  • Formatting Specific Types of Charts
    • Pie Charts
      • Selecting Individual Pie Wedges
      • Showing Series Names in a Pie Chart
      • Separating Individual Pie Wedges
      • Adding Shadows to Pie Charts and Wedges
      • Adjusting the Opacity of Pie Charts
      • Rotating 2D Pie Charts
    • Bar and Column Charts
      • Adjusting Spacing of Bar and Column Charts
      • Adding Shadows to Bar and Column Charts
      • Adjusting the Opacity of Bar and Column Charts
    • Area Charts and Line Charts
    • Scatter Charts
    • 3D Charts
• Working with Text
  • Adding Text
  • Deleting, Copying, and Pasting Text
  • Selecting Text
  • Formatting Text Size and Appearance
    • Using the Format Bar to Format Text
    • Using the Format Menu to Format Text
      • Making Text Bold or Italic Using the Menus
      • Creating Outlined Text Using the Menus
      • Underlining Text Using the Menus
      • Changing Text Size Using the Menus
      • Making Text Subscript or Superscript Using the Menus
      • Changing Text Capitalization Using the Menus
    • Using the Font Panel to Format Text
      • Making the Font Panel Easy to Use
      • Changing Fonts Using the Font Panel
      • Changing Underlining Using the Font Panel
      • Adding a Strikethrough to Text Using the Font Panel
      • Changing Text Color Using the Font Panel
      • Changing the Paragraph Background Color Using the Font Panel
      • Creating Shadows on Text Using the Font Panel
    • Adding Accents and Special Characters
      • Adding Accent Marks
      • Viewing Keyboard Layouts for Other Languages
      • Typing Special Characters and Symbols
      • Using Smart Quotes
    • Using Advanced Typography Features
  • Adjusting Font Smoothing
  • Setting Text Alignment, Spacing, and Color
    • Aligning Text Horizontally
    • Aligning Text Vertically
    • Adjusting the Spacing Between Lines of Text
    • Adjusting the Spacing Before or After a Paragraph
    • Adjusting the Spacing Between Characters
    • Changing Text Color
  • Setting Tab Stops to Align Text
    • Setting a New Tab Stop
    • Changing a Tab Stop
    • Deleting a Tab Stop
  • Setting Indents
    • Setting Indents for Paragraphs
    • Changing the Inset Margin of Text in Objects
    • Setting Indents for Lists
  • Using Bulleted, Numbered, and Ordered Lists (Outlines)
    • Generating Lists Automatically
    • Using Bulleted Lists
    • Using Numbered Lists
    • Using Ordered Lists (Outlines)
  • Using Text Boxes and Shapes to Highlight Text
    • Adding Text Boxes
    • Presenting Text in Columns
    • Putting Text Inside a Shape
    • Formatting a Text Box or 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 Spelling Mistakes
    • Finding Misspelled Words
    • Working with Spelling Suggestions
  • Finding and Replacing Text
• Working with Shapes, Graphics, andOther Objects
  • Selecting Objects
  • Copying or Duplicating Objects
  • Deleting Objects
  • Moving Objects
    • Moving an Object Forward or Backward
    • Aligning Objects
      • Aligning Objects Relative to Each Other
      • Spacing Objects Evenly on a Page
      • Using Alignment Guides
      • Creating New Alignment Guides
      • Setting Precise Positions of Objects
  • Modifying Objects
    • Resizing Objects
    • Flipping and Rotating Objects
    • Changing the Style of Borders
    • Framing Objects
    • Adding Shadows
    • Adding a Reflection
    • Adjusting Opacity
  • Grouping and Locking Objects
    • Grouping and Ungrouping Objects
    • Locking and Unlocking Objects
  • Filling Objects
    • Filling an Object with Color
    • Using the Colors Window
    • Filling an Object with an Image
  • Using Shapes
    • Adding a Predrawn Shape
    • Adding a Custom Shape
    • Making Shapes Editable
    • Manipulating Points of a Shape
    • Reshaping a Curve
    • Reshaping a Straight Segment
    • Transforming Corner Points into Curved Points and Vice Versa
    • Editing Specific Predrawn Shapes
      • Editing a Rounded Rectangle
      • Editing Single and Double Arrows
      • Editing a Star
      • Editing a Polygon
  • Using Media Placeholders
  • Working with Images
    • Importing an Image
    • Masking (Cropping) Images
      • Cropping an Image Using the Default (Rectangular) Mask
      • Masking an Image with a Shape
      • Unmasking an Image
    • Removing the Background or Unwanted Elements from an Image
    • Changing an Image’s Brightness, Contrast, and Other Settings
    • Using PDF Files as Graphics
  • Using Sound and Movies
    • Adding a Sound File
    • Adding a Movie File
    • Adjusting Media Playback Settings
• Adding Address Book Data toaTable
  • 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
• Sharing Your Numbers Spreadsheet
  • Printing a Sheet
    • Choosing Printer Layout Options
    • Adjusting the Printed Color with ColorSync
  • Exporting to Other Document Formats
  • Sending a Spreadsheet to iWeb
• Designing Your Own Numbers Spreadsheet Templates
  • Designing a Template
  • Step 1:Define Table Styles
  • Step 2:Define Reusable Tables
  • Step 3:Define Default Charts, Text Boxes, Shapes, and Images
    • Defining Default Attributes for Charts
    • Defining Default Attributes for Text Boxes and Shapes
    • Defining Default Attributes for Imported Images
  • Step 4:Create Initial Spreadsheet Content
    • Predefining Tables and Other Objects for a Custom Template
    • Creating Media Placeholders for a Custom Template
    • Predefining Sheets for a Custom Template
  • Step 5:Save a Custom Template
• Dictionary of Functions
  • About Functions
  • Date and Time Functions
  • Financial Functions
  • Logical Functions
  • Information Functions
  • Reference Functions
  • Numeric Functions
  • Trigonometric Functions
  • Statistical Functions
  • Text Functions
  • Function Descriptions
    • ABS
    • ACCRINT
    • ACCRINTM
    • ACOS
    • ACOSH
    • ADDRESS
    • AND
    • AREAS
    • ASIN
    • ASINH
    • ATAN
    • ATAN2
    • ATANH
    • AVEDEV
    • AVERAGE
    • AVERAGEA
    • CEILING
    • CHAR
    • CHOOSE
    • CLEAN
    • CODE
    • COLUMN
    • COLUMNS
    • COMBIN
    • CONCATENATE
    • CONFIDENCE
    • CORREL
    • COS
    • COSH
    • COUNT
    • COUNTA
    • COUNTBLANK
    • COUNTIF
    • COUPDAYBS
    • COUPDAYS
    • COUPDAYSNC
    • COUPNUM
    • COVAR
    • DATE
    • DATEDIF
    • DAY
    • DB
    • DDB
    • DEGREES
    • DISC
    • DOLLAR
    • EDATE
    • EVEN
    • EXACT
    • EXP
    • FACT
    • FALSE
    • FIND
    • FIXED
    • FLOOR
    • FORECAST
    • FV
    • GCD
    • HLOOKUP
    • HOUR
    • HYPERLINK
    • IF
    • INDEX
    • INDIRECT
    • INT
    • INTERCEPT
    • IPMT
    • IRR
    • ISBLANK
    • ISERROR
    • ISEVEN
    • ISODD
    • ISPMT
    • LARGE
    • LCM
    • LEFT
    • LEN
    • LN
    • LOG
    • LOG10
    • LOOKUP
    • LOWER
    • MATCH
    • MAX
    • MAXA
    • MEDIAN
    • MID
    • MIN
    • MINA
    • MINUTE
    • MIRR
    • MOD
    • MODE
    • MONTH
    • MROUND
    • NOT
    • NOW
    • NPER
    • NPV
    • ODD
    • OFFSET
    • OR
    • PERCENTILE
    • PI
    • PMT
    • POISSON
    • POWER
    • PPMT
    • PRICE
    • PRICEDISC
    • PRICEMAT
    • PROB
    • PRODUCT
    • PROPER
    • PV
    • QUOTIENT
    • RADIANS
    • RAND
    • RANDBETWEEN
    • RANK
    • RATE
    • REPLACE
    • REPT
    • RIGHT
    • ROMAN
    • ROUND
    • ROUNDDOWN
    • ROUNDUP
    • ROW
    • ROWS
    • SEARCH
    • SECOND
    • SIGN
    • SIN
    • SINH
    • SLN
    • SLOPE
    • SMALL
    • SQRT
    • STDEV
    • STDEVA
    • STDEVP
    • STDEVPA
    • SUBSTITUTE
    • SUM
    • SUMIF
    • SUMPRODUCT
    • SUMSQ
    • SYD
    • T
    • TAN
    • TANH
    • TIME
    • TIMEVALUE
    • TODAY
    • TRIM
    • TRUE
    • TRUNC
    • UPPER
    • VALUE
    • VAR
    • VARA
    • VARP
    • VARPA
    • VDB
    • VLOOKUP
    • WEEKDAY
    • YEAR
• Index
  • A
  • B
  • C
  • D
  • E
  • F
  • G
  • H
  • I
  • K
  • L
  • M
  • N
  • O
  • P
  • Q
  • R
  • S
  • T
  • U
  • V
  • W
  • Y
  • Z