
Contents
5
62
Using the Date and Time Format
63
Using the Fraction Format
63
Using the Scientific Format
64
Using the Text Format
65
Using a Checkbox and Other Control Formats
67
Monitoring Cell Values
68
Adding Images or Color to Cells
68
Autofilling Table Cells
69
Working with Rows and Columns
69
Adding Rows
70
Adding Columns
70
Rearranging Rows and Columns
70
Deleting Table Rows and Columns
71
Using a Table Header Row or Column
72
Using a Footer Row
72
Hiding Rows and Columns
73
Resizing Table Rows and Columns
73
Alternating Row Colors
74
Working with Table Cells
74
Merging Table Cells
74
Splitting Table Cells
75
Formatting Table Cell Borders
76
Copying and Moving Cells
76
Adding Comments
77
Reorganizing Tables
77
Sorting Table Cells
78
Filtering Rows
Chapter 4 79 Working with Table Styles
79
Using Table Styles
80
Applying Table Styles
80
Modifying a Table’s Style
80
Modifying Table Style Attributes
81
Copying and Pasting Table Styles
81
Using the Default Table Style
82
Creating New Table Styles
82
Renaming a Table Style
82
Deleting a Table Style
Chapter 5 83 Using Formulas and Functions in Tables
83
Using Formulas
84
A Tour of Using Formulas
Comentários a estes Manuais