Boris

This is true for any cell no matter what is in the cell.

The pick from list gives you a choice of items to pick from if there is anything
in the cells above the cell you are editing.

Enter a,b,c,d,e,f in A1:A6

Select A7 and F2 then right-click in the cell.

Pick from list will give you a choice of a,b,c,d,e,f


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 15:08:02 -0700, BorisS
wrote:

Just curious...I was in a formula, highlighted a vlookup command (in case
this question's answer pings on that fact somehow), and right clicked,
finding a "pick from dropdown list" option. Selected it, but nothing showed
up in the little box that appears on the sheet itself, just below the formula
cell. Just curious what this is, and whether I'm missing out on some
interesting functionality/convenience feature. I am on '03,.

Thx.