How do I edit a drop down list in a cell.
F Frank Kabel Oct 5, 2004 #2 Hi what do you meant with Edit? And what kind of drop down are you using (Data - Validation?)
D Debra Dalgleish Oct 6, 2004 #3 If the cell has a data validation list, it may be typed in the Data Validation dialog box (Data>Validation), or in cells in the workbook. You can change either source list. There are data validation instructions in Excel's Help, and here: http://www.contextures.com/xlDataVal01.html
If the cell has a data validation list, it may be typed in the Data Validation dialog box (Data>Validation), or in cells in the workbook. You can change either source list. There are data validation instructions in Excel's Help, and here: http://www.contextures.com/xlDataVal01.html
