Excel使用技巧集锦——163种技巧目录一、基本方法....................................................11.快速选中全部工作表.........................................12.快速启动EXCEL..............................................13.快速删除选定区域数据.......................................14.给单元格重新命名...........................................25.在EXCEL中选择整个单元格范围................................26.快速移动/复制单元格........................................37.快速修改单元格式次序.......................................38.彻底清除单元格内容.........................................39.选择单元格.................................................410.为工作表命名.............................................411.一次性打开多个工作簿.....................................512.快速切换工作簿...........................................613.选定超级链接文本（微软OFFICE技巧大赛获奖作品）...........614.快速查找.................................................615.修改默认文件保存路径.....................................716.指定打开的文件夹.........................................717.在多个EXCEL工作簿间快速切换..............................818.快速获取帮助.............................................819.创建帮助文件的快捷方式...................................820.双击单元格某边移动选定单元格.............................821.双击单元格某边选取单元格区域.............................922.快速选定不连续单元格.....................................923.根据条件选择单元格.......................................924.复制或移动单元格........................................1025.完全删除EXCEL中的单元格.................................1026.快速删除空行............................................1027.回车键的粘贴功能........................................1128.快速关闭多个文件........................................1129.选定多个工作表..........................................1130.对多个工作表快速编辑....................................1231.移动和复制工作表........................................1232.工作表的删除............................................1233.快速选择单元格..........................................1334.快速选定EXCEL区域（微软OFFICE技巧大赛获奖作品）.........1335.备份工件簿..............................................1336.自动打开工作簿..........................................1437.快速浏览长工作簿........................................1438.快速删除工作表中的空行..................................1439.绘制斜线表头............................................1540.绘制斜线单元格..........................................1641.每次选定同一单元格......................................1642.快速查找工作簿..........................................1643.禁止复制隐藏行或列中的数据..............................1744.制作个性单元格..........................................17二、数据输入和编辑技巧.........................................1845.在一个单元格内输入多个值................................1846.增加工作簿的页数........................................1847.奇特的F4键.............................................1848.将格式化文本导入EXCEL....................................1949.快速换行................................................1950.巧变文本为数字..........................................2051.在单元格中输入0值......................................2052.将数字设为文本格式.............................
