北京快3

当前位置:主页 > Excel教程 > Excel技巧大全 >

(1级,2级,3级,多级)Excel下拉菜单怎么做的?轻松搞定表格选项!

Excel下拉菜单怎么做的

对于一些录入数据的朋友来说,制定一个下拉菜单将重复的内容输入进去,后面只需要选择选项即可代替手动输入,这样可以很好的避免录入错误的现象,也可以为我们节省不少时间。之前,易老师有讲过制作Excel的下拉菜单的方法,不过今天讲的要比之前稍复杂一点,制作1级、2级和多级的下拉菜单方法。

1级下拉菜单制作

首先,在Excel北京快3中选中需要添加下拉菜单的所有单元格,然后【数据】-【数据工具】-【数据验证】,在【允许】中设为【序列】,选择来源,然后选择需要添加菜单中的数据所在单元格,确定即可搞定。

1级Excel下拉菜单怎么做的

 

2级下拉菜单制作

ZAI【sheet1】ZHONGSHIXUYAOSHEZHIXIALACAIDANDEGONGZUOBIAO,ZAI【sheet2】ZHONGSHIXUYAOTIANJIADAOCAIDANZHONGDESHENG/SHIXINXI。XUANZHONG【sheet2】ZHONGSUOYOUBAOHANXINXIDEDANYUANGE(JIZHU,BUYAOXUANZEKONGBAIDANYUANGEE!BURAN,YEHUIBEITIANJIAJINRUCAIDANZHONGDE。)。XUANHAOHOUXUANZE【GONGSHI】-【DINGYIDEMINGCHENG】-【GENJUSUOXUANNEIRONGCHUANGJIAN】,ZHIGOUXUAN【SHOUXING】,RANHOUQUEDING。JIEXIALAIJIUDEBUZHOUYU1JIXIALACAIDANYIYANG,XUYAOJINRU【SHUJUYANZHENG】XUANZE【sheet2】ZHONGDEYIJICAIDANNEIRONG。ZAIB2DANYUANGEZHONGSHEZHIXIANGTONG,ZHISHIZAI【LAIYUAN】ZHONGXUYAOSHURU【=INDIRECT(A2)】,ZUIHOUXIALAJIANGGANGCAISHEZHIHAODEGESHITIANCHONGDAOXIAMIANDANYUANGEJIKE。

2级Excel下拉菜单怎么做的

 

3级或多级下拉菜单制作

ZHEILIWOJIANGXINXIFENBIEXIEDAOLE3GEGONGZUOBUZHONGQIANMIANYIGESHIZHUBIAOGEHOUMIANFENBIESHI【SHENGSHIQU】HOUMIANSHI【SHIQUJIEDAO】,ZHEISHIWEILEGENGHAODEJIANGXINXIFENLEIPAIXUHAO,DANGRAN,NIYEKEYIJIANGXINXIQUANBUJILUZAIDIERGEGONGZUOBUZHONG,FANGFAYUSHANGMIANDOUSHILEISIDE,DAJIAKANWOYANSHIJIUHAOLE。JIZHUERJISHI【=INDIRECT(A2)】,SANJISHI【=INDIRECT(B2)】。

3级Excel下拉菜单怎么做的

北京快3 XUEHUIYONGYISHANGDEFANGFAHOU,XIANGXINRIHOUZAIExcelZHONGWULUNSHIDUOSHAOJIDEXIALACAIDANNIDOUHUIZUOLE!

  • 关注微信关注微信

猜你喜欢

最新评论:12条

  • xiaoxiaosenlin 2020-06-11 11:28:00

    BUCUOBUCUO

  • 静静 2020-03-26 15:15:09

    北京快3WOYESHUOLIANGJU,ZHENXINHAO,JUEDETAIQIANGDALE。

  • 赤血 2020-03-06 14:05:03

    北京快3YAOZUOSIJINI NEIHANSHUYINGGAIXIESHENME

  • 三饼拉 2019-06-19 16:17:10

    北京快3GOOD,TAIBANGLE!ZHAOLEHAOJIU,ZHONGYUZHAODAOLE。MUQIANZHIHUIZUOYIJIXIALACAIDAN!HUIQUXUEZHECAOZUOXIA!

  • 嘻嘻嘻 2019-04-26 16:33:42

    北京快3DONGZUOZHEIMEKUAI,NENGFANYINGGUOLAIMA?

  • 学习呀 2018-12-01 21:08:54

    DAOSHIKEYIZHAOZUOCHULAI,JIUSHIINDIRECTHANSHUBUHAOLIJIE

  • 嗡嗡嗡 2018-08-15 16:56:32

    XUXINXUEXI!!!

  • 菠萝梨 2018-04-09 18:01:48

    WASAI,TAIXIANGXILE,MEIJIANGUOZHEIMEHAODEDONGTAIJIAOCHENG。WOBENLAIDOUBUHUINONG,ANZHAOJIAOCHENGYIBUYIBUDECAOZUOZHIZUOCHULAILEEXCELXIALACAIDAN,GANJUEZHENDEHENYOUCHENGJIUGAN,HAHA,WOYESHIGAOSHOULE!ZAICIGANXIE,WOHUIJINGCHANGLAIXUEXIDE

  • zhengzhizhe1991 2018-01-08 08:55:53

    FEICHANGYOUYONGDEJIAOXUE

  • 赖芝汛 2017-12-02 15:31:47

    DAJIAHAOWOSHILAIZHIXUN

发表评论

看不清?点击更换

微信公众号

微信公众号
var _hmt = _hmt || []; (function() { var hm = document.createElement("script"); hm.src = "https://hm.baidu.com/hm.js?be055eb5acfdc25d3bd72279b8418725"; var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(hm, s); })();