View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default Selecting from a list

What you're seeing is an in-cell dropdown. It is created by clicking
(from the menu) ~Data ~Validation. A window appears, and you in the
"Allow" box you choose "List". A separate box appears to allow you to
enter the Source range for that list. So to edit the list, you may need
to expand the range specified in the Source box, then add items for the
in-cell dropdown in the Source range.