Assuming DV dropdowns.

Select "Required" in top dropdown cell.

Select that cell and all other dropdown cells in the column.

F2 then CTRL + Enter


Gord Dibben MS Excel MVP

On Wed, 12 Aug 2009 22:36:59 GMT, "christophercbrewster via OfficeKB.com"
<u3143@uwe wrote:

Excel 2003, XP: I have a spreadsheet with a large number of cells containing
drop-down lists. I need to reset these. For example, I'd like to reset all
the cells in one column to "Required", which is on all the drop-down lists.
When I select all the cells and right-click, one of the choices is "Pick from
drop-down list", but that choice doesn't do much. (I won't describe it, but
you can try it.) The obvious answer is "write a macro", but I'm wondering if
there's a built-in way to do this. Thanks.