索引 1
环境 1
目录 1
简介 3
Excel A至Z 13
A 14
Absolute Cell Address 14
Active Cell 14
Active and Inactive Windows 15
Active Sheet 15
Adding Styles 16
Aligning Labels and Values 16
Application Windows 18
Applying Styles 18
ANSI Character 18
Argument 19
Array 20
Array Formulas 20
ASCII Character 21
ASCII Text Files 22
Auditing Worksheets 22
AutoFormatting Tables 23
AutoSave 24
AutoSum 25
B 26
Bold Characters 26
Boolean Algebra 26
Borders 27
Cell Address 28
Calculating Formulas 28
C 28
Cell Pointer 29
Cell Protection 29
Cell Reference 31
Cell Selector 31
Changing Fonts 31
Chart 32
Chart Colors 32
Chart Gridlines 33
Chart Legends 34
Chart Page Setup 34
Chart Sheets 35
Chart Text 36
Chart Titles 36
Chart Types 37
ChartWizard 39
Clip Art 42
Closing Workbooks 43
Color 43
Coloring Worksheet Ranges 44
Coloring Worksheet Text 44
Columns 44
Conditional Functions 45
Converting Formulas into Numbers 45
Copying 46
Copying Cell Formats 46
Copying Data 47
Copying Formulas 47
Copying Ranges 49
Copying Objects and Pictures 49
Creating Lists 50
Currency Symbols 51
Custom Filtering 52
D 52
Data Categories 52
Data Markers 52
Data Series 53
Data Format 53
Date and Time Functions 54
Date Values 54
Default Directory 55
Default Fonts 55
Deleting 56
Deleting Cells 56
Default Workbooks 56
Deleting Columns and Rows 57
Deleting Sheets 57
Delimited Text Files 57
Dependents 57
Dialog Box 58
Document Windows 58
Drag-and-Drop 58
Drawing 59
E 59
Editing Cell Contents 59
Editing Embedded Charts 60
Editing Lists 60
Embedding and Linking Existing Objects 61
Entering Data 62
Embedding New Objects 62
Erasing Cells 63
Erasing Workbooks 64
Error Message 64
Exiting Excel 65
Exporting 65
F 65
File Names 65
File Summary 66
Filling Cells 66
Fill Series 67
Filtering Lists 68
Financial Functions 71
Finding Cells 71
Fonts 72
Finding Files 72
Footers 73
Formatting 73
Formatting Numbers 74
Formula Bar 75
Formulas 75
Fractions 76
Full Screen 77
Functions 77
Function Wizard 78
G 79
Goal Seek 79
Go To 80
Groups 81
Gridlines 81
Headers and Footers 82
Help 82
H 82
Hiding and Unhiding Sheets 83
I 83
Importing Spreadsheet Files 83
Importing Text Files 83
Inserting 86
Inserting Cells 86
Inserting Columns 87
Inserting Rows 88
Inserting Worksheets 88
List Management 89
Lookup Function 89
L 89
Labels 89
Italic Characters 89
Lotus 1-2-3 90
Lotus Improv 90
M 90
Macro 90
Margins 91
Math Functions 91
Microsoft Word 91
Moving and Copying Sheets 92
Moving Data 92
Moving Objects and Pictures 93
Naming Sheets 94
Names 94
N 94
New Workbooks 95
Notes 95
O 96
Object Linking and Embedding 96
Opening Workbooks 97
P 98
Page Breaks 98
Page Numbers 98
Page Setup 98
Passwords 99
Patterns 99
Pagination 99
Page Tab 99
Percentages 100
Picture Charts 100
PivotTables 101
Points 104
Precedents 104
Printed Pages Setup 104
Printing 105
Print Preview 106
Q 107
Quattro Pro 107
R 107
Range Address 107
Relative Cell Address 107
Replacing Cell Contents 108
Repeat 108
Removing Styles 108
Reports 109
Resizing Pictures 110
Rows 111
S 111
Save Options 111
Saving Workbooks 112
Scenarios 113
Scientific Notation 113
Scrolling 114
Searching Lists 115
Selecting Cell 116
Selecting Columns 116
Selecting Rows 116
Sheet Page Setup 117
Sharing Microsoft Excel Data 117
Sheets 118
Shortcut Menus 118
Solver 118
Sorting Lists 119
Spelling 119
Starting Excel 121
Statistics Functions 122
Styles 122
Subtotaling Lists 122
Switching Tasks 124
T 125
Text Boxes 125
Text String Formulas 126
Text Functions 126
Time Formats 127
Time Values 128
TipWizard 128
Toolbars 129
TrueType 130
U 130
Underline Characters 130
Undo 130
V 130
Values 130
W 131
What-if Tables 131
Visual Basic 131
Views 131
Window Command Buttons 133
Window Control-menu Commands 134
Window Panes 136
Workbook Functions 137
Workbooks 137
Worksheet Pictures 137
Worksheets 138
Worksheet Titles 139
Worksheet View 139
Workspace 139
Z 140
Zooming 140
释疑 141
速查参考 157