Chapter 4: working with table cells – Apple Numbers '09 User Manual

Page 5

Advertising
background image

Contents

5

69

Filtering Rows in a Table

69

Creating Table Categories

70

Defining Table Categories and Subcategories

75

Removing Table Categories and Subcategories

75

Managing Table Categories and Subcategories

78

Chapter 4: Working with Table Cells

78 Putting Content into Table Cells
78

Adding and Editing Table Cell Values

79

Working with Text in Table Cells

80

Working with Numbers in Table Cells

81

Autofilling Table Cells

82 Displaying Content Too Large for Its Table Cell
82 Using Conditional Formatting to Monitor Table Cell Values
83

Defining Conditional Formatting Rules

85

Changing and Managing Your Conditional Formatting

86 Adding Images or Color to Table Cells
86 Merging Table Cells
87 Splitting Table Cells
87 Formatting Table Cell Borders
88 Copying and Moving Cells
89 Adding Comments to Table Cells
89 Formatting Table Cell Values for Display
91

Using the Automatic Format in Table Cells

92

Using the Number Format in Table Cells

93

Using the Currency Format in Table Cells

94

Using the Percentage Format in Table Cells

95

Using the Date and Time Format in Table Cells

96

Using the Duration Format in Table Cells

96

Using the Fraction Format in Table Cells

97

Using the Numeral System Format in Table Cells

98

Using the Scientific Format in Table Cells

99

Using the Text Format in Table Cells

99

Using a Checkbox, Slider, Stepper, or Pop-Up Menu in Table Cells

101

Using Your Own Formats for Displaying Values in Table Cells

102

Creating a Custom Number Format

104

Defining the Integers Element of a Custom Number Format

105

Defining the Decimals Element of a Custom Number Format

106

Defining the Scale of a Custom Number Format

108

Associating Conditions with a Custom Number Format

110

Creating a Custom Date/Time Format

111

Creating a Custom Text Format

112

Changing a Custom Cell Format

Advertising