excel表格填入身份證最后四位變成0怎么處理?
選中單元格，右鍵->設置單元格格式->數(shù)字->文本即可。(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