Excel数据有效性
1．打开excel文件，自制表格内容如下：
![](https://wkrtcs.bdimg.com/rtcs/image?w=525&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"525","h":"248","dataType":"jpeg","c":"word/media/image1.png","imgOriW":525,"imgOriH":248})
2．将有选项的题的答案选项分别列在各题下方，稍加美化以示区别（加色条隔断）：
![](https://wkrtcs.bdimg.com/rtcs/image?w=536&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"536","h":"362","dataType":"jpeg","c":"word/media/image2.png","imgOriW":536,"imgOriH":362})
3．选中需要做选择的格子，选择 数据—有效性，打开有效性对话框：
![](https://wkrtcs.bdimg.com/rtcs/image?w=550&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"550","h":"439","dataType":"png","c":"word/media/image3.png","imgOriW":1280,"imgOriH":800})
![](https://wkrtcs.bdimg.com/rtcs/image?w=408&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"408","h":"319","dataType":"png","c":"word/media/image4.png","imgOriW":408,"imgOriH":319})
4．在有效性对话框中，在允许一栏选择“序列”：
![](https://wkrtcs.bdimg.com/rtcs/image?w=408&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"408","h":"319","dataType":"png","c":"word/media/image5.png","imgOriW":408,"imgOriH":319})
![](https://wkrtcs.bdimg.com/rtcs/image?w=408&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"408","h":"319","dataType":"png","c":"word/media/image6.png","imgOriW":408,"imgOriH":319})
5．点击![](https://wkrtcs.bdimg.com/rtcs/image?w=31&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"31","h":"20","dataType":"jpeg","c":"word/media/image7.png","imgOriW":31,"imgOriH":20})
以获取来源数据，选择该题的选项，按回车确定，点击确定，原来的格子即会在右下角有个黑色小三角。
![](https://wkrtcs.bdimg.com/rtcs/image?w=598&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"598","h":"382","dataType":"png","c":"word/media/image8.png","imgOriW":598,"imgOriH":382})
![](https://wkrtcs.bdimg.com/rtcs/image?w=408&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"408","h":"319","dataType":"png","c":"word/media/image9.png","imgOriW":408,"imgOriH":319})
![](https://wkrtcs.bdimg.com/rtcs/image?w=88&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"88","h":"52","dataType":"jpeg","c":"word/media/image10.png","imgOriW":88,"imgOriH":52})
6．将与该格有同样数据有效性的格子进行覆盖（复制粘贴即可，或拖动覆盖，拖动覆盖时鼠标移到黑格的右下角出现黑色十字即可点击左键拖动）。
![](https://wkrtcs.bdimg.com/rtcs/image?w=230&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"230","h":"62","dataType":"png","c":"word/media/image11.png","imgOriW":1280,"imgOriH":774})
![](https://wkrtcs.bdimg.com/rtcs/image?w=307&md5sum=163f2962611f38f65b6586370c105e6d&sign=fa060fa50c&rtcs_flag=1&rtcs_ver=3.2&l=webapp&bucketNum=29&ipr={"t":"img","w":"307","h":"334","dataType":"png","c":"word/media/image12.png","imgOriW":1280,"imgOriH":774})
本文来源：https://www.2haoxitong.net/k/doc/f4b19d64f5335a8102d220a5.html
文档为doc格式