Get an instant dropdown to select data from a repetitive list - Use the Alt-Down keyboard shortcut

How to get Dynamic Excel dropdown List When working with lists and reports, you sometimes have repetitive data which you want to enter again and again. While you have the excel autocomplete function but if you have similar tellers at the beginning of the data, the autocomplete wont function properly. A very good shortcut for this would be the ctrl+down arrow. It is an easy means to speed through repetitive data entry within a column.

Just one thing to remember, this shortcut does not work with numbered lists and here you need to type the entire number. Friends just try this tip while using your excel workbooks and do remember to share your tips that you thin are interesting and should be in the upcoming videos.

Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe ... https://www.youtube.com/watch?v=Ft5ZeJRPbGM