Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drop down list changes, worksheets and multi-user
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. |