如何生成表格数据有效性（下拉菜单）？
<p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">方法一：</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">使用</span>WPS Office<span style="font-family:微软雅黑">打开表格，选中需要设置的单元格。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">依次点击</span>“数据”---<span style="font-family:Times New Roman">></span><span style="font-family:微软雅黑">“有效性”。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">在弹出框中选择“设置”。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">在</span>“有效性条件”中根据需要进行选择，如“序列”。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">在</span>“来源”中输入内容，或选择来源的区域。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">（注意：输入内容的需要用英文逗号隔开）</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">完成上述操作后，即可在选中的单元格生成下拉菜单。</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style=";font-family:微软雅黑;font-size:16px"> </span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style=";font-family:微软雅黑;font-size:16px"><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/90ff898f90f7fbbf90edb69f181f7bfc.gif" title="录制_2020_01_20_20_51_12_203.gif" alt="录制_2020_01_20_20_51_12_203.gif"></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style=";font-family:微软雅黑;font-size:16px"><br></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style="font-family: 微软雅黑;font-size: 16px"><span style="font-family:微软雅黑">方法二：</span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑"><br></span></span></p><p style="text-align:justify;text-justify:inter-ideograph"><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">选中需要操作的单元格，依次点击</span>“数据”---<span style="font-family:Times New Roman">></span><span style="font-family:微软雅黑">“插入下拉列表”。</span></span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">勾选</span>“手动添加下拉选项”。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">根据需要进行</span>“添加”、“删除”、调整选项位置、“修改”等操作。</span></p><p><span style=";font-family:微软雅黑;font-size:16px"><span style="font-family:微软雅黑">点击</span>“确定”即可生成下拉菜单。</span></p><p><br></p><p><img src="https://res1.wpsacdm.cache.wpscdn.cn/images/6799cdd87a7d37b0f4e33653096f9aef.gif" title="录制_2020_01_20_20_52_05_268.gif" alt="录制_2020_01_20_20_52_05_268.gif"></p><p><br></p>
頁:
[1]