Can anybody help me, how to do drop down list in my excel report
Can anybody help me, how to do drop down list in my excel report
Hello rmjacob,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
hi! Welcome to excel forum,
Try going to Data tab and go select "data validation" , and then allow "List" and the source would be your Range on your drop down list in the cell you will choose. please be also adviced that you need to put a blank on top of it before the name if you want it blank by default.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks