《Excel5 for Windows简明手册》

索引1

环境1

目录1

简介3

Excel A至Z13

A14

Absolute Cell Address14

Active Cell14

Active and Inactive Windows15

Active Sheet15

Adding Styles16

Aligning Labels and Values16

Application Windows18

Applying Styles18

ANSI Character18

Argument19

Array20

Array Formulas20

ASCII Character21

ASCII Text Files22

Auditing Worksheets22

AutoFormatting Tables23

AutoSave24

AutoSum25

B26

Bold Characters26

Boolean Algebra26

Borders27

Cell Address28

Calculating Formulas28

C28

Cell Pointer29

Cell Protection29

Cell Reference31

Cell Selector31

Changing Fonts31

Chart32

Chart Colors32

Chart Gridlines33

Chart Legends34

Chart Page Setup34

Chart Sheets35

Chart Text36

Chart Titles36

Chart Types37

ChartWizard39

Clip Art42

Closing Workbooks43

Color43

Coloring Worksheet Ranges44

Coloring Worksheet Text44

Columns44

Conditional Functions45

Converting Formulas into Numbers45

Copying46

Copying Cell Formats46

Copying Data47

Copying Formulas47

Copying Ranges49

Copying Objects and Pictures49

Creating Lists50

Currency Symbols51

Custom Filtering52

D52

Data Categories52

Data Markers52

Data Series53

Data Format53

Date and Time Functions54

Date Values54

Default Directory55

Default Fonts55

Deleting56

Deleting Cells56

Default Workbooks56

Deleting Columns and Rows57

Deleting Sheets57

Delimited Text Files57

Dependents57

Dialog Box58

Document Windows58

Drag-and-Drop58

Drawing59

E59

Editing Cell Contents59

Editing Embedded Charts60

Editing Lists60

Embedding and Linking Existing Objects61

Entering Data62

Embedding New Objects62

Erasing Cells63

Erasing Workbooks64

Error Message64

Exiting Excel65

Exporting65

F65

File Names65

File Summary66

Filling Cells66

Fill Series67

Filtering Lists68

Financial Functions71

Finding Cells71

Fonts72

Finding Files72

Footers73

Formatting73

Formatting Numbers74

Formula Bar75

Formulas75

Fractions76

Full Screen77

Functions77

Function Wizard78

G79

Goal Seek79

Go To80

Groups81

Gridlines81

Headers and Footers82

Help82

H82

Hiding and Unhiding Sheets83

I83

Importing Spreadsheet Files83

Importing Text Files83

Inserting86

Inserting Cells86

Inserting Columns87

Inserting Rows88

Inserting Worksheets88

List Management89

Lookup Function89

L89

Labels89

Italic Characters89

Lotus 1-2-390

Lotus Improv90

M90

Macro90

Margins91

Math Functions91

Microsoft Word91

Moving and Copying Sheets92

Moving Data92

Moving Objects and Pictures93

Naming Sheets94

Names94

N94

New Workbooks95

Notes95

O96

Object Linking and Embedding96

Opening Workbooks97

P98

Page Breaks98

Page Numbers98

Page Setup98

Passwords99

Patterns99

Pagination99

Page Tab99

Percentages100

Picture Charts100

PivotTables101

Points104

Precedents104

Printed Pages Setup104

Printing105

Print Preview106

Q107

Quattro Pro107

R107

Range Address107

Relative Cell Address107

Replacing Cell Contents108

Repeat108

Removing Styles108

Reports109

Resizing Pictures110

Rows111

S111

Save Options111

Saving Workbooks112

Scenarios113

Scientific Notation113

Scrolling114

Searching Lists115

Selecting Cell116

Selecting Columns116

Selecting Rows116

Sheet Page Setup117

Sharing Microsoft Excel Data117

Sheets118

Shortcut Menus118

Solver118

Sorting Lists119

Spelling119

Starting Excel121

Statistics Functions122

Styles122

Subtotaling Lists122

Switching Tasks124

T125

Text Boxes125

Text String Formulas126

Text Functions126

Time Formats127

Time Values128

TipWizard128

Toolbars129

TrueType130

U130

Underline Characters130

Undo130

V130

Values130

W131

What-if Tables131

Visual Basic131

Views131

Window Command Buttons133

Window Control-menu Commands134

Window Panes136

Workbook Functions137

Workbooks137

Worksheet Pictures137

Worksheets138

Worksheet Titles139

Worksheet View139

Workspace139

Z140

Zooming140

释疑141

速查参考157