Contents

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 Cant 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 Spreadsheets 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 Charts Title and Legend
  - Resizing or Rotating a Chart
  - Formatting Chart Axes
  - Formatting the Elements in a Charts 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 Images 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

Apple iWork Numbers 09 User Guide

Pages 254

Year 2005

Language(s)

of 254

Apple iWork Numbers 09 Specification

Apple iWork Numbers '09 is a versatile spreadsheet application designed to offer an intuitive and flexible platform for data organization and analysis. Released as part of the iWork '09 suite, Numbers utilizes a highly visual user interface that includes a canvas-based approach, allowing users to create multiple tables on a single sheet and seamlessly integrate text, images, and charts. It supports a variety of data formats and offers over 250 functions for complex calculations. The software provides robust tools for creating interactive charts and graphs to visualize data trends effectively. Its compatibility with Microsoft Excel ensures smooth import and export of files, facilitating collaboration across different platforms.

Numbers '09 comes with a range of customizable templates tailored for various purposes, such as personal finance, business, and educational projects, streamlining the creation process. Advanced printing options enable users to set up print areas and manage pagination efficiently. The software supports conditional formatting, allowing users to highlight specific data sets based on predefined rules, enhancing data analysis and presentation.

Numbers '09 includes collaboration features via iWork.com, enabling users to share documents online and collect feedback in real-time. Its integration with other iWork applications, such as Pages and Keynote, allows seamless transitions of data and content across different formats. Enhanced by Apple's design philosophy, Numbers '09 emphasizes simplicity and elegance, making it accessible to both novice and experienced users. It runs on Mac OS X 10.4.11 or later, requiring an Intel, PowerPC G5, or PowerPC G4 processor with at least 500 MHz speed, and recommends 1 GB of RAM for optimal performance.

Apple iWork Numbers 09 F.A.Q.

How do I create a table in Apple iWork Numbers 09?

To create a table in Numbers 09, open a new or existing spreadsheet, click on 'Table' in the toolbar, and select 'New Table'. Customize your table using the inspector to adjust rows, columns, and formatting.

How can I import a CSV file into Numbers 09?

To import a CSV file, open Numbers 09 and select 'File' > 'Open'. Locate your CSV file, select it, and Numbers will automatically format it into a table.

What should I do if Numbers 09 crashes frequently?

If Numbers 09 crashes often, ensure your software is up to date. Try restarting your Mac, checking for available updates, and reinstalling the application if necessary. Additionally, clear cache files and check for corrupted documents.

How can I use formulas in Numbers 09?

To use formulas, click on a cell and type '=' followed by the formula you need. Use the formula bar to enter and edit your expressions. Functions can be accessed from the 'Function Browser' in the toolbar.

How do I create charts in Numbers 09?

Select the data range you want to visualize, then click on 'Charts' in the toolbar. Choose a chart style and customize it using the options in the inspector.

Can I collaborate with others using Numbers 09?

Collaboration features in Numbers 09 are limited compared to newer versions. You can share files via email or cloud services like iCloud, but real-time collaboration is not supported.

How do I print a spreadsheet in Numbers 09?

To print, go to 'File' > 'Print'. Use the 'Page Setup' dialog to adjust settings like paper size and orientation. You can preview the document before printing to ensure it looks correct.

What steps should I take if my spreadsheet is not opening in Numbers 09?

Check if the file type is supported and ensure it is not corrupted. Try opening the file on another device or a newer version of Numbers. If issues persist, consider using a different app to access the file.

How can I convert a Numbers 09 file to Excel format?

Go to 'File' > 'Export' > 'Excel'. Follow the prompts to save your spreadsheet in .xls or .xlsx format. This allows opening the file in Microsoft Excel.

Is it possible to password-protect a document in Numbers 09?

Numbers 09 does not natively support password protection for documents. Consider using disk encryption or a third-party tool for securing your files.