逆天了！excel表格中这般拖动鼠标，竟能够处理90%的工作困难【Excel教程】
<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>免费学习Excel全套技巧视频</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><a style="color: black;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMxV8NQuIYAqxQDicBpYDdSC35rDWzXBIb9ptw1PbsaesV6wOdiaK4bHibteuiaq4HF6JrReEwNyy7a4Gw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></a></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><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>来盘点一下，Excel中<span style="color: black;">哪些</span>"拖拖拉拉"的<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;"><strong style="color: blue;">part 1 </strong><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;">skill 1，选中多行后，拖动<span style="color: black;">调节</span>任意一行或一列的行宽或列宽，则所有选中的行或列都被批量<span style="color: black;">调节</span>至相同行高/列宽。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qeStlNzQDaTZ9ichXQg8bHhdnibvEEibVrG26gIibuwiaOaEJH38NxJTVw0A/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><strong style="color: blue;">QQ群：806440210下载练习课件</strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">skill 2，向上拖动某一行边线或向左拖动某一列边线至该行/列的两条边线重叠，<span style="color: black;">就可</span><span style="color: black;">隐匿</span>该行/该列。继续向上或向左拖动该边线，就<span style="color: black;">能够</span><span style="color: black;">隐匿</span>多行/列。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qRQ3PwO88N3c2SONzDPlF3Ac08Kyh2ibicMqtpIHGVFp9aQ3NOwqBmD5g/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">skill 3，<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></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 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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qCL4t2Nib3NbGtItGVuc4oT0Ie2U7jHJxZTDR2h2PL7z228XkowGY70A/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qwYWfuPYZtnxUNGGdPbbAibTC30XjjdeQ9p4qicQA5PM1Jq5rbibmn92Vw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">（列标题则为</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qEmhQiaiawvZoNOm6ZmI7UgrMg9YqdSkRAu0bzYBWEyVn3vZrsvNXMaIA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">），按住鼠标左键向下（或向右）拖动边线，松开鼠标<span style="color: black;">就可</span>取消<span style="color: black;">隐匿</span>行/列。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87q75aJtfAeFUJEXWRrUomlh1DUsFSRlEPQVdiau6b1fbBl9TF1G99xHkQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;">part 2</strong><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;">鼠标右键拖动，这是一个连Excel老鸟都不<span style="color: black;">晓得</span>的技能。它的功能非常接地气，一个鼠标，搞定<span style="color: black;">哪些</span>频繁<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;">1．选中连续的数据区域。将鼠标移动到区域右侧边线位置，鼠标变为实心箭头十字<img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qeDvV5XBfc5uVLicfYX9sc3Sr6xXibwbIrOiatpppeBCoR55mPkS4Uj0nQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87q5MUYyB1uvoiaIOKXSialu3CaW9s08UkLDTbudkafKNRu20DwoiaY14zzw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">2．按住鼠标右键，将区域拖动至任意位置。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qjq67zlHK4v6jyY8r8kuDhqpMv6jhqz07ficH17yZeCYx1OsESBabEyQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">3.松开鼠标，弹出右键拖动菜单，<span style="color: black;">选取</span>对应的功能<span style="color: black;">就可</span>。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qasXxxxPZ8mRcEvgB3Jj17eSZmibcVXkfA845IBJA9C9fGDUEc05XQMA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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 style="color: black;">插进</span>、复制、链接等多项功能，下面<span style="color: black;">咱们</span>仅示范一个特殊的用法，<span style="color: black;">能够</span>去除公式只<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 style="color: black;">选取</span>【仅复制数值】，搞定！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qLzUo8no2hXHARSGav6AcFrO5blWpLK2jMUw2NoXdzsna7JbHbnQiciaw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;">part 3 shift</strong><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;">skill 1</span> <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 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>Shift键+鼠标左键拖动<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;">step 1 选中一行或列，将鼠标移动到该行行标题或该列列标题右下方的实心小正方形位置，鼠标变为黑色十字，按住Shift键，此时鼠标变成双线双箭头十字</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qwYWfuPYZtnxUNGGdPbbAibTC30XjjdeQ9p4qicQA5PM1Jq5rbibmn92Vw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qdm0KxbHCJ8l4xjj5ICsgZZNOjJ0hT7wm7iaicsdqBuntxAc8EfBzjc2A/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">step 2 保持按住Shift键，<span style="color: black;">同期</span>按住鼠标左键，向下拖动或向右拖动，使选中的行/列的下边线或右边线与其他行或列的边线重叠；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qiadBtPGmWrd5PO3papP8AtXic4hMfr5lLuTcdcGYjDmCJkYiaOC33wg3w/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">step 3 松开鼠标左键，此时行/列边线拖动多少行/列，就<span style="color: black;">能够</span>在选中行下方或右侧<span style="color: black;">插进</span>对应数量的行/列</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qDG56iaCib9VEn21BnEVMqD9ATT2PDXFIibkIqNZzTqMw1cUozAVHnXqhA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;">skill 2</span> 移动区域放到指定位置</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Shift键<span style="color: black;">协同</span>左键拖动，<span style="color: black;">能够</span>将单元格区域<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;">step 1 <span style="color: black;">选取</span>连续的单元格区域，将鼠标移动到区域边上，鼠标变为带箭头的实心十字<img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87q2pwUFicqpNCl63Pz7X8QnWJ6PhWYZ1dr73uDIAiblOu93uAwCFibGHAuQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">；</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qJ9aibgSwkDZkia3Fgc9Sw2Lb1Fx7VvRMZp1p1swtMSHbURibbo1xCjzMA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Step 2 按住Shift键，<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></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qL05YLGksgX6ggZYBib45ib0LtQLDq7YIA2K7U9Z1jbrl93zCxmWefgGA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Step 3 松开鼠标和键盘，完成单元格区域的移动。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87q80piacnIRBg4yS7sc5T4PXJcwyrLAL2p0kCJdXTelPqNMQEOayiaCqEg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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 style="color: black;">倘若</span><span style="color: black;">咱们</span><span style="color: black;">选取</span>将一行或一列Shift拖动<span style="color: black;">插进</span>到相邻行/列位置上，就<span style="color: black;">能够</span>实现<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;">step 1 点击行/列标题，选中该行/列，移动鼠标至行/列边线。<span style="color: black;">同期</span>按住Shift键和鼠标左键，拖动该行/列至相邻行/列边线位置。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qABSx3PGtLwibjFmupZican4jrJfDoib58z04pFFaDeE4FqvBL92UfQSyw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">step 2 松开Shift和鼠标左键，完成行/列交换。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qQRtHc7bkaibick6icfQNXQ2RE4tGIjCaFMGpKCheIQ2Ibib5xW1NDqe8Xw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;">part 4 Ctrl</strong><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;"><span style="color: black;">skill 1 </span> 拖动复制单元格区域</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">step 1 选中单元格区域，将鼠标移动到单元格区域边线位置，鼠标变为带箭头的实心十字</span><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qzIRsCwmia3esFoUILsUc7zN2nGFm1mBibBlWkw5iaibNlsCF1bibYFFGaLA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><span style="color: black;">，按住Ctrl键，在鼠标图形上方<span style="color: black;">显现</span>黑色十字符号。<span style="color: black;">同期</span>按住鼠标左键，将选中区域拖动到指定位置。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qBxnYmuRF0WaBWIiaibgLmiah9mRM63RVe3J0xApvfGUDy98gU2GEZVufg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">step 2 松开鼠标，完成复制。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qlfRKx7SeDCk4FHol1EZer6V2JwCPDGeGKBhMSYmpTica6Euype99GWQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">Ctrl拖动法不仅<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;">Skill 2 </span> 复制工作表</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">step 1 将鼠标移动至工作表标签位置，<span style="color: black;">同期</span>按住Ctrl键和鼠标左键，向任意方向拖动，此时鼠标变为<img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qz2eux1K6vtRhSNiaNXSMckicS1TvJiba4pyGwlpuNhibslTcHK98aqsYzA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;">。</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qQ1nydyauWTSY1VfGtM3q1B3tP3vYXrmy8XMtZyMux4icTrRnAdvhUgA/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">step 2 将鼠标拖动到到任意位置后，松开鼠标完成复制。<span style="color: black;">重视</span>拖动过程中，工作表标签上方会<span style="color: black;">显现</span>一个实心黑色倒三角形</span><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qiatIgTCibNswtJ3aNqZJayyfj6ycnS9BtsMRgVQc7KVH9YSfCib9ibNuXQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"><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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qV16puWKHIfV9rsrCzHtzbfytgYmnTnlpL1CEacMBuiaiatK90axID0xw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;">part 5 Alt</strong><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;"><span style="color: black;">倘若</span>花瓣们想要实现跨表复制单元格区域，那就需要认识下第三个和拖拉<span style="color: black;">相关</span>的按键，它<span style="color: black;">便是</span>Alt键。</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 style="color: black;">办法</span>，还是<span style="color: black;">同样</span>的操作！此处<span style="color: black;">再也不</span>赘言，直接上图！</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz_gif/k6kCsib3eJMyHxwK3oMLvYk8NHcumk87qB3aDIqWwoLTcvPXPrWaGRGSsJic2vwNK7XcfricjgEQAIJQFZjOAXyfA/640?tp=webp&wxfrom=5&wx_lazy=1" style="width: 50%; margin-bottom: 20px;"></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 style="color: black;">发掘</span>，Ctrl、Shift和Alt之间，似乎<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>让你跃跃欲试，不妨打开你的Excel，把你<span style="color: black;">晓得</span>的拖拉技巧都复习一下，有什么新<span style="color: black;">发掘</span>新用法，欢迎留言分享！</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;">想要跟随滴答老师全面系统学习Excel，不妨关注《<span style="color: black;">1星期</span>Excel直通车》视频课或者《Excel极速贯通班》直播课。</span></strong></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;">1星期</span>Excel直通车》</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>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></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;"><strong style="color: blue;"><span style="color: black;">《<span style="color: black;">1星期</span>Excel直通车》</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;">风趣易懂，快速<span style="color: black;">有效</span>，</span></strong></span><span style="color: black;"><strong style="color: blue;"><span style="color: black;">带您7天学会Excel</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;">38 </strong></span><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;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;"><strong style="color: blue;"><span style="color: black;">（已更新完毕，可永久学习）</span></strong></span></strong></span></strong></span></strong></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></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;"><img src="https://mmbiz.qpic.cn/mmbiz_jpg/k6kCsib3eJMw9HqsFgNibg3wrgklctzmiaton0P5Rr0efiaGAzyScpqGmtKMTX4m2HhJh3Kalv4BqrRgmDsZGzLcWw/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;">课程粉丝100万+；</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>有《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;">原价299元</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 style="color: black;"><strong style="color: blue;"><span style="color: black;">99</span></strong></span></span><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></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>的Excel职场技能！</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;"><img src="https://mmbiz.qpic.cn/mmbiz_png/k6kCsib3eJMx9yReibpHJNVMvB4RK0ibylhqJV98X8KPzyuDoGR91TqrCvRqWORseRvyAxNs4lZj72RITRTgeV1Kg/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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;">微X</span>：603830039领取练习课件</span></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><img src="https://mmbiz.qpic.cn/mmbiz/z9433rAGTDd78cwaDvzakb7575ic82NHaKASbJ2j330Auic2Ft9xA6W1fIhzeWib47ju2MNkhofiaumYKD9YltcqTQ/640?tp=webp&wxfrom=5&wx_lazy=1&wx_co=1" style="width: 50%; margin-bottom: 20px;"></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 style="color: black;">举荐</span>：</span></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 style="color: black;">此刻</span>慌得一比”【Excel教程】</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;">“帮我把这1000行数据每7行一页打印出来，3分钟内我就要！”【Excel教程】</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;">职场人最大的底气，不是钱，而是精通excel动态图表！</span></a></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;"><strong style="color: blue;"><span style="color: black;"><span style="color: black;">倘若</span>你觉得<span style="color: black;">文案</span>不错，欢迎点赞分享到<span style="color: black;">伴侣</span>圈</span></strong></span></p>
我完全同意你的观点，说得太对了。 seo常来的论坛，希望我的网站快点收录。
页:
[1]