How to use the pick from drop down list option in Excel. Follow this step by step tutorial to learn how to use the pick entries from a drop down list option in Excel
Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/103440382717658277879 - our group in Google+
Microsoft Excel is a detailed software that can be used as a multiple analysis tool. It gives simple options that can help you manage and manipulate data to derive desired or actual results. It is important to understand the workings of this software to be able to use it effectively. Data Entry in Excel is made very easy with the suggestions given by Excel. There is a simple option that also allows you to Pick from a drop down list in Excel. Follow this step by step tutorial to learn how to pick from a drop down list option in Excel.
Step # 1 -- Use existing entries as suggestions
Sometimes same words keep on repeating while you do data entry in Excel and Excel has the function of guessing and automatically suggesting the word so that you do not have to type it again. For example if there is already an entry with the letter "S" in the column, so when you type in the letter "S" in another cell within the same column, excel will give you suggestions, showing the repeating titles in the column.
Step # 2 -- Select 'Pick from drop down list'
If you are working on a list that does not include new entries and you have to use the old ones only, you can right-click on the empty cell and select the "Pick from drop down list" in Excel. With that done, it will show you the list of entries that have been made so far.
Step # 3 -- Press 'Alt + Down Arrow'
You can also use the shortcut key "Alt + Down arrow" for this purpose. Now, all you have to do is click on the option from the drop down list and the data will be entered in the cell.
Tags: How to use the pick from drop down list option in Excel, 000949, How, to, use, the, pick, from, drop, down, list, option, in, Excel