Apple Pages User's Guide Page 197
- Page / 246
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
Chapter 9 Using Formulas and Functions in Tables 197
m To paste a copy of a formula in a different cell and use the same cell references in both
formulas, place a dollar sign ($) in front of column and row identifiers (=$A$1). This
technique creates what’s called an absolute cell reference.
For example, if the formula =A1 appears in cell D1 and you want to paste a copy of the
formula in cell E1, change the formula to =$A$1, select D1, copy it, and paste the copy
into E1. The formula $A$1 is copied into cell E1. If you didn’t change the formula to use
an absolute cell reference the formula in E1 would be =B1.
Applying a Formula Once to Cells in a Column or Row
When a table has header cells, you can use them to quickly apply a formula to all the
cells in a row or column. The values in the cells are recomputed using the formula. This
formula is called a header formula.
To apply a header formula to cells in a column or row:
1 Select the header cell for the column or row.
2 Open the Formula Editor. For example, type the equal sign (=).
3 Type the formula you want to apply to each cell in the column or row.
For example, to assign values to the cells of column C that are five times greater than
the corresponding cell in column B, you’d use the formula B*5 or B:B*5.
The formula is duplicated in all the cells in the column or row. In this example, cell C4
would contain the value computed by using the formula B4*5.
4 Click the Accept button or press Return or Enter to save the formula.
Handling Errors and Warnings
When a formula in a table cell is incomplete, contains invalid cell references, or is
otherwise incorrect, or when an import operation creates an error condition in a cell,
Pages displays an icon in the cell. A blue square in the upper left of a cell indicates one
or more warnings. A red triangle in the middle of a cell means that a formula error
occurred.
To view error and warning messages:
m Click the icon.
A message window summarizes each error and warning condition associated with the
cell. To ignore warnings, click Ignore or click the x icon associated with a warning
message.
Using Operators
Use operators in formulas to perform arithmetic operations and compare values:
 Arithmetic operators perform arithmetic operations, such as addition and subtraction,
and return numerical results.
 Comparison operators compare two values and return TRUE or FALSE.
- Pages ’08 1
- User’s Guide 1
- Contents 3
- Contents 7 7
- 8 Contents 8
- Contents 9 9
- 10 Contents 10
- Contents 11 11
- 12 Contents 12
- Contents 13 13
- Pages Tools and Techniques 16
- Document Viewing Aids 18
- Document Page Views 19
- Layout View 19
- The Toolbar 22
- The Format Bar 23
- The Inspector Window 23
- The Media Browser 24
- The Font Panel 25
- The Colors Window 25
- Rulers and Alignment Guides 25
- The Styles Drawer 26
- The Warnings Window 28
- Research and Reference Tools 28
- Word Processing Templates 30
- Page Layout Templates 31
- Creating a New Document 31
- Importing a Document 33
- Saving Your Document 34
- Undoing Changes 35
- Saving a Copy of a Document 35
- Designing Documents 37
- Appearance of Text 38
- Graphics and Other Objects 38
- Working with Document Parts 39
- Setting Document Margins 42
- Using Page and Line Breaks 42
- Using Layouts 44
- Defining Column Breaks 45
- Defining Layout Breaks 46
- Defining Layout Margins 47
- Viewing Facing Pages 48
- Using Headers and Footers 49
- Using Footnotes and Endnotes 49
- Using Sections 53
- Defining Section Attributes 55
- Reusing Sections 56
- Master objects have 57
- Using a Table of Contents 58
- Styling a Table of Contents 59
- Reviewing and Revising 61
- Documents 61
- Using Change Tracking 62
- A Tour of Change Tracking 63
- Click to accept changes 65
- Click to reject changes 65
- Select to stop 65
- Choose how edited text is 66
- Accepting and Rejecting Edits 67
- Using Comments 68
- Click to delete 69
- Working with Text 70
- Placeholder text 71
- The entire text area is 71
- Adding New Template Pages 72
- Deleting Pages 73
- Selecting Text 74
- Smart quotes 83
- Straight quotes 83
- Ligature not used 83
- Ligature used 83
- Adjusting Font Smoothing 84
- Aligning Text Horizontally 85
- Aligning Text Vertically 86
- Changing Text Color 89
- Setting Indents 94
- Setting Indents for Lists 95
- Using Bulleted Lists 96
- Using Numbered Lists 98
- Adding Text Boxes 100
- Linking Floating Text Boxes 102
- Adding Borders and Rules 104
- Presenting Text in Columns 105
- Putting Text Inside a Shape 106
- Linking to a Webpage 107
- Editing Hyperlink Text 110
- Text wraps around 112
- Using Automatic Hyphenation 113
- Inserting a Nonbreaking Space 114
- Proofreading Documents 115
- Finding and Replacing Text 116
- Type the word or phrase 117
- Select an item in the 117
- Working with Styles 118
- About Styles 119
- Applying Styles 120
- Click to show list styles 121
- Click to show 121
- Changing the Style of Text 122
- Modifying Paragraph Styles 123
- Creating New Paragraph Styles 126
- Modifying Character Styles 127
- Creating New Character Styles 128
- Renaming a Style 133
- Deleting a Style 133
- Drag any of the selection 134
- Selecting Objects 135
- Deleting Objects 136
- Moving Objects 137
- Aligning Objects 138
- Modifying Objects 141
- Flipping and Rotating Objects 142
- Changing the Style of Borders 142
- Framing Objects 143
- Adding Shadows 144
- Adding a Reflection 145
- Adjusting Opacity 146
- Grouping and Locking Objects 147
- Filling Objects 147
- Using the Colors Window 148
- Using Shapes 151
- Making Shapes Editable 152
- Click a point and drag it 153
- Reshaping a Curve 154
- Reshaping a Straight Segment 154
- Using Media Placeholders 157
- Working with Images 158
- Masking (Cropping) Images 159
- Using PDF Files as Graphics 163
- Using Sound and Movies 164
- Adding a Movie File 165
- Using Tables 167
- Working with Tables 168
- Chapter 8 Using Tables 169 169
- Resizing a Table 170
- Moving Tables 171
- Converting Text to a Table 172
- Selecting a Table 172
- Selecting a Table Cell 172
- Selecting a Row or Column 174
- Selecting Table Cell Borders 174
- Working with Text in Cells 175
- Working with Numbers in Cells 176
- Working with Dates in Cells 177
- Formatting Cell Values 178
- Chapter 8 Using Tables 179 179
- Monitoring Cell Values 181
- Autofilling Table Cells 182
- Working with Rows and Columns 183
- Using a Footer Row 185
- Alternating Row Colors 185
- Working with Table Cells 186
- Formatting Table Cell Borders 187
- Copying and Moving Cells 187
- Sorting Table Cells 188
- Using Formulas and Functions 189
- A Tour of Using Formulas 190
- Adding a Quick Formula 192
- Removing a Formula 194
- Using the Formula Editor 194
- Using Cell References 195
- Using Operators 197
- Using Functions 200
- Using Charts 201
- Adding a Chart 204
- Selecting a Chart Type 204
- Editing Chart Data 206
- Using a Legend 207
- Using a Chart Title 208
- Resizing a Chart 208
- Rotating Charts 209
- Choose a line style 210
- Choose a line width 210
- Choose a line color 210
- Pie Charts 214
- Set a pie wedge apart 215
- Bar and Column Charts 216
- Area Charts and Line Charts 217
- Scatter Charts 218
- 3D Charts 219
- Personalizing Documents 220
- Using Address Book Fields 221
- Inserting Sender Data 221
- Printing and Exporting Your 225
- Document to Other Formats 225
- Printing Comments 227
- The ColorSync Utility icon 229
- Designing Your Own 233
- Document Templates 233
- Step 1: Set Up the Document 234
- Defining Default Styles 235
- Creating Placeholder Text 238
- Creating Media Placeholders 238
- 241 241
- 242 Index 242
- Index 243 243
- 244 Index 244
- Index 245 245
- 246 Index 246
Related products and manuals for Software Apple Pages
Software Apple iDVD User Manual
(38 pages)
(38 pages)
Software Apple iDVD 5 User Manual
(48 pages)
(48 pages)
Software Apple iMovie HD User Manual
(10 pages)
(10 pages)
Software Apple Logic Pro 7.1 User Manual
(16 pages)
(16 pages)
Software Apple iMovie HD User Manual
(19 pages)
(19 pages)
Software Apple Xsan User Manual
(165 pages)
(165 pages)
Software Apple Final Cut Pro 5 User Manual
(14 pages)
(14 pages)
Software Apple Logic Pro 7.1 User Manual
(28 pages)
(28 pages)
Software Apple Final Cut Pro 5 User Manual
(24 pages)
(24 pages)
Software Apple Xsan 1.1 User Manual
(25 pages)
(25 pages)
Software Apple GarageBand 3 User Manual
(6 pages)
(6 pages)
© 2020, manymanuals.com. All rights reserved. | 0.051 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals