I am using Excel 2003 but have been a user of 2000 for a long time. I 've
worked through the creating of a drop down list and understand that but
cannot find advice on the following from Help, so could one of you kind
people out there explain to me:
How do I make changes to a drop down list (ie amend, add items). Indeed,
can I?
Can I use the list for all worksheets within a workbook (hence the need to
amend & add to the list?
I am cleansing a database which is why I am using the drop down list. I
shall then copy the workbook to disk to be loaded onto a completely different
pc (not connected in anyway to mine). Will the list be available if the
person that I am doing this for has another version of Excel?
Sorry to be dim.