手把手教你制作一个简单的Excel表格，初入职场必须技能
<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;"><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>时候都需要用到，今天就手把手教你制作一个简单的Excel表格，初入职场<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>制作的表格是<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-axegupay5k/723acfc0037d4fffa8c261b17e55f583~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=jxCzGkiDum1oOVXSlGWWQtutv%2Bs%3D" style="width: 50%; margin-bottom: 20px;">
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">手把手教你制作一个简单的Excel表格，初入职场<span style="color: black;">必须</span>技能！</p>
</div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">1、<span style="color: black;">首要</span><span style="color: black;">咱们</span>新建一个Excel表格，输入以下数据，效果如下图</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/5fb36566d94645c38203580ce93401e1~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=%2BzPs1PDqUEod5Com5OOH1iWfNdw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">2、<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-qvj2lq49k0/ae7e5c3da64c46c5b35d716ba52eb242~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=5Y41tq5H9Nvuur0HlZtX5yyxteU%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-qvj2lq49k0/4e42630bfa514d21b86f39cd961ebc15~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=y8IDYSfaeqgtDTVQ4VHyuklZNAs%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-qvj2lq49k0/0af84b34eace4b4db3ba2408731fbb70~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=ZoxzL1hgIgK6xFyrdD68U8DC3os%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">3、<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-qvj2lq49k0/7cb911574bd342ebb74021978b235fc0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=mkCM2p%2FyqPqxHrxoig8LwxJ1a5o%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">4、分别合并“工号”，“名<span style="color: black;">叫作</span>”，“实发工资”上下单元格，分别合并“工资”，“扣除”<span style="color: black;">上下</span>单元格，在合并单元格时<span style="color: black;">能够</span><span style="color: black;">选取</span>要合并的单元格用快捷键Ctrl+M，<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-qvj2lq49k0/2e6667a8ef5a4cfb87d1c8fe21f5dc7b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=JJ4Ur6cv45S%2FyQHWMP79xhvvSfc%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-qvj2lq49k0/c22e91d5e7a149f5b694e6d5d4184e83~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=CP3l1JBDtOKPiwuARznWpWgoKHM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">5、<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-qvj2lq49k0/12c6a832a2ae4a4ca3ed8b1398e66cf2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=vWw6RJ5XWBBrWYm%2FG15svllRc4Q%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-qvj2lq49k0/b8d3a4701e4c4020bd4aa91e9ded197d~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=PLtGt4JUGq19%2BeIm5m2wPVkLwsg%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">6、为表头添加背景色</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/5d0ef5ff7b96487cbe1247c0c9fdf9ce~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=15juZdg%2B%2BZv38DjKIi5y5IR61S0%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-qvj2lq49k0/5b5cda1e125744968a3293f4b1a10ce0~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=QSMFDE%2FfpHslelYhKDE7v%2Bq4kF4%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">7、为表格添加边框，<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-qvj2lq49k0/ce112bc779594e239716a946936ddd61~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=bEaNTY718%2BdWG0Z%2Fp5V7YMIityk%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-qvj2lq49k0/b7c8470985754c5aa63ab439f5a97a91~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727964052&x-signature=DfrHalKy8%2F9AgRqYOcT%2FOTEf2HA%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>有什么问题欢迎留言关注！</p>
论坛的成功是建立在我们诚恳、务实、高效、创新和团结合作基础上，我们要把这种精神传递下去。 我深受你的启发，你的话语是我前进的动力。 seo常来的论坛，希望我的网站快点收录。
页:
[1]