Adding a dropdown menu in Excel 2003 is not difficult, however if you dont know the right step it can take forever. Here's how:

1. Enter the value of the dropdown in the Excel sheet. For example:

B10 Status
B11 Invoiced
B12 Paid
B13 Past Due

2. Go to Data Menu and select Data Validation.

3. Click on settings Tab then to go Allow field and select List.

4. Click on the source and select the status value from the Excel sheet.

5. Ensure In-cell dropdown is ticked.

6. Click on OK and you are done.

Check the video below if you still have an issue.

This method also work if you have your drowndown value on a different data sheet.

• Add New
• Search

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

Message:

Security

Please input the anti-spam code that you can read in the image.

"