How to create drop down list in excel 2007?
Answers
Answered by
0
11 steps:
Open the spreadsheet in which you want to add the drop-down box
Create a list of the items to appear in the drop-down list.
Click the cell you want to place the drop-down box in.
Click the "Data" tab of the Microsoft Excel 2007 ribbon.
Click the "Data Validation" button from the "Data Tools"
Click the "Settings" tab and then click "List" from the "Allow" drop-down list box.
Click the toggle button at the end of the "Source" box
Select or clear the "Ignore blank" check box, depending on whether you allow the cell containing the drop-down box to be left blank
Click the "Input Message" tab to display a message box when the cell of the drop-down box is clicked
Click the "Error Alert" tab to display an error message if invalid data is entered into the drop-down box cell.
Click "OK" to save the validation criteria and create the drop-down box.
Open the spreadsheet in which you want to add the drop-down box
Create a list of the items to appear in the drop-down list.
Click the cell you want to place the drop-down box in.
Click the "Data" tab of the Microsoft Excel 2007 ribbon.
Click the "Data Validation" button from the "Data Tools"
Click the "Settings" tab and then click "List" from the "Allow" drop-down list box.
Click the toggle button at the end of the "Source" box
Select or clear the "Ignore blank" check box, depending on whether you allow the cell containing the drop-down box to be left blank
Click the "Input Message" tab to display a message box when the cell of the drop-down box is clicked
Click the "Error Alert" tab to display an error message if invalid data is entered into the drop-down box cell.
Click "OK" to save the validation criteria and create the drop-down box.
Similar questions