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 list

How to Create a Drop-Down List in Excel in 60 Seconds (or less)

文章推薦指數： 80 %
投票人數：10人

How to Create a Drop-Down List in Excel: Introducing the “1 Minute Drop–Down“ · Step 1: Go to the “Data” tab · Step 2: Click “Data Validation”. SkiptocontentThe1MinuteDrop-Down:HowtoCreateaDrop-DownListinExcelin60Seconds(orless!)HowtoCreateaDrop-DownListinExcel:Introducingthe“1Minute Drop–Down“Writtenbyco-founderKasperLangmann,MicrosoftOfficeSpecialist.Thedrop-downlistisagreatwaytoseemlikeasuperuserandimpressyourco-workersandboss🙂Atthesametime,it’saveryuser-friendlyassetinalmostallcustom-madeExcelsheets.Inthistutorial,I’mgoingtoshowyou:The5stepstocreateadrop-downlistinExcel–in1minuteorless.Icallitthe“1MinuteDrop-Down”.Intheanimationrightbelowyoucanseethedrop-downmenuinaction.Beholditsmightyglory!Adrop-downlistisactuallyatinywindowfromwhereyoucanpeekintosomeotherdatayouhaveconstructed.Thisalsogivesyouthepossibilityofcontrollingexactlywhatcanbeenteredintoacell.Thismakesthedrop-downmenuaverycommonandpowerfuldatavalidationtool.Luckily,creatingadrop-downmenuissuper easyifyouknowtheexactsteps.Inafewseconds,I’mgoingtoshowyoutheexactstepstocreateyourveryowndrop-down.*ThistutorialisforExcel2019/Microsoft365(forWindows).Gotadifferentversion?Noproblem,youcanstillfollowtheexactsamesteps.Followalongbydownloadingoursamplefilerightbelow!cloud-downloadBONUS: Downloadthe DropDownExcelWorkbookSampleFile(with2pre-loadedexercises)togoalongwiththispost.Beforewestarttheclock,let’stakealookatthedatainthesamplefile.Firstwehaveasheetwithallthenamesofouremployees.Thisisthedatawewouldliketoseewhenopeningourdrop-downmenu.Thenwehavethe“gateway”wherewewanttobeabletoscrollthroughallthenamesontheothersheet.This“gateway”isplacedinthe“Dropdown”sheetoftheExcelsamplefile.We’llputourdrop-downmenuincellB1.Step1:Gotothe“Data”tabThisstepiseasy!Simplymoveyourcursortothe“Data”tabandclickit.Step2:Click“DataValidation”Nowclickthebutton“Datavalidation”inthemiddleoftheribbon(donotclickthelittlearrow–simplyclickthetoppartofthebutton).Step3:Choosethe“List”Inthedatavalidationdialogbox,youneedtoclickthedrop-downmenutopickwhatkindofdatavalidationmethodyouwanttouse(howmetaisthat?!).Clickthearrownexttothefieldandclick“List”fromthe…well…list!Thenclick“OK”tomoveontothenextstep.Step4:SelectthesourceRememberthedatasheet?That’swhereI’veputalltheemployeesforourdrop-downlist.Nowit’stimetotellExcelthatourdrop-downshouldbeconnectedtothatdata.Clickonceinthe“Source:”field.Thenclickthe“Data”sheetandselectalltheemployees.Whenyou’redoneclick“OK”.Protip: Wanttospeedupthisprocessevenmore?There’saneatshortcut(morehere)youcanusetoselectalltheemployeenamesin(almost)aninstant.Whenselectingthecellsforthesource,selectthefirstnameyouencounter(incellA2)–thenholddownCtrl+Shiftandclickthedownarrowonyourkeyboard.You’venowselectedallthenamesinthesheetinjustafewseconds.Step5:Here’stheendresult!Andthat’sthe1MinuteDrop-Down!Beautifulisn’tit?Youhavenowcreatedadrop-downlistinExcelin60seconds(orhopefullyevenless!).Withsomepractice,youcanalmostcreatethesedrop-downsinstantly. I’vemanagedtocreateoneinamere15seconds.KasperLangmann2021-07-02T08:23:21+00:00Pageloadlink50%CompleteYes,sendmetheDropDown Excel WorkbookFile.Onelaststep:justletusknowwhereshouldweshouldsendit.SENDMETHEWORKBOOKx

請為這篇文章評分？

延伸文章資訊