Hi All, The central and state governments were well prepared for the yesterday's cyclone Hudhud. And by God's grace we had very little casualties in comparison to last years Phailin. RIP for those who couldn't make it.
I was completely out of "Excel in MS Excel" and was fully occupied from last 6 months on my office work. This really paid me high on satisfaction. I have won two deals this financial year. Still two more to come. Finger crossed though!!!
Have got some time again to write for you all. I would like to share with you that in Excel we can create a drop down menu by using the "Data Validation" tools available under the Data ribbon.
Step 1: Create the list of items which you would like to put in the "Drop Down" list.
Step 2: Click "Data Validation" in the Data Ribbon and then select "List" from the drop down. This will pop out a "Data Validation" dialog box. In this you have to locate the list of items in the Source cell which you would like to bring in the drop down menu.
And that's it!! You have drop down menu in the selected cell. Now which ever item from the list you want you can select.
This feature helps you a lot when you want to choose an item from different options. If you allow users to populate the same, there may not be any uniqueness on that. And further it will be difficult for you to apply selections etc.
For more information on how to do this, please get in touch with me at Samrat.biswaas@gmail.com
Friends, Now Excel in MS Excel is available in Facebook as well. You can quickly raise your MS Excel related queries in its platform. I will try to resolve them.
Visit Other MS Excel Tips and Tricks
Samrat Biswas, Six Sigma (Green Belt), MOS Excel Expert 2013, ITIL 2011 Foundation
Advanced MS Office (Excel, Word, PowerPoint, One Note, Outlook), and MS Visio
---------------------------------------------------------------------------------------------------------
Be a part of regular Weekend Knowledge Sharing Sessions
Reach me @ +91 8095039316/ +91 8095039315
