Excel技巧， 一级，二级联动下拉菜单，1分钟学会！
<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>方便快速录入数据，效果如下所示</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-axegupay5k/610744dc7f254f1a825e6fa3ed9f1d0b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=MRnu3xbzKV0ci34ZgfRnYwr6UGM%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">今天分享一级，二级联动下拉菜单制作小技巧</p>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">1、一级下拉菜单</h1>
<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;">数据-数据验证</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>序列</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>手动的输入，用英文状态下的逗号隔开</p>
<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/62bb14ae56f344c7a5e376ecf7b1dedf~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=x4mTnmzWaKJdFbMuovhHyiWobUY%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>数据了</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/36330e581bb64dcb800d5ee668a5a42f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=c7uvoPYL7kqHbYbIGtFwCU1DxwE%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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/6b33d419b0a449febfa8c59db1fa8f27~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=trLdJqX4kECPLk%2FBBocOvpjBRKo%3D" style="width: 50%; margin-bottom: 20px;"></div>
<h1 style="color: black; text-align: left; margin-bottom: 10px;">2、制作二级联动下拉菜单</h1>
<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/377d4b27e43d47e89aba3d3c8b302ce2~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=cNlE4sToGzfoTmzVcYqmBj%2BSYr8%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>
<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;">第1</span>行是标题，下面的数据分别是标题的子数据</p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/8e83ae6a051d4fc791e1255e85fa5012~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=I9KDELLuj9WJqIGhWNiavbPq1y4%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+G，定位<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-6w9my0ksvp/063bf349b96a44a7997de81c7895dbc6~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=btWeHXlkgtAdpUDZ40TFVjEVt24%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>A1:D1的数据区域，就<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/5f373e07055741669579659992541a57~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=5fiG3H1N0r%2FsGOMi0wl3BEdmEcU%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>选中G列，数据验证，<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;">=INDIRECT(F1)</p>
<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/8ee3a830058f465b95e6fee80e4c09ec~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=iLyLDOEnv9fRg5qH1Iark7iNRm0%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>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-6w9my0ksvp/96e6a01afea74c79873a8886434adc3b~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982455&x-signature=YMg%2Bv%2BBVbWdU9s17WCP2J8JAXfw%3D" style="width: 50%; margin-bottom: 20px;"></div>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">关于这个小技巧，你学会了么？动手试试吧！</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">源自</span>：Excel自学成才</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;">编辑：王娜</p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">责任编辑：网友投稿</span>牛栋</p>
页:
[1]