excel表格填入身份证最后四位变成0怎么处理?
选中单元格,右键->设置单元格格式->数字->文本即可。(With Xikai Xu's help.)

excel中怎样制作下拉菜单 http://jingyan.baidu.com/article/3a2f7c2e554d6926aed61167.html?qq-pf-to=pcqq.c2c
Excel设置可多选下拉菜单
http://wenku.baidu.com/link?url=ARHr9DKQWJSLS2iBsEKGPJNNhRcyNgr6ojqPj8v7vLpZwmy9_rX5XDYrOBXw-uAn7OkVLFZW4DKZRw8j68PcNAglR-UvPP2P9Z8T89mqWIa&qq-pf-to=pcqq.c2c