Lost "Pick from list"??

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I have a list of entries, and two columns are reserved for category
classifications. Since several entries will need the same classifications,
it's easy to right-click in the cell and use "Pick From List" to ensure
consistency. Suddenly, though, I seem to have lost this. Past a certain
row, the right-click menu does not allow "Pick From List". There is no
validation list used; the list is simply all the previous entries.

The spreadsheet is created by taking last week's workbook, using formulas to
update it with this week's information, then pasting the values, colummn
widths, and formats only into a new workbook and saving it (that cuts down
on file size and working speed by getting the formulas out of the workbook).

Does anyone have any thoughts on why the "Pick From List" might not work?

Ed
 
Hi

Check out for empty cell above (check row numbers also - maybe a row is
hidden, or its height set to 0.
 
Thanks for the reply. I regularly use this feature with empty cells above,
and when filtered bith by Auto Filter and by hiding rows. I can't identify
anything that would stop this feature from coming up that hasn't been
encountered sometime in the past.

Ed
 
Back
Top