m5k1umn 发表于 2024-10-1 14:28:26

18个Excel常用技巧，让你的工作效率加强10倍！


    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">文案</span>最后有彩蛋！好礼相送！</span></strong></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/0f29d2203a734dc6b04ad5aa24ba294b~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=NIhOC6aPp7kZy1ZpBLlRzuOoj7w%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;">Excel秘籍大全，前言</strong></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">编写和<span style="color: black;">运用</span>公式是 Excel 中最重要的操作之一。<span style="color: black;">倘若</span>你经常<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><span style="color: black;">特别有</span>用的技巧，以节省在 Excel 中编写和<span style="color: black;">运用</span>公式的时间。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">Excel秘籍大全</span></span><span style="color: black;">，正文<span style="color: black;">起始</span></span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">01</span></strong><span style="color: black;">不要在输入公式时添加括号</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">当单独输入一个函数（SUM，AVERAGE 等）时，你无需输入最后的右括号。</p>例如，只需输入：=SUM (A 1: A 10，<span style="color: black;">而后</span>按 Enter 键。Excel 将自动添加右括号。

    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ea8725dcc35145d49ab0368b7085847c~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=C6NzsvtWdw0lvWpUeyvXm8r1T%2BA%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">提示</span></strong><span style="color: black;">：<span style="color: black;">倘若</span>输入公式<span style="color: black;">包括</span>多组括号，则不起<span style="color: black;">功效</span>。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">02</span></strong><span style="color: black;">移动公式并防止引用更改</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">Excel 最强大的功能之一是相对<span style="color: black;">位置</span>（如在公式中<span style="color: black;">表示</span>的“A 1”、“B 2”这类单元格<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></span></p><span style="color: black;"><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><span style="color: black;"><span style="color: black;">倘若</span>要将公式移动到更远的位置，请<span style="color: black;">运用</span>剪切和粘贴。（按 Ctrl + X ，后移动到<span style="color: black;">目的</span>单元格再按 Ctrl + V ）。剪切公式时，其引用不会更改。</span>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/c170fab38bcb4366917fa7ede1735375~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=hUTwW4tAu8NFHOIalEmjXhi3d%2Fw%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">03</span></strong><span style="color: black;">复制公式并防止引用更改</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">这个比较简单，复制粘贴就<span style="color: black;">能够</span>。在编辑栏中<span style="color: black;">选取</span><span style="color: black;">全部</span>公式并复制到剪贴板。<span style="color: black;">而后</span>，在新位置粘贴，结果将是一个与原始公式相同的公式。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">04</span></strong><span style="color: black;">双击填充手柄以复制公式</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">在添加公式时，最常用的操作之一是将公式从表的<span style="color: black;">第1</span>行复制到表的最后一行。<span style="color: black;">通常</span>是选中单元格后向下拖动到表的底部来填充公式，<span style="color: black;">倘若</span><span style="color: black;">运用</span>填充柄则能快速的将公式复制到表的底部。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">填充柄是<span style="color: black;">位置于</span>所选单元格右下角的小矩形，只要公式<span style="color: black;">位置于</span>另一列旁边的一列中，只需双击填充柄<span style="color: black;">就可</span>将公式<span style="color: black;">始终</span>复制到表格底部。</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/319ec692624647fdb14a1993f127f20d~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=l3%2FP8Ppi8k3FU%2F%2FO7aKt2pYi2d4%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">提示</span></strong><span style="color: black;">：<span style="color: black;">倘若</span>输入的公式左侧<span style="color: black;">无</span>完整的数据列，双击填充柄则不起<span style="color: black;">功效</span>。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">05</span></strong><span style="color: black;"><span style="color: black;">运用</span>表格自动输入公式</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">输入公式的更快<span style="color: black;">办法</span>是将数据表转换为 Excel 表格。将数据转换为表格后（按 Ctrl + T），在<span style="color: black;">第1</span>行中输入的公式将自动复制到表格整列。<span style="color: black;">这般</span><span style="color: black;">能够</span>节省<span style="color: black;">海量</span>时间，<span style="color: black;">亦</span>有助于防止错误。</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6c5f106ce2b34f9480fe0d24cac47cc8~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=K3OGRbaeQMhFP9FaB2Cj6FxFzho%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">提示</span></strong><span style="color: black;">：表格中的公式将自动<span style="color: black;">运用</span>结构化引用（即上面的示例中的 [@数量]和[@单价]）</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">倘若</span>对Excel快捷键还不<span style="color: black;">熟练</span>，请阅读</span><span style="color: black;">你需要<span style="color: black;">晓得</span>的58个Excel键盘快捷键</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">06</span></strong><span style="color: black;"><span style="color: black;">运用</span> Tab 键自动输入函数名<span style="color: black;">叫作</span></span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">当输入等号后，Excel 将<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>按 Tab 键“<span style="color: black;">需求</span>”Excel 将函数名<span style="color: black;">叫作</span>补齐。</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/a98efea475cc4a10acec7c48ff0950fc~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=1WpUTWgnsw44ftTGGprvfeDkAaY%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">这儿</span>分享一个<span style="color: black;">运用</span> Tab 键的小技巧，<span style="color: black;">便是</span>在输入完公式后，不是按 Enter 键，而是按 Tab 键，<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></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">07</span></strong><span style="color: black;"><span style="color: black;">运用</span> Ctrl + 单击输入函数参数</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">如不<span style="color: black;">爱好</span>在参数之间输入逗号？<span style="color: black;">能够</span>让 Excel 为你做。当在函数中输入参数时，只需按住 Ctrl 并单击<span style="color: black;">每一个</span>引用，Excel 将自动输入逗号。</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0e07696496294893827a9d52f1b41fde~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=JbqJOt7PzDuFRiDhF2D0rdHVbKQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">08</span></strong><span style="color: black;"><span style="color: black;">运用</span>函数公式提示窗口<span style="color: black;">选取</span>参数</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">当<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>嵌套括号。</span></span></p><span style="color: black;">单击将光标置于要<span style="color: black;">选取</span>其参数的函数内，Excel 将<span style="color: black;">表示</span>该函数的提示，<span style="color: black;">包含</span>所有的参数。</span><span style="color: black;">单击要<span style="color: black;">选取</span>的参数，Excel 将<span style="color: black;">选取</span><span style="color: black;">全部</span>参数，<span style="color: black;">这般</span>能很方便的更改公式参数或调试公式。</span>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6cc07422be32413bb21cd3ee5ec1dc0f~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=2gz7U55VR5cK9rffMrerrysKhHY%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">09</span></strong><span style="color: black;"><span style="color: black;">运用</span>快捷键<span style="color: black;">插进</span>函数参数占位符</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">一般</span>，在输入公式时，Excel 会在添加逗号时<span style="color: black;">供给</span><span style="color: black;">相关</span>每个参数的提示。如<span style="color: black;">期盼</span>让 Excel 一次性<span style="color: black;">表示</span>所有该函数参数，则<span style="color: black;">运用</span>快捷键 Ctrl + Shift + A。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">例如，输入“=DATE”，<span style="color: black;">而后</span>按 Ctrl + Shift + A，会在编辑栏和单元格<span style="color: black;">表示</span>“=DATE (year, month, day)”，且会选中函数的<span style="color: black;">第1</span>个参数。这是可直接更改参数的值或单击下参数<span style="color: black;">运用</span>“函数提示”窗口<span style="color: black;">选取</span>参数，并将其更改为所需的值。</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/aef6f675af164c92b2253907749cb702~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=FYRi4BrfYsmPZBGFntyLlYgO4KQ%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">10</span></strong><span style="color: black;"><span style="color: black;">运用</span>定义名<span style="color: black;">叫作</span>让编写公式更简单</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">定义名<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>的工作簿和长公式<span style="color: black;">尤其</span>有用。</span></span></p><span style="color: black;"><span style="color: black;">选取</span>要定义名<span style="color: black;">叫作</span>的单元格或单元格范围。</span><span style="color: black;"><span style="color: black;">而后</span>直接在名<span style="color: black;">叫作</span>框上方的输入栏中输入名<span style="color: black;">叫作</span>，例如输入“单价”，并按下 Enter 键。</span><span style="color: black;">在公式中<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>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/891dfef8ae6744c1aea3f656752f3b7d~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=NZT8g%2BXs6aD7TMTx1W5txHDe3M4%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">11</span></strong><span style="color: black;"><span style="color: black;">表示</span>工作表中所有公式</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">每当编辑<span style="color: black;">包括</span>公式的单元格时，都会自动<span style="color: black;">表示</span>公式而不是其结果。若想一次查看工作表上的所有公式，只需<span style="color: black;">运用</span>快捷键 Ctrl + ~（<span style="color: black;">曲折</span>号）。<span style="color: black;">运用</span>此快捷方式，<span style="color: black;">能够</span>在<span style="color: black;">表示</span>单元格值或公式之间切换。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">12</span></strong><span style="color: black;">一次<span style="color: black;">选取</span>工作表中的所有公式</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">运用</span> Excel 定位功能<span style="color: black;">选取</span>工作表中的所有公式。</span></span></p><span style="color: black;"><span style="color: black;">首要</span>在工作表中<span style="color: black;">选取</span>任意单元格，<span style="color: black;">而后</span>按 Ctrl + G，打开“定位”对话框。</span><span style="color: black;">
      <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">单击“定位<span style="color: black;">要求</span>”按钮 -&gt; <span style="color: black;">选取</span>“公式”-&gt; 单击“确定”。</p><span style="color: black;">此刻</span>，工作表中的所有<span style="color: black;">包括</span>公式的单元格都会被选中。
    </span>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/eb67f1500ead451db23cafb5e383e62c~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=Ic3zGSXXkE899JsNEkgfaTPEDfI%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">13</span></strong><span style="color: black;"><span style="color: black;">运用</span><span style="color: black;">选取</span>性粘贴将公式转换为静态值</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">咱们</span><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>，最好的办法是将公式转换为值。</span></span></p><span style="color: black;"><span style="color: black;">首要</span>，<span style="color: black;">选取</span>要转换的公式并复制到剪贴板。</span><span style="color: black;">按 Ctrl + Alt + V 打开“<span style="color: black;">选取</span>性粘贴”对话框</span><span style="color: black;"><span style="color: black;">选取</span>“值”后单击“确定”，<span style="color: black;">此时</span>所<span style="color: black;">选取</span>的公式都已转换为值。</span><span style="color: black;">最后，按 Esc 键，取消“剪切”。</span>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/4523cbafc9a24af683ab0055443018ad~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=w8h5qeK15XQ2F9v9ALfcD2bbyy0%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">14</span></strong><span style="color: black;"><span style="color: black;">保留</span>未完成的公式</span></span></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>在公式的开头（在 = 之前）添加一个（’）撇号，<span style="color: black;">或</span>完全删除等号。在这两种<span style="color: black;">状况</span>下，Excel 将停止计算公式，并按原样<span style="color: black;">保存</span>公式。
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">15</span></strong><span style="color: black;"><span style="color: black;">运用</span>F4切换相对引用和绝对引用</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">运用</span> F 4 键<span style="color: black;">能够</span>快速切换公式中对单元格或区域的相对引用、绝对引用和混合引用，省去了输入美元符号的麻烦。每按一次 F 4 键，都会按：完全相对（A 1）-&gt; 完全绝对（1）-&gt; 绝对行（A $ 1）-&gt; 绝对列（$ A 1）<span style="color: black;">次序</span>循环切换。</span></span></p><span style="color: black;"><span style="color: black;">针对</span>引用单个单元格，将光标放入参数中，按 F 4 键<span style="color: black;">就可</span>。</span><span style="color: black;"><span style="color: black;">针对</span>引用的单元格区域，如 A 1：A 10，则选中 A 1：A 10 后再按 F 4 键。</span>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/0de611f2862b4d55af99801d05ac4761~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=fFnePRWstpXQUuCGz8Gth0bi7ew%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">16</span></strong><span style="color: black;">为嵌套的 IF 添加换行符，使其更易于阅读</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">创建嵌套的 IF 公式时，在括号中跟踪 True 参数和 False 参数可能会变得非常混乱，且很容易在<span style="color: black;">规律</span>上犯错误。有一种简单的<span style="color: black;">办法</span><span style="color: black;">能够</span>使<span style="color: black;">拥有</span>多个 IF 语句的公式更易于阅读：只需在<span style="color: black;">每一个</span> True 参数后向公式添加换行符<span style="color: black;">就可</span>。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">17</span></strong><span style="color: black;"><span style="color: black;">运用</span>自动求和输入 SUM 公式</span></span></p><span style="color: black;">行求和或列求和：只需<span style="color: black;">选取</span><span style="color: black;">需求</span>和的单元格右侧或下方的空单元格，<span style="color: black;">而后</span>按 Alt + =，Excel 将在空单元格中插入 SUM 函数公式。</span><span style="color: black;">多行求和或多列求和：若要对多行求和，请在行右侧的列中<span style="color: black;">选取</span>空单元格区域。若要对多列求和，请<span style="color: black;">选取</span>列下方的空单元格区域。<span style="color: black;">而后</span>按 Alt + =。</span><span style="color: black;">最后，<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>按 Alt + =。Excel 将在空单元格中添加适当的 SUM 函数，只需一步<span style="color: black;">就可</span>为计算出列总计，行总计和总计。</span>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/7c98222b4ae544a2a257eb0a41455d68~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=OJ9tfy0PyG59L2sIxIhIMGxixhI%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">18</span></strong><span style="color: black;">一次在多个单元格中输入相同的公式</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">如需要在一组单元格中输入相同的公式，<span style="color: black;">能够</span><span style="color: black;">运用</span>快捷键 Ctrl + Enter 一步完成此操作。只需<span style="color: black;">同期</span><span style="color: black;">选取</span>所有单元格，<span style="color: black;">而后</span>像输入单个单元格<span style="color: black;">同样</span>正常输入公式。完成后，不要按 Enter，而是按 Ctrl + Enter。Excel 会将相同的公式添加到所选内容中的所有单元格，并<span style="color: black;">按照</span>需要<span style="color: black;">调节</span>引用。</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">还<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>按 Ctrl + Enter。</span></span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/5dc77600f1e54759b4047df96b170ea8~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=GuzDMiZu5LyhvCNJ3nKUusVKxAw%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">以上分享的是在 Excel 编写和<span style="color: black;">运用</span>的公式时的<span style="color: black;">有些</span>技巧，<span style="color: black;">意见</span>收藏后试一下。</p>还有<span style="color: black;">那些</span>这方面有用的技巧，欢迎在评论区留言或私信！

    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">以下<strong style="color: blue;"><span style="color: black;">《900套高逼格工作模板.xls 》免费下载，不收一分钱！</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">常用Excel</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">用Excel玩好报表</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">是必不可缺的技能</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">要<span style="color: black;">晓得</span>一张好的图表</span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">能够</span>做到一图胜千言！</span></p>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/647b33d26e544d55ad5488d62dcd7f18~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=Mm1M9V98hmOmAPkKH%2F8OvLiNNR4%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/53ca178b281d48fe888d2ac80901ad3d~noop.image?_iz=58558&amp;from=article.pc_detail&amp;lk3s=953192f4&amp;x-expires=1727968441&amp;x-signature=02vqP8aLwzdWl8M6weJ%2Ba7RYs9M%3D" style="width: 50%; margin-bottom: 20px;"></div>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">今天<span style="color: black;">举荐</span>的<span style="color: black;"><span style="color: black;">超实用干货</span></span>是</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">《900套高逼格工作模板.xls 》</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">3.2G高逼格Excel可视化模板</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">制作精美 可直接套用</strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><strong style="color: blue;">适合自用和内部培训<span style="color: black;">运用</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">领取方式</span></span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">关注<span style="color: black;">咱们</span></span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">私信发送关键字：</span><strong style="color: blue;"><span style="color: black;">900</span></strong></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;"><span style="color: black;">就可</span>免费领取</span></span></p>
    <p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;"><span style="color: black;">资料<span style="color: black;">源自</span>于网络，公益分享，如有侵权，联系删除</span></span></p>




4lqedz 发表于 2024-11-9 15:44:44

太棒了、厉害、为你打call、点赞、非常精彩等。
页: [1]
查看完整版本: 18个Excel常用技巧，让你的工作效率加强10倍！