1分钟,创建103个指定名叫作的工作表
<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 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-qvj2lq49k0/4e0a4174537943d28a5e1179e59ab29e~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727987946&x-signature=U7sNJa%2F2CaXa9EjTv05ulZGoQN8%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></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/6ed46cf9c698459990e9bb726c784ee7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727987946&x-signature=qeeLJNrViRuRF0UTpCpN4GcUrpo%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>的操作<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;">过程</span>1</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 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-qvj2lq49k0/9f09ea61febf4c938b8d6124f26b25ab~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727987946&x-signature=vA8GpZL74qaE4UnYemWrMWKwwOQ%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 style="color: black;">过程</span>2</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></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键单击标签滚动调节按钮。</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;">再按住Shift键不放单击最左侧的司机名<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;">单击A1单元格,按回车。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/2fe4937188604ea193b38fbb278f23ed~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727987946&x-signature=lT%2BL3cUvnBn4XqRJIMX8yS3S6Vo%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 style="color: black;">过程</span>3</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;">在任意工作表标签上单击鼠标右键,取消组合工作表,OK了。</span></span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/743f445a75394579911c7f783e297c7a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727987946&x-signature=RXiyPJHkPpNayoAJLjHRs3BNQkQ%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></span></p>
外贸网站建设方法 http://www.fok120.com/ “NB”(牛×的缩写,表示叹为观止) 请问、你好、求解、谁知道等。
页:
[1]