![]() ![]() In the Source Box either select the data from your desired sheet. On the Settings tab, in the Allow box, click List.ģ. These shortcuts help you save time and projects you like a professional in front of your colleagues.Ģ. I personally prefer to use the keyboard shortcuts. In the Ribbon go to Data Tab, in the Data tools select Data Validation. You can do the same by a long process also. ![]() Press Alt + A + V + V which is the keyboard shortcut for Data Validation. ![]() Open your workbook in which you want to enter the drop-down list and follow the steps given below:ġ. ![]() It might seem weird but it’s really that easy. You can create a Drop-down list in just 3 easy steps which might take about 30-40 seconds of your time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |