09
Table Of Contents
- 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
- Working with Tables
- Selecting Tables and Their Components
- 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
- Chapter 4: Working with Table Cells
- Putting Content into Table Cells
- Displaying Content Too Large for Its Table Cell
- Using Conditional Formatting to Monitor Table Cell Values
- 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
- Chapter 6: Using Formulas in Tables
- The Elements of Formulas
- Performing Instant Calculations
- Using Predefined Quick Formulas
- Creating Your Own Formulas
- Removing Formulas
- Referring to Cells in Formulas
- Using Operators in Formulas
- 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
- Formatting Specific Chart Types
- 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
- Setting Tab Stops to Align Text
- Setting Indents
- Creating Lists
- Using Text Boxes, Shapes, and Other Effects to Highlight Text
- Using Hyperlinks
- 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
- Creating Shapes
- Using Sound and Movies
- 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
- Filling Objects with Colors or Images
- Working with MathType
- Chapter 10: Adding Address Book Data to a Table
- Chapter 11: Sharing Your Numbers Spreadsheet
- Chapter 12: Designing Your Own Numbers Spreadsheet Templates
- Index
3 Choose a bullet style from the Bullets & Numbering pop-up menu.
To use a typed character as a bullet, choose Text Bullets and choose a character from
the list or type a new character in the eld.
To use one of the image bullets that comes with Numbers, choose Image Bullets, and
then choose an image from the scrolling list.
To use your own image as a bullet, choose Custom Image, and then choose an image
in the Open dialog that appears.
4 To change the size of an image bullet, specify a percentage of the original image size
in the Size eld. Or, select the “Scale with text” checkbox and specify a percentage of
the text size; this option maintains the image-to-text size ratio of the bullets even if
you later change the font size of text.
5 To adjust the space between bullets and the left margin, use the Bullet Indent eld. To
adjust the space between bullets and text, use the Text Indent eld.
6 To position bullets higher or lower relative to text in a text box or shape, use the
Align eld.
7 To add and indent bulleted items in your list, do any of the following:
To add a new topic at the current indent level, press Return. If you’re working in a Â
table cell and “Return key moves to next cell” is selected in the Table inspector, press
Option-Return instead.
To create an unbulleted paragraph within a topic, press Return while holding down Â
the Shift key. If you’re working in a table cell and “Return key moves to next cell” is
selected in the Table inspector, press Control-Return instead.
To enter a new topic at the next lower indent level, press Tab. To enter a new topic Â
at the next higher level, press Shift-Tab. You can also click and hold a bullet, and
then drag to the right, to the left, down and to the right, or down and to the left.
If you’re working in a table cell and “Return key moves to next cell” is selected in
the Table inspector, use the Indent Level controls in the Bullets pane of the Text
inspector to change the level of entries.
To return to regular text at the end of your list, press Return and choose No Bullets Â
from the Bullets & Numbering pop-up menu. You may also need to adjust the
indent level.
If you’re working in a table cell and “Return key moves to next cell” is selected in the
Table inspector, press Option-Return instead of Return.
Formatting Numbered Lists
Although you can use automatic list generation to create a simple numbered list,
using the Text inspector gives you many options for formatting numbered lists.
See “Generating Lists Automatically” on page 181 for information about creating a
list automatically.
182 Chapter 8 Working with Text