第1章 Excel 2010快速入门操作技巧
1.1 界面管理与优化技巧 ······················· 1
001招 改变快速访问工具栏的位置 ···············1
002招 在快速访问工具栏中添加/删除按钮 ···1
003招 将功能区的按钮添加到快速
访问工具栏 ········································2
004招 如何隐藏/显示功能区 ·························2
005招 如何新建常用工具组 ··························3
006招 启用/禁用消息栏上的安全警报 ··········4
007招 显示/隐藏屏幕提示 ····························5
008招 如何加载“开发工具”选项卡 ···········5
009招 如何加载Excel的选项功能 ·················5
010招 禁止显示浮动工具栏 ··························6
011招 更改Excel网格线的颜色 ·····················6
012招 解决Excel无滚动条的问题 ·················7
013招 如何设置编辑栏的隐藏/显示 ··············7
1.2 新建、保存、打开与关闭工作簿技巧 ··· 7
014招 根据现有内容创建工作簿 ··················8
015招 如何从样本模板文件创建新的工作簿 ···8
016招 如何更改默认保存工作簿的位置 ········9
017招 如何让Excel低版本能打开
Excel 2010格式的表格 ······················9
018招 加密保存工作簿 ·······························10
019招 设置工作簿定时自动保存 ················10
020招 如何以“只读”方式打开工作簿 ······11
021招 启动Excel时自动打开特定的工作簿 ···11
022招 如何快速打开最近访问的工作簿 ······12
023招 如何清除打开文件记录 ····················12
1.3 视图查看与窗口缩放技巧 ···············13
024招 如何调整多出的行列打印在同一页 ···13
025招 自定义工作表视图 ···························13
026招 如何显示自定义视图 ························14
027招 快速调整文档的显示比例 ················14
第2章 数据的录入与编辑技巧
2.1 定位单元格的技巧 ··························15
028招 使用定位命令定位活动单元格 ·········15
029招 快速选择包含数据的单元格区域 ······16
030招 使用“定位条件”快速查找
数据有效性区域 ·······························16
031招 使用“查找”定位常量区域 ·············17
2.2 数据的录入技巧 ·····························17
032招 为输入的数据自动添加小数位 ·········17
033招 输入以0开头的数字编号 ··················18
034招 输入货币符号 ··································18
035招 使用键盘快速输入“欧元”符号 ······19
036招 快速输入百分号 ·······························19
037招 输入身份证号码 ·······························20
038招 快速输入分数 ··································20
039招 使用快捷键向下填充内容 ················ 21
040招 使用软键盘快速输入℃符号 ············· 21
041招 设置单元格数字有效输入范围 ·········22
042招 为单元格添加序列选项 ····················22
043招 设置单元格中日期或时间的
有效性 ·············································23
044招 设置单元格中保留的文本长度 ·········23
045招 对单元格区域设置输入提示信息 ······24
046招 对单元格中输入错误的数据
设置出错警告 ··································24
047招 如何在单元格中圈释无效数据 ·········25
048招 快速为其他单元格的数据
设置相同的有效性 ··························25
049招 使用“查找”功能快速搜索数据 ······26
050招 使用“替换”功能快速对内容
进行更改··········································27
2.3 数据的填充技巧 ·····························27
051招 快速输入等差序列数据 ····················27
052招 自动填充步长值为2的等比序列 ········28
053招 添加自定义填充序列提高输入速度 ···28
054招 如何将填充柄隐藏 ···························29
055招 同时在多个单元格中输入相同数据 ···30
2.4 数据的编辑技巧 ·····························30
056招 快速将文本数据转换为数字格式 ······31
057招 将单元格区域公式转化为数值的方法 ····31
058招 快速删除单元格内容及格式 ·············32
059招 将数据复制为图片格式 ····················32
060招 快速减少小数位数 ···························33
061招 快速合并/拆分单元格 ·······················33
062招 在Excel中制作垂直标题 ··················34
063招 隐藏单元格中的内容 ························34
2.5 单元格、行/列的编辑技巧 ··············35
064招 如何设置单元格内容自动换行 ·········35
065招 快速插入单元格 ·······························36
066招 快速插入连续的多行/多列 ···············37
067招 对多行/列数据进行移动 ···················37
068招 设置行/列最合适的行高/列宽 ···········38
069招 将联系电话分列为“区号”和
“号码”··········································39
2.6 批注与超链接的应用技巧 ···············40
070招 在值为0的单元格中
鄂公网安备 42010302001612号 