65个excel操作教程大全，新手很容易上手，意见保藏备用
<div style="color: black; text-align: left; margin-bottom: 10px;">
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">阅读前请点击右上角“关注”，<span style="color: black;">每日</span>免费获取职场文化及管理知识。职场千里马文化，只做职场干货，完全免费分享！</strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">Excel表格在工作中常常要用到，<span style="color: black;">倘若</span>你是Excel表格新手，不<span style="color: black;">晓得</span>怎么制作表格的话，<span style="color: black;">能够</span><span style="color: black;">瞧瞧</span>本文<span style="color: black;">供给</span>的<strong style="color: blue;">Excel表格操作技巧汇总</strong><span style="color: black;">仔细</span>教程。</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">1、</span>文件操作</strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、为excel文件添加打开<span style="color: black;">秘码</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>文件 → 信息 → <span style="color: black;">守护</span>工作簿 → 用<span style="color: black;">秘码</span>进行加密</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、为文件添加作者信息</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>文件 → 信息 → <span style="color: black;">关联</span>人员 → 在作者栏输入<span style="color: black;">关联</span>信息</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、让多人<span style="color: black;">经过</span>局域网共用excel文件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>审阅 → 共享工作簿 → 在打开的窗口上选中“<span style="color: black;">准许</span>多用户<span style="color: black;">同期</span>编辑...”</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">4、<span style="color: black;">同期</span>打开多个excel文件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>按ctrl或shift键<span style="color: black;">选择</span>多个要打开的excel文件，右键菜单中点“打开”</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">5、<span style="color: black;">同期</span>关闭所有打开的excel文件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>按shift键<span style="color: black;">同期</span>点右上角关闭按钮</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">6、设置文件自动<span style="color: black;">保留</span>时间</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>文件 → 选项 → <span style="color: black;">保留</span> → 设置<span style="color: black;">保留</span>间隔</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">7、恢复未<span style="color: black;">守护</span>的excel文件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>文件 → <span style="color: black;">近期</span>所用文件 → 点击“恢复未<span style="color: black;">保留</span>的excel文件”</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">8、在excel文件中创建日历</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>文件 → 新建 → 日历</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">9、设置新建excel文件的默认字体和字号</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>文件 → 选项 → 常规 → 新建工作簿时：设置字号和字体</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">十、</span>把A.xlsx文件图标<span style="color: black;">表示</span>为<span style="color: black;">照片</span>形式</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>把A.xlsx 修改为 A.Jpg</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">11、一键新建excel文件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>Ctrl + N</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">12、把工作表另存为excel文件</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>在工作表标签上右键 → 移动或复制 → 移动到”新工作簿”</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">2、</span>窗口设置</strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、<span style="color: black;">同期</span>打开对比两个或多个excel文件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>视图 → <span style="color: black;">所有</span>重排 → 选<span style="color: black;">摆列</span>的方向</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、<span style="color: black;">同期</span><span style="color: black;">查询</span>一个工作簿中的两个工作表</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>视图 → 新建窗口 → <span style="color: black;">所有</span>重排 → 选<span style="color: black;">摆列</span>方向</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、<span style="color: black;">隐匿</span>或<span style="color: black;">表示</span>excel最上面的功能区</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>Ctrl+F1</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">4、<span style="color: black;">隐匿</span>excel工作表界面</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">选择</span>要<span style="color: black;">隐匿</span>的工作表 → 视图 → <span style="color: black;">隐匿</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">5、让标题行始终<span style="color: black;">表示</span>在最上面</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>视图 → 冻结窗格 → 冻结首行</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">6、把窗口拆分成上下两部分，都<span style="color: black;">能够</span>上下翻看</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">选择</span>要拆分的位置 → 视图 → 拆分</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">7、<span style="color: black;">调节</span>excel工作表<span style="color: black;">表示</span>比例</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>按ctrl+滚轮</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">8、快速切换到另一个excel窗口</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>ctrl + tab键</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">9、全屏<span style="color: black;">表示</span>excel界面</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>视图 → 全屏<span style="color: black;">表示</span></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">3、</span>单元格<span style="color: black;">表示</span></strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、<span style="color: black;">隐匿</span>0值</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>文件 → 选项 → 高级 → 去掉“在<span style="color: black;">拥有</span>零值.....”勾选</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、<span style="color: black;">隐匿</span>单元格内所有值</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>ctrl+1打开单元格设置窗口 → 数字 → 自定义 → 右边文框中输入三个分号;;;</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、<span style="color: black;">隐匿</span>编辑栏、灰色表格线、列标和行号</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>视图 → <span style="color: black;">表示</span> → 去掉 各项的勾选</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">4、</span>单元格<span style="color: black;">选择</span></strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1 、<span style="color: black;">选择</span>当前表格</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>按ctrl+a全选当前数据区域</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2 、<span style="color: black;">选择</span>表格中的值/公式</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>按ctrl+g打开定位窗口 → 定位<span style="color: black;">要求</span> → 值/公式</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3 、<span style="color: black;">查询</span>值</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>按ctrl+f打开<span style="color: black;">查询</span>窗口，输入<span style="color: black;">查询</span>的值 → <span style="color: black;">查询</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">4、<span style="color: black;">选择</span>最下/最右边的非空单元格</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>按ctrl + 向下/向右箭头</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">5、快速<span style="color: black;">选择</span>指定<span style="color: black;">体积</span>的区域</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>在左上的名<span style="color: black;">叫作</span>栏中输入单元格<span style="color: black;">位置</span>，如a1:a10000，<span style="color: black;">而后</span>按回车</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">5、</span>单元格编辑</strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、设置单元格按回车键光标<span style="color: black;">转</span>方向</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>文件 → 选项→ 高级 → 最上面“按Enter键后移动所选内容” → 设置方向</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、设置下拉菜单，<span style="color: black;">表示</span>A,B,C三个选项</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>数据 → 数据有效性 → <span style="color: black;">准许</span> → 序列 → 输入A,B,C</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、复制表格<span style="color: black;">保留</span>行高列宽不变</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>整行<span style="color: black;">选择</span>复制 → 粘贴后点粘贴选项中的“<span style="color: black;">保存</span>列宽”</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">4、输入到F列时，自动转到下一行的首列</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">选择</span>A:F列，输入后按回车<span style="color: black;">就可</span>自动<span style="color: black;">转</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">5、设置三栏表头</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">插进</span> → 形状 → 直线 → 拖入文本框中输入的字体并把边框设置为无</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">6、<span style="color: black;">同期</span>编辑多个工作表</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>按ctrl或shift键<span style="color: black;">选择</span>多个工作表，直接编辑当前工作表<span style="color: black;">就可</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">7、输入身份证号或以0<span style="color: black;">起始</span>的数字</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>把单元格格式设置成文本，<span style="color: black;">而后</span>再输入</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">8、快速删除空行</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">选择</span>表中某列 → ctrl+g定位 → 定位<span style="color: black;">要求</span> → 空值 → 删除整行</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">9、快速<span style="color: black;">插进</span>空行</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>在表右侧输入序号1,2,3..N,<span style="color: black;">而后</span>再复制该序号到下面空行，最后按序号列排序<span style="color: black;">就可</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">十、</span>快速合并多行数据</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">插进</span>批注 → <span style="color: black;">选择</span>多列数据复制 → 粘贴到批注中，<span style="color: black;">而后</span>再从批注中复制粘至单元格区域中<span style="color: black;">就可</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">11、<span style="color: black;">插进</span>特殊符号</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">插进</span>→ 符号</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">12、<span style="color: black;">查询</span>重复值</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">选择</span>数据列 → <span style="color: black;">起始</span> → <span style="color: black;">要求</span>格式 → <span style="color: black;">明显</span><span style="color: black;">表示</span>单元格规则 → 重复值</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">13、删除重复值</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">选择</span>区域 → 数据 → 删除重复项</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">14、单元格分区域需要<span style="color: black;">秘码</span><span style="color: black;">才可</span>编辑</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>审阅 → <span style="color: black;">准许</span>用户编辑区域</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">15、用excel进行汉英互译</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>审阅 → 翻释</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">16、不复制<span style="color: black;">隐匿</span>的行</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">方法：</strong><span style="color: black;">选择</span>区域 → ctrl+g定位 → 定位<span style="color: black;">要求</span> → 可见单元格 → 复制 → 粘贴</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">17、单元格强制换行</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>在需要换行字符后按alt+enter键</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">6、</span>单元格格式设置</strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、万元<span style="color: black;">表示</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>自定义格式代码：0!.0,万</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、日期按年年年年-月月-日日<span style="color: black;">表示</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>自定义格式代码：yyyy-mm-dd</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、手机号分段<span style="color: black;">表示</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>自定义格式代码：000 0000 0000</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">4、数字1<span style="color: black;">表示</span>成1月</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>自定义格式代码: 0”月”</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">7、</span>打印设置</strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、每页都有标题行</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">有时候表格数据较多，正常打印的时候除了<span style="color: black;">第1</span>页有标题外，其他页都<span style="color: black;">无</span>，那怎么能快速给每页都加上标题呢？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 打印标题 → 顶端标题行 → 设置好需要打印的标题区域</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1532499111494ac8078b655~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=berUquui3fHwg3YC7znrG0epKLw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、打印页眉页脚</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">非常多</span>时候小伙伴们打印的表格页数太多，容易搞乱，<span style="color: black;">此时</span><span style="color: black;">咱们</span>就需要添加页码来<span style="color: black;">加强</span>辨识度。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 页眉/页脚 → 自定义页脚（或页眉）→ 添加页码</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/153249952243058485f0769~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=cps7n5RvkvpRvTX6CuX5wdH4xzI%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、打印表格数据合并到一页</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">非常多</span>小伙伴在<span style="color: black;">调节</span>表格页数的时候都会遇到一个问题：想把所有数据打印在一页纸上，可偏偏会多出一两行数据，<span style="color: black;">引起</span>需要两页纸去打印。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 页面 → 缩放 → <span style="color: black;">调节</span>为1页宽1页高</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1532499543289ca95c44539~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=XhoDoMGlyBH7aSEdNbfIj5Wj9oQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">4、设置居中打印</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">打印表格时<span style="color: black;">通常</span>默认是居左，怎么<span style="color: black;">才可</span>居中打印呢？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 页边距 → 居中方式 → 勾选水平、垂直</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p26-sign.toutiaoimg.com/pgc-image/15324995645357dd1736292~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=LG7f%2Fn0YYXrmmb20v%2BBzxY1xkM8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">5、指定区域打印</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">咱们</span>在打印<span style="color: black;">非常多</span>数据时，有时不想打印<span style="color: black;">所有</span>数据，只需要打印一部分，<span style="color: black;">咱们</span><span style="color: black;">能够</span>设置指定的打印区域。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 工作表 → 打印区域 → 设置好需要打印的区域</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1532499709738bdc4716f8c~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=oeIOgg3tv8oK%2FnzMgVW6U2WY8Hg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">6、打印不<span style="color: black;">表示</span>错误值</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">工作表中有时候难免会<span style="color: black;">显现</span>错误值，<span style="color: black;">怎样</span><span style="color: black;">才可</span>不<span style="color: black;">表示</span>错误值，以便于打印出来后能灵活填写呢？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 工作表 → 错误单元格打印为 → <span style="color: black;">选取</span><空白></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/15325656690201846775a43~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=TpCVD1gXKxDc8QztamtUQT7j9WQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">7、单色打印</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">有时候为了<span style="color: black;">明显</span>重点数据，有些小伙伴会在单元格中填充底色，<span style="color: black;">然则</span><span style="color: black;">机构</span><span style="color: black;">一般</span>用的都是黑白打印机，打印出来的效果真是不咋地。那<span style="color: black;">怎样</span><span style="color: black;">才可</span>去除底色打印呢？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 工作表 → 打印 → 勾选单色打印</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1532565692735376b840f31~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=MW%2FDJQ9QiP6CHGz2FiuOhrXm0Sc%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">8、打印单元格批注</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单元格中<span style="color: black;">插进</span>批注后，<span style="color: black;">怎样</span><span style="color: black;">才可</span><span style="color: black;">表示</span>批注打印呢？</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 工作表 → 打印 → 批注 → <span style="color: black;">选取</span>“工作表末尾”</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1532565713452e92f923760~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=U7n%2FSlCGo5qk1J49nJ5Ike9dUEw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">9、打印行号列标</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 工作表 → 打印 → 勾选行号列标</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/1532565730623a724fdf212~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=kXsh1IscgWjsEA2XmSdnUlt5wP8%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">十、</span>设置横向打印</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">当工作表里列数据较多，而<span style="color: black;">咱们</span><span style="color: black;">选取</span>的又是纵向打印时，就会<span style="color: black;">发掘</span>列数据<span style="color: black;">没法</span>在一页上<span style="color: black;">表示</span>，那怎么<span style="color: black;">才可</span><span style="color: black;">处理</span>呢？<span style="color: black;">这儿</span><span style="color: black;">咱们</span>只需设置为横向打印<span style="color: black;">就可</span>。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>点击页面布局 → 页面设置 → 页面 → 方向 → <span style="color: black;">选取</span>横向</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/pgc-image/15325657540367528a73af0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982625&x-signature=oZpuliwRr8NPrnGXIvCfPHOTGx0%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">11、按厘米设置行高</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>视图 → 页面布局，在页面布局下行高单位是厘米</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">12、<span style="color: black;">插进</span>分页符</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">选择</span>要<span style="color: black;">插进</span>的位置 → 页面布局 → 分页符 → <span style="color: black;">插进</span>分页符</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;"><span style="color: black;">8、</span><span style="color: black;">照片</span>处理</strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">1、删除工作表中所有<span style="color: black;">照片</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>ctrl+g定位 → 定位<span style="color: black;">要求</span> → 对象 → 删除</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">2、工作表<span style="color: black;">插进</span>背景<span style="color: black;">照片</span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong>页面布局 → 背景 → <span style="color: black;">选取</span><span style="color: black;">插进</span><span style="color: black;">照片</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">3、<span style="color: black;">插进</span><span style="color: black;">能够</span>打印的背景</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">办法</span>：</strong><span style="color: black;">插进</span> → 页眉页脚 → <span style="color: black;">选择</span>页眉后点<span style="color: black;">照片</span> → <span style="color: black;">选择</span><span style="color: black;">照片</span>并拖入</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">声明</strong>：素材源自人民日报<span style="color: black;">博客</span>，版权归原作者所有，如有侵权请联系处理。</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;"><span style="color: black;">商场</span>合作，请私信后台“合作”，获取联系方式！</strong></p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;"><strong style="color: blue;">欢迎关注【职场千里马文化】头条号，<span style="color: black;">每日</span>学点职场文化，助力升职加薪！</strong></h1>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">网友都在看：</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">致管理者：宁可手下无人可用，<span style="color: black;">亦</span>要辞退这类消极员工！</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">执行力差，大<span style="color: black;">大都是</span>管理无能：高层控方向、中层提效率、基层抓团队！</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">「干货」最全的格式转换！PDF,WORD,PPT，<span style="color: black;">区别</span>文件<span style="color: black;">到底</span><span style="color: black;">怎样</span>转换</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">Word<span style="color: black;">基本</span>操作</a>教程大全，非常<span style="color: black;">仔细</span>，帮你<span style="color: black;">加强</span>工作效率！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">一组动图教你学会Word操作技巧，<span style="color: black;">容易</span><span style="color: black;">加强</span>工作效率</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">实用！20个Word文字处理技巧，学会不求人、<span style="color: black;">快速</span><span style="color: black;">加强</span>工作效率！</a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;">Excel快捷键大全，<span style="color: black;">保藏</span>起来备用！</a></p>
</div>
页:
[1]