Get Excel Drop Down List

Click on the cell where you need to enter multiple lines of text. Type the first line. Press Alt + Enter to add another line to the cell. Tip. ... Type the next line of text you would like in the cell. Press Enter to finish up.

Go to Data > Data Validation. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, Select cell contents in Excel containing those entries. You'll see the list range in the Source box change as you select.

#1 select one cell that will be holding the drop down list. ... #2 Go to DATA tab, click Data Validation command under Data Tools group. #3 the Data Validation window will appear. #4 change the Allow: value to List from the drop-down list under Validation criteria section. ... #5 the drop down list has been created.

7:13 9:39 Suggested clip How To Create A Bullet List In Microsoft Excel - YouTubeYouTubeStart of suggested clipEnd of suggested clip How To Create A Bullet List In Microsoft Excel - YouTube

Select a blank cell that you want to create a bulleted list, and hold Alt key, press 0149 in the number tab, and then a bullet is inserted.

Enter the values and then select the list. Choose Options from the Tools menu. Click the Custom Lists tab. Click Import. Click OK to return to the sheet. Select a blank cell, enter the first item in the list and then expand the fill handle to complete the list.

Press Alt + Q keys simultaneously to close the Microsoft Visual Basic Applications window. From now on, when click on a drop down list cell, the drop down list will prompt automatically. You can start to type in the letter to make the corresponding item complete automatically in selected cell.

Double-click the cell in which you want to insert a line break. Click the location inside the selected cell where you want to break the line. Press Alt+Enter to insert the line break.

Go to Tools>Options - Edit and check Enable AutoComplete for cell values. Move your list of items is in the range immediately above the Validation cell. Hide the rows above your Validation cell.

Enter the values and then select the list. Choose Options from the Tools menu. Click the Custom Lists tab. Click Import. Click OK to return to the sheet. Select a blank cell, enter the first item in the list and then expand the fill handle to complete the list.