怎么样在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 style="color: black;">咱们</span>在制作Excel表格时有时需要制作下拉菜单，<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 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;">详细</span><span style="color: black;">办法</span></span></strong></p>
<p style="font-size: 16px; color: black; line-height: 40px; text-align: left; margin-bottom: 15px;"><span style="color: black;">1、<span style="color: black;">首要</span>打开表格，<span style="color: black;">咱们</span>以制作省份下拉菜单为例，先在下面制作一个<span style="color: black;">仅有</span>省份下拉菜单的表格，如下图所示</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/4180b2d8e4e44061adc284d1395ddfac~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982470&x-signature=j8%2BeLnTkUskxk0JvwBAfUB1Dvco%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;">2、选中“省份”下方的空单元格，<span style="color: black;">而后</span>点击【数据】-再点击【有效性】，如下图所示</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/61397d8ce04c4f649ee07a1b4a5498d4~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982470&x-signature=6%2B4hvWNfJgZHBk7RVgq1lHAQ1N0%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;">3、在弹出的“数据有效性”对话框中，“有效性<span style="color: black;">要求</span>”<span style="color: black;">准许</span>选中：序列，<span style="color: black;">源自</span>选中“省市对照表”中的省份名<span style="color: black;">叫作</span>这一行数据，最后点击确认，如下图所示</span></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/9eef89eda89c4cc7a50906529d9d22ba~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982470&x-signature=cgYco%2FPpMlywiaJiRecG3wppKFY%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/b6f0da4a4ba246538d090d6aa564272f~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982470&x-signature=pqGYbmO7V5VlmxOfBD4E9DnztEM%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;">4、<span style="color: black;">这般</span>省份一级下拉菜单就完成制作了，如下图，</span><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></p>
<div style="color: black; text-align: left; margin-bottom: 10px;"><img src="https://p3-sign.toutiaoimg.com/tos-cn-i-qvj2lq49k0/994aceafe98848c2b3fd0240b160c0e7~noop.image?_iz=58558&from=article.pc_detail&lk3s=953192f4&x-expires=1727982470&x-signature=GVCWsafpeTT7iVXwwACIteuWdHE%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;">在Excel表格中快速制作一级下拉菜单你学会了吗？是不是超简单，简单几步就<span style="color: black;">能够</span><span style="color: black;">容易</span>实现。</span><strong style="color: blue;"><span style="color: black;">明天笔者继续给<span style="color: black;">大众</span>分享<span style="color: black;">怎样</span>在Excel表格中快速制作二级下拉菜单和三级下拉菜单。</span></strong></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>
论坛的成果是显著的，但我们不能因为成绩而沾沾自喜。
页:
[1]