Office 使用技巧OFFICE经验交流目录1 EXCEL................................................................... (1)1.1 输入数据的注意事项 ..................................................................... ...............................1 1.2 自动填充 ..................................................................... .................................................1 1.3 单元格内换行 ..................................................................... ..........................................1 1.4 缩小字体填充 ..................................................................... ..........................................1 1.5 冻结窗口 ..................................................................... .................................................2 1.6 筛选 ..................................................................... .........................................................2 1.7 数据有效性 ..................................................................... ..............................................3 1.8 简单公式 ..................................................................... .................................................4 1.9 编辑技巧 ..................................................................... . (4)1.9.1 输入15位以上数据 ..................................................................... . (4)1.9.2 分数的输入...................................................................... .. (5)1.9.3 序列“001”的输入 ..................................................................... (5)1.9.4 日期的输入...................................................................... .. (5)1.9.5 填充条纹 ..................................................................... (5)1.9.6 多张工作表中输入相同的内容 ..................................................................... (5)1.9.7 不连续单元格填充同一数据 ..................................................................... . (5)1.9.8 快速清除单元格的内容 ..................................................................... .. (5)1.9.9 单元格内容的合并 ..................................................................... . (5)1.9.10 条件显示 ..................................................................... . (6)1.9.11 自定义格式 ..................................................................... .....................................6 1.10 函数 ..................................................................... . (10)2WORD ................................................................... . (10)2.1 文档比较 ..................................................................... ...............................................10 2.2 打印缩放 ..................................................................... ...............................................10 2.3 插入公式 ..................................................................... ...............................................10 2.4 表格、文本转换...................................................................... ....................................11 2.5 自动编号 ..................................................................... .. (11)2.5.1 自动编号的优点 ..................................................................... .. (11)2.5.2 设置自动编号 ..................................................................... (12)2.5.3 以部门制度为例创建自动编号文档 (12)2.5.4 表格列自动编号举例 ..................................................................... ......................12 2.6 自动生成目录 ..................................................................... . (12)2.6.1 自动生成目录的前提 ..................................................................... . (12)2.6.2 自动生成目录的操作 ..................................................................... ......................12 2.7 格式刷 ........................................................................................................................12 2.8 查找替换 ..................................................................... ...............................................13 2.9 文档结构图 ..................................................................... ............................................13 2.10 标题行重复 ..................................................................... ............................................13 2.11 超链接 ..................................................................... ...................................................13 2.12 分节 ..................................................................... .......................................................13 2.13 奇偶页眉页脚 ..................................................................... ........................................14 2.14 修改模板 ..................................................................... .. (14)很高兴和大家一起交流Office经验交流 1 EXCEL1.1Microsoft Excel 提供了一系列功能，可以很方便地管理和分析数据。