Do I use Data Validation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to be able to have a cell be empty but once i click on the
cellhave a drop down arrow appear once I click on the arrow a list appear.
How do I do this?
 
Hi,

Do the following:

1. Assume that you a value from A1:A10 in Sheet1
2. Select A1:A10.
3. On the Insert menu, point to Name, and then click Define.
The Define name dialog box is displayed.
4. The refers to text box displays =Sheet1!$A$1:$A$10
5. In the Names in Workbook text box, type a name, for example try, and then
click the Add button. The name try, is added as an item in the Names
Workbook list.
6. Click OK to return to the Worksheet.
7. Select B1:B10 in Sheet1 (Example)
8. On the Data menu, click Validation. The Data Validation dialog box is
displayed.
9. Click the Settings tab.
10. In the Allow list, select List.
11. In the Source text box enter the named definition. for example enetr =try
12. Select the ignore blank and in-cell dropdown check boxes.
13. Click Ok to return the worksheet. An arrow is displayed for all the
cells you selected.
14. Click the arrow to select an Item.

Challa Prabhu
 
Back
Top