全國知名互聯(lián)網(wǎng)會(huì)展平臺(tái),提供展會(huì)設(shè)計(jì)、展覽設(shè)計(jì)搭建、會(huì)展策劃、會(huì)展搭建等全方位解決方案!

Excel 客戶名稱怎樣設(shè)置可以選擇,不用手工輸入

提問者: 甄友亮|瀏覽 875 次|提問時(shí)間: 2015-01-01

已有 1 條回答

2015-01-01 最終答案
p>詳見樣表截圖用數(shù)據(jù)有效性設(shè)置下拉菜單“客戶名稱”在A1單元格A2設(shè)置下拉菜單點(diǎn)擊A2.hiphotos;允許>.com/zhidao/wh%3D450%2C600/sign=ba82593d79f082022dc7993b7ecbd7db/b2de9c82d158ccbf7b48082413d8bc3eb1354133;序列.jpg" esrc="/attachs/cj/img/201705/16190631882927.jpg" target="_blank" title="點(diǎn)擊查看大圖" class="ikqb_img_alink">確定后.com/zhidao/wh%3D600%2C800/sign=cd8c2a65db1373f0f56a6799943f67c3/6d81800a19d8bc3eadfab4d4888ba61ea8d34539.hiphotos.baidu.com/zhidao/wh%3D600%2C800/sign=18edca89d333c895a62b907de1235fc8/b2de9c82d158ccbf7b48082413d8bc3eb1354133,客戶3”(注意,OK://h.baidu://h。點(diǎn)開便可實(shí)現(xiàn)選擇性輸入:輸入半角逗點(diǎn).jpg" esrc="/attachs/cj/img/201705/16190631896364.jpg"ikqb_img" src="/attachs/cj/img/201705/16190632908062.jpg"http,“來源”輸入“客戶1,