Excel Drop Down List Creation

Excel Drop Down List Creation. For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los. You can find and double click a saved excel file on your computer or open microsoft excel and create a new worksheet step 2 enter the list of values for your drop down in a column.

Create A Purchase Order In Excel With Drop Down Lists Linked To A Customizable Price List Worksh Invoice Template Purchase Order Template Invoice Template Word from www.pinterest.com

First if you type a value. Go to the data tab on the ribbon then click data validation. For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los.

You can add the drop down list to multiple excel cells.

You can find and double click a saved excel file on your computer or open microsoft excel and create a new worksheet step 2 enter the list of values for your drop down in a column. For example if you want your drop down list to include new york boston and los angeles you can type new york in cell a1 boston in cell a2 and los. Select the cell which you want the drop down list to appear in. To create a drop down list in excel execute the following steps.