In Worksheet 1 list out the author names in a column as under:.

For example, let’s create a drop-down list of book titles of your favorite authors. This method, though a bit time consuming, but it saves time in the long run. Creating an Excel drop-down list based on a named range Locating each cell and editing it can be a painful process. Editing will be cumbersome as you will have to change every cell that references the Data Validation list. If you want the same list to appear in multiple cells, then this method should be avoided. The above method is feasible if you have only few cells residing on the Worksheet. Users can click the down arrow to display the list and select an item.

Click OK and your drop-down is list is created.

Select Ignore blanks if you want your users to leave the cell empty.

In the Source box, type the items that you want to show in your drop-down menu separated by a comma (with or without spaces).

From the Allow drop-down box, select List.In the Data Validation dialog box, click Settings tab.On the Excel menu bar click Data > Data Tools group and then click Data Validation. This turns out to be a time-saver for creating a questionnaire type of worksheet. If you select the whole column, a drop-down menu will be created in each cell of that column. It can be a single cell, a range of cells or the entire column as displayed in the illustration below. Select a cell or cells where you want the drop-down box to appear. Creating an Excel drop-down list based on Comma Separated Values The methods described in this section apply to most of the Excel versions, including 2013, 2010, 20. The drop-down list helps limit the number of choices available to you and speeds up data entry in Excel. You can use the drop-down list to enter data in a spreadsheet from a predefined items list. In this article we will discuss how to add a drop-down list to an Excel cell. Excel has the basic spreadsheet feature wherein you use a collection of cells arranged into rows and columns to organize data manipulation. We all know that Excel is a commercial spreadsheet application produced and distributed by Microsoft for Windows and Mac OS X.

Drop down list in excel