Excel Menu

[hugnie21]

I use an excel spreadsheet at work and one of the columns has a drop down menu. Only words in that drop down menu can be written in the column. Does anyone know how I can edit the list of words in the menu? Thanks

[ummmm]

I'm not sure about editing the list but have you tried to format the coloumn?

[hydrogoose]

the list of words will be written on the sheet somwhere or on another sheet in the same workbook.

The list might have been renamed as a table name or a list name or a cell range.

You need to locate that list before you can edit it.

Also, it maybe that the list has been hard coded in the vba code, which may prove diificult to change unless you know vba coding...

[Siamsal]

It's probably set just to have the existing entries in the list. If you highlight the column header, then do Data, Filter, Advanced Filter, it will show you the range of cells that is providing the list.

[Whickerman]

If you need to home in on something in particular without searching yourself, click on the filter, choose 'custom' and type what you're looking for

[Aquariel]

If it's a cell-entry drop-down menu rather than the 'data filter' :

Click on the cell with the drop-down menu and then select Data > Validation you can see the range of cells that the drop-down list uses - it's then a simple case of adding other items to the list and amending the range in the validation settings.