EXCEL表格十秒搞定的小技巧 学会它你亦是能手
<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>这个技巧只要10秒钟就能搞定哦。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/1ca97cbe84b14f1498431bef061cb01a~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983577&x-signature=yTba72T5DlWUPjsNMsC9Lll9SNU%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/a5a8bcc2746e4fe79f86d349db219012~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983577&x-signature=By%2BIMxzjqaDx%2BJg8SzqO33l3KoE%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><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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/467a708939e3418fa04419f9b1f9602b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983577&x-signature=8xaIM8EZR0lZRjyz6ysz2V1CdfI%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>点击数据菜单栏上的分列。再点击下一步，</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/261b7390b94949ae9dca99c3c8f0bd52~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983577&x-signature=LQgaONr89bOaT%2FutxszQa%2BJLwzo%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/52e1c2e52f064c02b6d64a47468cf1e4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983577&x-signature=cP%2BB6ev4f4s8eEP5g7jIiPZF3a0%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>点击分割符号，<span style="color: black;">选取</span>其他，在<span style="color: black;">这儿</span>面输入<span style="color: black;">咱们</span>的分割号逗号，再点击下一步完成。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/ee9d943d81fc4c30948fafdee1c46142~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983577&x-signature=OVl%2F2dPP1AQlB6MN5WOZcPPBwAE%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>按住CTRL+shift加右键头就<span style="color: black;">能够</span>选上所有的名字了。接下来<span style="color: black;">咱们</span>再按住CTRL+C复制，这个时候呢，在粘贴<span style="color: black;">这儿</span><span style="color: black;">咱们</span>要<span style="color: black;">选取</span><span style="color: black;">选取</span>性的粘贴里面的转置。</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/265bc7205c3e46f8ab46d4a6f11feabe~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983577&x-signature=hcB2QO%2Fa5%2FBPfs1fkxD9EC5hmJc%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>就<span style="color: black;">能够</span>自动的给你粘贴好一列了，是不是很简单，<span style="color: black;">伴侣</span>们，动手试一试吧。学会它你<span style="color: black;">亦</span>是<span style="color: black;">能手</span>哦</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/9e72080fe9ef49f1bedb770ee9cd33d0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727983577&x-signature=iRVN1DnppY%2FEu1TpFTFoETbRUpE%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>的分享就到<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;"><a style="color: black;">#办公软件#</a><a style="color: black;">#职场#</a><a style="color: black;">#今日头条日签#</a><a style="color: black;">#EXCEL<span style="color: black;">教育</span>#</a><a style="color: black;">#表格技巧#</a></p>
“NB”（牛×的缩写，表示叹为观止）
页:
[1]