Apple Numbers '09 User Manual

Numbers ’09User Guide

10 Contents231 Chapter 10: Adding Address Book Data to a Table231 Using Address Book Fields231 Mapping Column Names to Address Book Field Name

11Numbers oers a powerful and intuitive way to do everything from setting up your family budget to completing a lab report to creating detailed 

12 Preface Welcome to Numbers ’09Onscreen helpOnscreen help contains detailed instructions for completing all Numbers tasks. To open help, op

13This chapter introduces you to the windows and tools you use to work on Numbers spreadsheets.When you create a Numbers spreadsheet, you rst sel

Here are ways to use the Template Chooser window:To view thumbnails of all the templates, click All in the list of template categories on mthe left s

Chapter 1 Numbers Tools and Techniques 15Toolbar: Located at the top of the window, the toolbar gives you one-click access to commonly used too

Zooming In or OutYou can enlarge (zoom in) or reduce (zoom out) your view of a sheet. Here are ways to zoom in or out on a sheet:Choose View > Zoom

Chapter 1 Numbers Tools and Techniques 17Print ViewWhen you want to print a sheet or make a PDF of it, you can use Print View to visualize the l

To exit full-screen view, do any of the following::Press Escape on your keyboard. mMove the pointer to the top of the screen to show the menu bar, and

Chapter 1 Numbers Tools and Techniques 19 3 Click Done.You can also customize the toolbar by using these shortcuts:To remove an item from the t

Apple Inc. KCopyright © 2011 Apple Inc. All rights reserved.Under the copyright laws, this manual may not be copied, in whole or in part, without the

The Inspector WindowMost elements of your spreadsheet can be formatted using the Numbers inspectors. Each inspector focuses on a dierent aspect of fo

Chapter 1 Numbers Tools and Techniques 21Learn more about this editor in “Adding and Editing Formulas Using the Formula Editor” on page 12 2 .Th

“Adding Functions to Formulas” on page 124 explains how to use the Function Browser. To learn about all the iWork functions, and to review numerous e

Chapter 1 Numbers Tools and Techniques 23The Media BrowserThe Media Browser provides access to all the media les in your iPhoto library, your i

To learn how to Go toImport an image “Working with Images” on page 194Add a sound le “Adding a Sound File” on page 209Add a movie le “Adding a Movi

Chapter 1 Numbers Tools and Techniques 25 2 To make the color lighter or darker, drag the slider on the right side of the Colors window. 3 To

Select a typeface (for example, Italic or Bold) from the Typeface list. mIn the Size column, type or select the font size you want. mHere are ways to

Chapter 1 Numbers Tools and Techniques 27You can copy one or more warnings by selecting them in the Document Warnings window and choosing Edit &

28This chapter describes how to manage Numbers spreadsheets.You can create a Numbers spreadsheet by opening Numbers and choosing a template. You can

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 29 2 In the Template Chooser window, select a template category in the left co

11 Preface: Welcome to Numbers ’0913 Chapter 1: Numbers Tools and Techniques13 Spreadsheet Templates14 The Numbers Window16 Zooming In or O

Here are ways to import a document:Drag the document to the Numbers application icon. A new Numbers spreadsheet mopens, and the contents of the impor

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 31Here are ways to open an existing spreadsheet:To open a spreadsheet from the

If you want help to create an unusual or strong password, click the button with the key-shaped icon next to the Password eld to open the Password As

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 33 4 If you want the spreadsheet to display a Quick Look in the Finder in Mac

To learn how to Go toShare your spreadsheets with others “Printing a Spreadsheet” on page 236“Sending Your Numbers Spreadsheet to iWork.com public be

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 35To lock a spreadsheet: 1 Open the spreadsheet you want to lock, and hold you

Saving a Copy of a SpreadsheetIf you want to duplicate your open spreadsheet, you can save it using a dierent name or location.To save a copy of a sp

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 37The view changes to show snapshots of all saved versions of the spreadsheet r

To restore only an object or inspector setting from the older version, copy the Âobject or setting by selecting it and pressing Command-C, and then c

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 39Closing a Spreadsheet Without Quitting NumbersWhen you have nished working w

4 Contents38 Saving Spotlight Search Terms for a Spreadsheet39 Closing a Spreadsheet Without Quitting Numbers39 Using Sheets to Organize a Spr

To display the contents of a sheet, click the sheet in the Sheets pane. mWhen you’re working on a table or chart in a spreadsheet, the table or char

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 41You can also select multiple sheets and move them as a group.To copy (or cut)

Dividing a Sheet into PagesUsing Print View, you can view a sheet as individual pages, moving and resizing objects until you achieve the layout you wa

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 43You set up page attributes, such as page orientation and margins, separately

Adding Headers and Footers to a SheetYou can have the same text appear on multiple pages in a sheet. Recurring information that appears at the top of

Chapter 2 Creating, Saving, and Organizing a Numbers Spreadsheet 45Move objects from page to page by dragging them or by cutting and pasting the

Setting Page MarginsIn Print View, every sheet’s page has margins (blank space between the sheet’s edge and the edges of the paper). These margins are

47This chapter explains how to add and format tables and their rows and columns.Several other chapters provide instructions that focus on particul

Adding a TableWhile most templates contain one or more predened tables, you can add tables to your Numbers spreadsheet. Here are ways to add a table:

Chapter 3 Using Tables 49Use the Table inspector to access table-specic controls, such as elds for precisely mcontrolling column width and ro

Contents 569 Filtering Rows in a Table69 Creating Table Categories70 Dening Table Categories and Subcategories75 Removing Table Categories and

Use the Graphic inspector to create special visual eects, such as shadows. To mopen the Graphic inspector, click Inspector in the toolbar and then

Chapter 3 Using Tables 51You can also use the pop-up menus on the column and row reference tabs. Use the Formula Editor and formula bar to add a

To resize from the table’s center, hold down the Option key as you drag.To resize a table in one direction, drag a side handle instead of a corner han

Chapter 3 Using Tables 53To increase the distance between the table name and the table body, select Name in mthe Table inspector, click the nam

3 Dene the table’s structure.To resize the table, see “Resizing a Table” on page 51 and “Resizing Table Rows and Columns” on page 65.To dene colu

Chapter 3 Using Tables 55 2 Choose Edit > Copy. 3 In the other application, set an insertion point for the copied table, and then choose Ed

2 Click the cell. When a cell is selected, use the Tab, Return, and arrow keys to move the selection to an adjacent cell. Deselecting “Return key mo

Chapter 3 Using Tables 57Selecting a Row or Column in a TableSelect rows and columns using their reference tabs.To select an entire row or colum

Click the Borders button in the format bar, and choose an option from the pop-up menu.Borders buttonYou can also use the Cell Borders buttons in the

Chapter 3 Using Tables 59Working with Rows and Columns in TablesYou can quickly add or remove rows and columns, create header rows or columns or

6 Contents11 3 Reordering, Renaming, and Deleting Custom Cell Formats11 4 Chapter 5: Working with Table Styles11 4 Using Table Styles11 5

If the table contains a footer row, rows added at the bottom of the table are added above the footer row. If the table has ltering criteria associate

Chapter 3 Using Tables 61To add a single column, hold the pointer over a column’s reference tab to see its menu marrow. Click the arrow and the

Here are ways to delete rows or columns:Select one or more rows or columns or a cell in a row or column, and then choose mTable > Delete Row or Ta

Chapter 3 Using Tables 63Header rows and header columns can be set to appear at the beginning of the table and on each page if the table spans m

Freezing Table Header Rows and Header ColumnsWhen you’re not in Print View (which repeats header rows and columns on each page), you can keep headers

Chapter 3 Using Tables 65Click the disclosure triangle next to the Footer button in the toolbar, and then choose mthe number of footer rows to

To shrink a row or column to remove unused space when cell values don’t ll their mcells, select a cell and click one of the Fit buttons in the Table

Chapter 3 Using Tables 67To hide multiple rows or columns, select the rows or a cell in each of them and then choose Hide Selected Rows or Hide

Here are ways to sort:To sort an entire table by reordering cells in a column, choose Sort Ascending or Sort mDescending from the pop-up menu for the

Chapter 3 Using Tables 69Filtering Rows in a TableYou can hide rows in a table that don’t contain the values you specify. When you sort table c

Contents 7143 Sharing Charts with Pages and Keynote Documents143 Formatting Charts144 Placing and Formatting a Chart’s Title and Legend144 Resiz

Category rows have special characteristics that help you manage your categories. You can add new categories, remove categories, and perform other oper

Chapter 3 Using Tables 71Creating categories manuallyWhen you create categories by manually inserting a category row, a new column (the categor

If you change a value in the category value column, the row moves into a dierent category if the value exists elsewhere in the category value column;

Chapter 3 Using Tables 73Table categories are created based on unique values in the chosen column.Category row Category value columnIf the categ

To create a subcategory, open the Reorganize window, and click the Add (+) button madjacent to the category or subcategory below which you want the n

Chapter 3 Using Tables 75If you delete all rows from a category, the category is removed from the table.Removing Table Categories and Subcategor

To display values automatically computed using cell values in a column of a category mor subcategory, click a category row cell and then click the di

Chapter 3 Using Tables 77Body rows in the selected range are hidden, but category rows reman visible.To expand or collapse all category or subca

78This chapter describes how to work with table cells and their content.Putting Content into Table CellsUse a variety of techniques to add content t

Chapter 4 Working with Table Cells 79To insert content within existing content, select the cell, click to set the insertion point, mand begin t

8 Contents175 Aligning Text Vertically175 Setting the Spacing Between Lines of Text176 Setting the Spacing Before or After a Paragraph177

To control font attributes, use the text formatting buttons in the format bar. mChoose a font.Choose a typeface.Choose the font size.Choose the text c

Chapter 4 Working with Table Cells 81Instructions for using formulas and functions in table cells are in “Creating Your Own Formulas” on page 12

Displaying Content Too Large for Its Table CellWhen a cell is too small to display all its content, here is what happens: If the content is a number

Chapter 4 Working with Table Cells 83To apply conditional formatting, you select one or more cells and then dene one or more rules. The rules s

4 To specify a specic test value, type it into the value eld, to the right of the pop-up menu. You can also use the value in a table cell as a te

Chapter 4 Working with Table Cells 85As you click, the Sample box displays the eect of your selections. When you’re satised with the eect, cl

To delete a test value that’s a cell reference, click in the test value eld and press Delete.To replace a cell reference with a dierent one, click i

Chapter 4 Working with Table Cells 87When you merge column cells, the cell background takes on the image or color that Âwas in the topmost cell

Line thickness: Controls the thickness of the stroke.Color well: Lets you choose a stroke color.When you click the color well in the format bar, a c

Chapter 4 Working with Table Cells 89See “Rearranging Rows and Columns” on page 61 to learn how to copy and move rows and columns using the refe

Contents 9203 Editing Shapes204 Adding, Deleting, and Moving the Editing Points on a Shape204 Reshaping a Curve205 Reshaping a Straight Segment2

If you delete a value from a cell with a format, the cell’s format isn’t deleted. To mdelete the format, apply the automatic format. To delete the v

Chapter 4 Working with Table Cells 91Using the Automatic Format in Table CellsWhen you add a new cell, its content is displayed using the automa

This content in a cell assigned the automatic formatIs formatted like this for displayA duration value A number accompanied by a duration sux (w or w

Chapter 4 Working with Table Cells 93To dene a number format that displays two decimal places, a thousands separator, and negative numbers with