如何在下拉列中添加下拉选项，此方法适用于excel 07以上版本。
方法一：
![](https://wkrtcs.bdimg.com/rtcs/image?w=573.46666666667&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"573.46666666667","h":"297.73333333333","dataType":"png","c":"word/media/image1.png","imgOriW":923,"imgOriH":513})
![](https://wkrtcs.bdimg.com/rtcs/image?w=69.333333333333&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"69.333333333333","h":"20","dataType":"gif","c":"word/media/image2.png"})
步奏1.在界面选择—数据—数据有效性，弹出如下图对话框
![](https://wkrtcs.bdimg.com/rtcs/image?w=348&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"348","h":"254","dataType":"png","c":"word/media/image3.png","imgOriW":404,"imgOriH":295})
步奏2，在允许选项中选择序列，在来源中选择![](https://wkrtcs.bdimg.com/rtcs/image?w=38&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"38","h":"33","dataType":"png","c":"word/media/image4.png","imgOriW":38,"imgOriH":33})
，显示如下
![](https://wkrtcs.bdimg.com/rtcs/image?w=408&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"408","h":"56","dataType":"png","c":"word/media/image5.png","imgOriW":408,"imgOriH":56})
步奏3，在空白单元格输入“大” “小”
![](https://wkrtcs.bdimg.com/rtcs/image?w=95&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"95","h":"58","dataType":"png","c":"word/media/image6.png","imgOriW":95,"imgOriH":58})
步奏4，使用鼠标拖动选择“大” “小”及“大”的上个单元格，如下图所示，然后关闭
![](https://wkrtcs.bdimg.com/rtcs/image?w=53.333333333333&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"53.333333333333","h":"38.666666666667","dataType":"gif","c":"word/media/image7.png"})
返回到下面界面
![](https://wkrtcs.bdimg.com/rtcs/image?w=527&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"527","h":"319","dataType":"png","c":"word/media/image9.png","imgOriW":532,"imgOriH":319})
![](https://wkrtcs.bdimg.com/rtcs/image?w=142&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"142","h":"78","dataType":"png","c":"word/media/image10.png","imgOriW":179,"imgOriH":229})
步奏5，点击确认即可完成操作。
方法二：
步奏3，在空白处，输入“大”“小”中间用英文书写的“,”逗号隔开，然后点确定即可![](https://wkrtcs.bdimg.com/rtcs/image?w=389&md5sum=b87c8154b39a6b825f80048fd52c1817&sign=c5de6e3955&rtcs_flag=1&rtcs_ver=3.6&l=webapp&bucketNum=51&ipr={"t":"img","w":"389","h":"135.06666666667","dataType":"png","c":"word/media/image11.png","imgOriW":401,"imgOriH":148})
本文来源：https://www.2haoxitong.net/k/doc/301bb564fad6195f302ba663.html
文档为doc格式