How to make multiple choice in Excelexcel drop down list教學Excel drop down list multiple selectiondrop-down list htmlExcel drop-down list editCreate drop-down list in ExcelExcel drop-down list conditionalChoose multiple options in excelExcel multiple item selection setupMultiple choice ExcelExcel drop down list autocompleteExcel drop down list formulaExcel dependent drop down listAdd or remove items from a drop-down list - Microsoft Support
文章推薦指數： 80 %
Edit a drop-down list that's based on an Excel Table · To add an item, go to the end of the list and type the new item. · To remove an item, press Delete. Tip: If ... Skiptomaincontent Officesupport Products Microsoft365 Office Outlook MicrosoftTeams OneDrive OneNote Windows MicrosoftEdge more... Devices Surface PCaccessories Mobile Xbox HoloLens Hardwarewarranties What'snew InstallOffice Account&billing Account MicrosoftStore&billing Templates Moresupport Communityforums Microsoft365Admins SmallBusinessAdmins Developer Education Reportasupportscam Excel Enterandformatdata Datavalidation Datavalidation Addorremoveitemsfromadrop-downlist ExcelforMicrosoft365ExcelforMicrosoft365forMacExcelforthewebExcel2021Excel2021forMacExcel2019Excel2019forMacExcel2016Excel2016forMacExcel2013Excel2010Excel2007More...Less Afteryoucreateadrop-downlist,youmightwanttoaddmoreitemsordeleteitems.Inthisarticle,we'llshowyouhowtodothatdependingonhowthelistwascreated. WindowsmacOSWeb Editadrop-downlistthat'sbasedonanExcelTable IfyousetupyourlistsourceasanExceltable,thenallyouneedtodoisaddorremoveitemsfromthelist,andExcelwillautomaticallyupdateanyassociateddrop-downsforyou. Toaddanitem,gototheendofthelistandtypethenewitem. Toremoveanitem,pressDelete. Tip: Iftheitemyouwanttodeleteissomewhereinthemiddleofyourlist,right-clickitscell,clickDelete,andthenclickOKtoshiftthecellsup. Editadrop-downlistthat’sbasedonanamedrange Selecttheworksheetthathasthenamedrangeforyourdrop-downlist. Doanyofthefollowing: Toaddanitem,gototheendofthelistandtypethenewitem. Toremoveanitem,pressDelete. Tip: Iftheitemyouwanttodeleteissomewhereinthemiddleofyourlist,right-clickitscell,clickDelete,andthenclickOKtoshiftthecellsup. GotoFormulas>NameManager. IntheNameManagerbox,clickthenamedrangeyouwanttoupdate. ClickintheReferstobox,andthenonyourworksheetselectallofthecellsthatcontaintheentriesforyourdrop-downlist. ClickClose,andthenclickYestosaveyourchanges. Tip: Ifyoudon'tknowwhatanamedrangeisnamed,youcanselecttherangeandlookforitsnameintheNameBox.Tolocateanamedrange,seeFindnamedranges. Editadrop-downlistthat’sbasedonarangeofcells Selecttheworksheetthathasthedataforyourdrop-downlist. Doanyofthefollowing: Toaddanitem,gototheendofthelistandtypethenewitem. Toremoveanitem,clickDelete. Tip: Iftheitemyouwanttodeleteissomewhereinthemiddleofyourlist,right-clickitscell,clickDelete,andthenclickOKtoshiftthecellsup. Ontheworksheetwhereyouappliedthedrop-downlist,selectacellthathasthedrop-downlist. GotoData>DataValidation. OntheSettingstab,clickintheSourcebox,andthenontheworksheetthathastheentriesforyourdrop-downlist,selectallofthecellscontainingthoseentries.You'llseethelistrangeintheSourceboxchangeasyouselect. Toupdateallcellsthathavethesamedrop-downlistapplied,checktheApplythesechangestoallothercellswiththesamesettingsbox. Editadrop-downlistwithitemsthathavebeenenteredmanually Ontheworksheetwhereyouappliedthedrop-downlist,selectacellthathasthedrop-downlist. GotoData>DataValidation. OntheSettingstab,clickintheSourcebox,andthenchangeyourlistitemsasneeded.Eachitemshouldbeseparatedbyacomma,withnospacesinbetweenlikethis:Yes,No,Maybe. Toupdateallcellsthathavethesamedrop-downlistapplied,checktheApplythesechangestoallothercellswiththesamesettingsbox. Workingwithyourdrop-downlist Afteryouupdateadrop-downlist,makesureitworksthewayyouwant.Forexample,checktoseeifthecelliswideenoughtoshowyourupdatedentries. Ifthelistofentriesforyourdrop-downlistisonanotherworksheetandyouwanttopreventusersfromseeingitormakingchanges,considerhidingandprotectingthatworksheet.Formoreinformationabouthowtoprotectaworksheet,seeLockcellstoprotectthem. Ifyouwanttodeleteyourdrop-downlist,seeRemoveadrop-downlist. Toseeavideoabouthowtoworkwithdrop-downlists,seeCreateandmanagedrop-downlists. Editadrop-downlistthat'sbasedonanExcelTable IfyousetupyourlistsourceasanExceltable,thenallyouneedtodoisaddorremoveitemsfromthelist,andExcelwillautomaticallyupdateanyassociateddrop-downsforyou. Toaddanitem,gototheendofthelistandtypethenewitem. Toremoveanitem,pressDelete. Tip: Iftheitemyouwanttodeleteissomewhereinthemiddleofyourlist,right-clickitscell,clickDelete,andthenclickOKtoshiftthecellsup. Editadrop-downlistthat’sbasedonanamedrange Selecttheworksheetthathasthenamedrangeforyourdrop-downlist. Doanyofthefollowing: Toaddanitem,gototheendofthelistandtypethenewitem. Toremoveanitem,pressDelete. Tip: Iftheitemyouwanttodeleteissomewhereinthemiddleofyourlist,right-clickitscell,clickDelete,andthenclickOKtoshiftthecellsup. GotoFormulas>NameManager. IntheNameManagerbox,clickthenamedrangeyouwanttoupdate. ClickintheReferstobox,andthenonyourworksheetselectallofthecellsthatcontaintheentriesforyourdrop-downlist. ClickClose,andthenclickYestosaveyourchanges. Tip: Ifyoudon'tknowwhatanamedrangeisnamed,youcanselecttherangeandlookforitsnameintheNameBox.Tolocateanamedrange,seeFindnamedranges. Editadrop-downlistthat’sbasedonarangeofcells Selecttheworksheetthathasthedataforyourdrop-downlist. Doanyofthefollowing: Toaddanitem,gototheendofthelistandtypethenewitem. Toremoveanitem,clickDelete. Tip: Iftheitemyouwanttodeleteissomewhereinthemiddleofyourlist,right-clickitscell,clickDelete,andthenclickOKtoshiftthecellsup. Ontheworksheetwhereyouappliedthedrop-downlist,selectacellthathasthedrop-downlist. GotoData>DataValidation. OntheSettingstab,clickintheSourcebox,andthenontheworksheetthathastheentriesforyourdrop-downlist,SelectcellcontentsinExcelcontainingthoseentries.You'llseethelistrangeintheSourceboxchangeasyouselect. Toupdateallcellsthathavethesamedrop-downlistapplied,checktheApplythesechangestoallothercellswiththesamesettingsbox. Editadrop-downlistwithitemsthathavebeenenteredmanually Ontheworksheetwhereyouappliedthedrop-downlist,selectacellthathasthedrop-downlist. GotoData>DataValidation. OntheSettingstab,clickintheSourcebox,andthenchangeyourlistitemsasneeded.Eachitemshouldbeseparatedbyacomma,withnospacesinbetweenlikethis:Yes,No,Maybe. Toupdateallcellsthathavethesamedrop-downlistapplied,checktheApplythesechangestoallothercellswiththesamesettingsbox. Workingwithyourdrop-downlist Afteryouupdateadrop-downlist,makesureitworksthewayyouwant.Forexample,checktoseehowto Changethecolumnwidthandrowheighttoshowyourupdatedentries. Ifthelistofentriesforyourdrop-downlistisonanotherworksheetandyouwanttopreventusersfromseeingitormakingchanges,considerhidingandprotectingthatworksheet.Formoreinformationabouthowtoprotectaworksheet,seeLockcellstoprotectthem. Ifyouwanttodeleteyourdrop-downlist,seeRemoveadrop-downlist. Toseeavideoabouthowtoworkwithdrop-downlists,seeCreateandmanagedrop-downlists. InExcelfortheweb,youcanonlyeditadrop-downlistwherethesourcedatahasbeenenteredmanually. Selectthecellsthathavethedrop-downlist. GotoData>DataValidation. OntheSettingstab,clickintheSourcebox.Thendooneofthefollowing: IftheSourceboxcontainsdrop-downentriesseparatedbycommas,thentypenewentriesorremoveonesyoudon'tneed.Whenyou'redone,eachentryshouldbeseparatedbyacomma,withnospaces.Forexample:Fruits,Vegetables,Meat,Deli. IftheSourceboxcontainsareferencetoarangeofcells(forexample,=$A$2:$A$5),clickCancel,andthenaddorremoveentriesfromthosecells.Inthisexample,you'daddorremoveentriesincellsA2throughA5.Ifthelistofentriesendsupbeinglongerorshorterthantheoriginalrange,gobacktotheSettingstabanddeletewhat'sintheSourcebox.Thenclickanddragtoselectthenewrangecontainingtheentries. IftheSourceboxcontainsanamedrange,likeDepartments,thenyouneedtochangetherangeitselfusingadesktopversionofExcel. Afteryouupdateadrop-downlist,makesureitworksthewayyouwant.Forexample,checktoseeifthecelliswideenoughtoshowyourupdatedentries.Ifyouwanttodeleteyourdrop-downlist,seeRemoveadrop-downlist. Needmorehelp? YoucanalwaysaskanexpertintheExcelTechCommunity orgetsupportintheAnswerscommunity. SeeAlso Createadrop-downlist ApplyDataValidationtocells Video:Createandmanagedrop-downlists Needmorehelp? Expandyourskills ExploreTraining Getnewfeaturesfirst JoinMicrosoftInsiders Wasthisinformationhelpful? Yes No Thankyou!Anymorefeedback?(Themoreyoutellusthemorewecanhelp.) Canyouhelpusimprove?(Themoreyoutellusthemorewecanhelp.) Whataffectedyourexperience? Resolvedmyissue Clearinstructions Easytofollow Nojargon Pictureshelped Other Didn'tmatchmyscreen Incorrectinstructions Tootechnical Notenoughinformation Notenoughpictures Other Anyadditionalfeedback?(Optional) Submitfeedback Thankyouforyourfeedback! ×
延伸文章資訊
- 1Create Drop-down Lists in Excel (In Easy Steps)
Drop-down List · 1. To add an item to a drop-down list, go to the items and select an item. Selec...
- 2How to Create a Drop-Down List in Excel in 60 Seconds (or less)
How to Create a Drop-Down List in Excel: Introducing the “1 Minute Drop–Down“ · Step 1: Go to the...
- 3How to Create a Drop Down List in Excel (the Only Guide You ...
Select a cell where you want to create the drop down list. · Go to Data –> Data Tools –> Data Val...
- 4How to Create Drop Down Lists in Cells - The Complete Excel ...
The drop down lists allow the user to select from a drop-down menu of items and input the value i...
- 5How to add a drop-down list in Microsoft Excel - YouTube
You can help people work more efficiently in worksheets by using drop-down lists in cells within ...
