Numbers08_UserGuide.pdf

(3478 KB) Pobierz
Numbers '08 User's Guide
Numbers ’08
User’s Guide
1767781.001.png
Apple Inc.
© 2007 Apple Inc. All rights reserved.
Apple, the Apple logo, AppleWorks, ColorSync, iMovie,
iPhoto, iTunes, Keynote, Mac, Mac OS, Pages, Quartz, and
QuickTime are trademarks of Apple Inc., registered in
the U.S. and other countries.
Under the copyright laws, this manual may not be
copied, in whole or in part, without the written consent
of Apple. Your rights to the software are governed by
the accompanying software license agreement.
Finder, iWeb, iWork, Safari, and Spotlight are trademarks
of Apple Inc.
The Apple logo is a trademark of Apple Inc., registered
in the U.S. and other countries. Use of the “keyboard”
Apple logo (Option-Shift-K) for commercial purposes
without the prior written consent of Apple may
constitute trademark infringement and unfair
competition in violation of federal and state laws.
AppleCare and .Mac are service marks of Apple Inc.,
registered in the U.S. and other countries.
Adobe and Acrobat are trademarks or registered
trademarks of Adobe Systems Incorporated in the U.S.
and/or other countries.
Other company and product names mentioned herein
are trademarks of their respective companies. Mention
of third-party products is for informational purposes
only and constitutes neither an endorsement nor a
recommendation. Apple assumes no responsibility with
regard to the performance or use of these products.
019-0791 06/2007
Every effort has been made to ensure that the
information in this manual is accurate. Apple is not
responsible for printing or clerical errors.
Apple
1 Infinite Loop
Cupertino, CA 95014-2084
408-996-1010
www.apple.com
K
1
Contents
Preface
16 Welcome to the
Numbers User’s Guide
Chapter 1
18 Numbers Tools and Techniques
18
Spreadsheet Templates
20
The Numbers Window
21
Spreadsheet Viewing Aids
21
Zooming In or Out
21
The Sheets Pane
22
Print View
22
Alignment Guides
23
The Styles Pane
23
The Toolbar
24
The Format Bar
25
The Inspector Window
26
Formula Tools
27
The Media Browser
27
The Colors Window
27
The Font Panel
28
The Warnings Window
28
Keyboard Shortcuts and Shortcut Menus
Chapter 2
29 Working with a Numbers Spreadsheet
29
Creating, Opening, and Importing Spreadsheets
29
Creating a New Spreadsheet
31
Importing a Document
31
Opening an Existing Spreadsheet
32
Saving Spreadsheets
32
Saving a Spreadsheet
33
Undoing Changes
33
Automatically Saving a Backup Version of a Spreadsheet
33
Saving a Spreadsheet as a Template
34
Saving Search Terms for a Spreadsheet
3
1767781.002.png
 
34
Saving a Copy of a Spreadsheet
34
Closing a Spreadsheet Without Quitting Numbers
35
Using Sheets to Organize a Spreadsheet
35
Viewing Sheets
36
Adding and Deleting Sheets
36
Reorganizing Sheets and Their Contents
37
Changing Sheet Names
37
Dividing a Sheet into Pages
38
Setting a Spreadsheet’s Page Size
39
Using Headers and Footers
39
Arranging Objects on a Page
40
Setting Page Orientation
40
Setting Pagination Order
40
Numbering Pages
41
Setting Page Margins
Chapter 3
42 Using Tables
42
About Tables
43
Working with Tables
43
Adding a Table
43
Using Table Tools
46
Resizing a Table
46
Moving Tables
47
Naming Tables
47
Defining Reusable Tables
48
Copying Tables Among iWork Applications
49
Selecting Tables and Their Components
49
Selecting a Table
49
Selecting a Table Cell
50
Selecting a Group of Table Cells
50
Selecting a Row or Column
51
Selecting Table Cell Borders
52
Working with Content in Table Cells
52
Adding and Editing Cell Values
53
Working with Text in Cells
54
Working with Numbers in Cells
55
Working with Dates in Cells
55
Displaying Content Too Large for Its Cell
56
Formatting Cell Values
57
Using the Number Format
58
Using the Currency Format
59
Using the Percentage Format
4
Contents
60
Using the Date and Time Format
61
Using the Fraction Format
61
Using the Scientific Format
62
Using the Text Format
63
Using a Checkbox and Other Control Formats
65
Monitoring Cell Values
66
Adding Images or Color to Cells
66
Autofilling Table Cells
67
Working with Rows and Columns
67
Adding Rows
67
Adding Columns
68
Rearranging Rows and Columns
68
Deleting Table Rows and Columns
69
Using a Table Header Row or Column
70
Using a Footer Row
70
Hiding Rows and Columns
71
Resizing Table Rows and Columns
71
Alternating Row Colors
72
Working with Table Cells
72
Merging Table Cells
72
Splitting Table Cells
73
Formatting Table Cell Borders
73
Copying and Moving Cells
74
Adding Comments
75
Reorganizing Tables
75
Sorting Table Cells
76
Filtering Rows
Chapter 4
77 Working with Table Styles
77
Using Table Styles
78
Applying Table Styles
78
Modifying a Table’s Style
78
Modifying Table Style Attributes
79
Copying and Pasting Table Styles
79
Using the Default Table Style
80
Creating New Table Styles
80
Renaming a Table Style
80
Deleting a Table Style
Chapter 5
81 Using Formulas and Functions in Tables
81
Using Formulas
82
A Tour of Using Formulas
Contents
5
Zgłoś jeśli naruszono regulamin