Simply copy the cell with the drop-down list and paste it to another cell. Tip: If you have a long list, you can scroll with your arrow keys, or press alt+up/down arrow, or type the first few letters of the word. Click on the arrow to pick from the list, which will appear in your cell. An arrow symbol will appear beside your cell to indicate there’s now a drop-down list.Ĩ. Click on the small arrow to expand the Data Validation box again (bottom right corner of the floating field).ħ.
Click on the ‘Source’ field, then go to the list you created and select it.ĥ. In the ‘Allow’ drop-down menu, select ‘List.’Ĥ. Go to Data → Data Validation → Settings tab.ģ. On your existing worksheet, click on the cell/s where you want a drop-down list.Ģ.
For example, it could be a list of grocery items.
Insert drop down list excel how to#
How to Create an Excel Drop-down ListĬreate a list in Excel. Read on to learn more and discover how easy it is to use them. Flash Fill – Excel can fill entire columns based on patterns of other columns.AutoFill – create entire columns or rows of data based on the value of the first cell.Drop-down lists – just click on an arrow in the cell to choose your data from a list.With these tools, you no longer need to type the same data over and over! What are These Functions? Excel can identify patterns, automatically display consecutive data, set up message alerts, and more.
Learn to create an Excel drop-down list, use autofill, and flash fill functions to save you a ton of time.
0 kommentar(er)
