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 listHow to add a drop down list to an Excel cell - TechRepublic
文章推薦指數： 80 %
RECOMMENDED FOR YOU · Create the data validation list in cells A1:A4. · Select cell E4. · Choose Data Validation from the Data ribbon menu. · Choose ... by SusanHarkins | JasonHiner in MicrosoftOffice , in Software onOctober5,2020,8:31AMPST Dropdownlistscangreatlyfacilitatedataentry.Here'salookathowtouseMicrosoftExcel'sdatavalidationfeaturetocreatehandylistswithinyourworksheets. Video:HowtoaddadropdownlisttoacellinMicrosoftExcel WatchNow AnExceldropdownlistordropdownmenucanmakeiteasierfortheaverageMicrosoftExcelusertoenterdataonaworksheetorworkbook.Usingadropdownmenuinwebforms,surveys,orpollscanlimittheentrychoicesforaselectedcell,speedingdataentryandreducingdataentryerror.InthisExceltip,we'llshowyouaquickandeasywaytocreateadropdownlistordropdownmenuusingthespreadsheetapplication'sDataValidationfeature.TocreateadropdownlistinExcel,youneedtwothings:Alistofvalues(containedwithinacellrange)andablankcelltouseasthedataentrycell.FigureAshowsasimpledropdownlistinanExcelsheet.Tousethedropdownmenushownhere,someonewouldplacethecursorovertheblank,data-entrycell(E4inthisexample)andclickadropdownarrowtodisplaythelistofvaluesshowninthecellrangeA1:A4.Ifausertriestoentersomethingthatisn'tanitemwithinthatlistofvalues,Excelrejectstheentry.YoucanfollowalongwiththestepsinthistipbycreatinganewsheetwithdatasimilartotheoneshowninFigureA,downloadingourdemonstration.xlsxand.xlsfiles,orusingyourownworksheetanddata. FigureAToaddthedropdownlistinourexampletoanExcelsheet,dothefollowing:CreatethedatavalidationlistincellsA1:A4.Similarly,youcanentertheitemsinasinglerow,suchasA1:D1.SelectcellE4.(Youcanpositionthedropdownlistinmostanycellorevenmultiplecells.)ChooseDataValidationfromtheDataribbonmenu.ChooseListfromtheAllowoption'sdropdownlist.(See,they'reeverywhere.)ClicktheSourcecontrolboxanddragthecursortohighlightthecellsA1:A4.Alternately,simplyenterthereference(=$A$1:$A$4).MakesuretheIn-celldropdownoptionischecked.Ifyouuncheckthisoption,Excelstillforcesuserstoenteronlylistvalues(A1:A4),butitwon'tpresentadropdownlist.ClickOK.SEE: Howtocreateadrop-downlistinGoogleSheets(TechRepublic)YoucanaddthedropdownlisttomultipleExcelcells.Selecttherangeofdatainputcells(step2)insteadofasingleExcelcell.ItevenworksfornoncontiguousExcelcells.HolddowntheShiftkeywhileyouclicktheappropriateExcelcells.Afewquicknotes:YoucanonlyseethedropdownboxifyouclickontheExcelcellusedfordataentry.Youruserscannowonlychooseoneoftheoptionsinthedropdown.Iftheytrytoentertheirowndata,thenthey'llreceiveanerrormessage.Youcancopy-and-pastethisdropdowncelltoanyotherExcelcellsinyourspreadsheet,andyoucancreateasmanydifferentdropdownslikethisasyou'dlike.SEE:10Exceltime-saversyoumightnotknowabout(freePDF)(TechRepublic) AMicrosoftExcelbonustipThisExceltipisfeaturedinthefreePDF 30thingsyoushouldneverdoinMicrosoftOffice.RelyonmultiplelinksLinksbetweentwoExcelworkbooksarecommonanduseful.Butmultiplelinkswherevaluesinworkbook1dependonvaluesinworkbook2,whichlinkstoworkbook3,andsoon,arehardtomanageandunstable.Usersforgettoclosefiles,andsometimestheyevenmovethem.Ifyou'retheonlypersonworkingwiththoselinkedExcelworkbooks,youmightnotrunintotrouble,butifotherusersarereviewingandmodifyingthem,you'reaskingfortrouble.Ifyoutrulyneedthatmuchlinking,youmightconsideranewdesign. GetmoreExceltipsRead56Exceltipseveryusershouldmaster andthetutorialsonhowtoaddaconditiontoadropdownlistinExcel,howtoaddcolortoadropdownlistinExcel,howtocreateanExceldropdownlistfromanothertab, howtochangeanExcelconditionalformattingonthefly and howtocombineExcel'sVLOOKUP()functionwithacomboboxforenhancedsearching.Also,checkoutthisfreePDFdownload: 13handyExceldataentryshortcuts. MicrosoftWeeklyNewsletter Beyourcompany'sMicrosoftinsiderbyreadingtheseWindowsandOfficetips,tricks,andcheatsheets. DeliveredMondaysandWednesdays Signuptoday Editor'sPicks TechRepublicPremium:ThebestITpolicies,templates,andtools,fortodayandtomorrow. It'stimetodumpChromeasyourdefaultbrowseronAndroid PythonremainsatoptheTIOBEindexforNovember,whilePHPshowssignsofdecline Deloitte:Don'truleoutWi-Fi6asanext-genwirelessnetwork 8iPadappsthattaketheApplePencilfromaccessorytonecessity BestRaspberryPifor2021:Whichboardshouldyoubuy? Commentandshare:HowtoaddadropdownlisttoanExcelcell BySusanHarkins SusanSalesHarkinsisanITconsultant,specializingindesktopsolutions.Previously,shewaseditorinchiefforTheCobbGroup,theworld'slargestpublisheroftechnicaljournals. | FullBio | SeeallofSusan'scontent RelatedTopics: Software EnterpriseSoftware Developer OpenSource Software Mobility Cloud SoftwareonZDNet ShowComments HideComments LOGINTOCOMMENT MyProfile Logout |CommentingFAQs|CommunityGuidelines JoinDiscussion LOGINTOCOMMENT AddyourComment
延伸文章資訊
- 1How 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...
- 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...
- 3Create a drop-down list - Microsoft Support
In a new worksheet, type the entries you want to appear in your drop-down list. · Select the cell...
- 4Video: Create and manage drop-down lists - Microsoft Support
- 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 ...
