Home » Forums » Open Source Learning Center » Learning requests

Creating Drop down Menus in EXCEL

Submitted by excel_joy11 on 28 September, 2011 - 07:29

I have to create a Excel spreadsheet regarding the Stock report of 100 outlets.For this I need to know how to make a central drop down menu which will list all those 100 outlets.
So once I click on the drop down menu and select a particular outlet, it will show that specific outlets stock.
Would appreciate your help and feedback.Thank You!

AttachmentSize
CURRENT STOCK SUMMARY (OXYSEPT SOLUTION).xls23 KB
‹ MessageBox error and adding it to a Beforesave to an audit trail formula for merging cells ›
»
Vishesh's picture

Just like to confirm if you

Submitted by Vishesh on 28 September, 2011 - 14:06.

Just like to confirm if you want the list in drop down menu only ? Other simpler options to show the list is Data Validation and Combobox.

»

Creating Drop down Menus in EXCEL

Submitted by excel_joy11 on 30 September, 2011 - 04:37.

Vishesh,

I need the whole list of outlets in the drop down menu, or else the spreadsheet is getting longer which my CEO is not approving.I would appreciate If you can teach me how to create one drop down menu in EXCEL.Thank You!

»
Vishesh's picture

Check this url. This might be

Submitted by Vishesh on 30 September, 2011 - 17:44.

Check this url. This might be of some help...

http://excelexperts.com/Add-Custom-Options-to-Right-Click-Menu

»