《Microsoft excel参考手册 版本2.0》

上册目录1

前言1

Absolute reference（绝对引用）5

Alignment（对齐）5

Array（数组）9

Auditing worksheet models（审查表格模型）21

Borders and shading（边框和阴影）26

Calculation（计算）29

Chart（图表）33

Chart Add Arrow命令46

Chart Add Legend命令46

Chart Add Overlay命令47

Chart area（图表区域）47

Chart arrow（图表箭头）48

Chart Attach Text命令49

Chart Axes命令50

Chart axis（图表坐标轴）51

Chart Calculate Now命令55

Chart Delete Arrow命令55

Chart Delete Legend命令55

Chart Delete Overlay命令56

Chart Full Menus命令56

Chart Gridline命令56

Chart Legend（图表图注）57

Chart plot area（图表绘图区域）59

Chart Protect Document命令60

Chart Select Chart命令61

Chart Select Plot Aera命令61

Chart Short Menus命令62

Chart text（图表正文）62

Chart Unprotect Document命令69

Circular reference（循环引用）70

Color（颜色）71

Column（列）72

Command,menu,and dialog box（命令、菜单和对话盒）75

Constant value（常数值）87

Control Close命令88

Control Maximize命令88

Control Minimize命令89

Control Move命令89

Control Restore命令89

Control Run命令90

Control Size命令91

Control Split命令91

Convergence（收敛）91

Copying data and formats（复制数据和格式）92

Data Delete命令103

Data Exit Find命令103

Data Extract命令103

Data Form命令105

Data Find命令105

Data Parse命令108

Data series（数据组）109

Data Series命令119

Data Set Criteria命令120

Data Set Database命令121

Data Sott命令121

Data table（数据表）123

DataTable命令（全菜单）130

Database（数据库）131

Date（日期）156

Default settings（缺省设置）161

Deleting a document（删除一个文件）169

Deleting and Clearing Data（数据的删除和清除）169

Directories（目录）172

Display options（显示选择项）176

Divergence（发散）184

Edit Clear命令186

Edit Copy命令187

Edit Copy Picture命令188

Edit Cut命令190

Edit Delete命令190

Fdit Fill Down命令191

Edit Fill Left命令191

Edit Fill Right命令192

Edit Fill up命令192

Edit Insert命令192

Edit Paste命令193

Edit Paste Link命令195

Edit Paste Special命令195

Edit Repeat命令199

Edit Undo命令199

Edit a Document（文件编辑）199

Error Value（错误值）209

Exchange Data Between Applications（应用程序间数据的交换）214

External reference（外部引用）219

Features and specifications（特征与规格）220

File Close命令228

File Close All命令229

File Delete命令229

File Exit命令230

File Links命令231

File New命令232

File Open命令233

File Page Setup命令235

File Print命令237

File Printer Setup命令239

File Record Macro命令240

File Save命令240

File Save As命令241

File Unhide Window命令244

File Save Workspace命令244

Finding cells and data quickly（快速查找单元和数据）245

Font（字体）250

Format Alignment命令254

Format Border命令255

Format Cell Protection命令256

Format Column Width命令257

Format Font命令257

Format Justify命令261

Format Legend命令262

Format Main Chart命令263

Format Move命令264

Format Number命令265

Format Overlay命令269

Format Pattern命令271

Format Text命令272

Formatting a document（格式化文件）273

Format Row Height命令274

Format Scale命令275

Format Size命令277

Formula（公式）293

Formula Apply Names命令296

Formula Bar（公式栏）299

Formula Create Names命令304

Formula Define Name命令305

Formula Find命令307

Formula Goto命令309

Formala Note命令309

Formula Paste Function命令311

Formula Paste Name命令312

Formula Reference命令313

Formula Replace命令314

Formula Select Special命令315

Function（函数）318