![]() ![]() ![]() Once finished, we must select the area of cells that contains the information, and then do a right click with our mouse in order for the shortcut menu to appear as shown below. As we can see in the image below, I have typed in a few countries to be included in the Drop Down List. These entries should be in a single column or row with no blank cells between them. Just follow the steps below in order to learn how to create a Drop Down List in Excel 13.įirst, we must type in the information that we want to be included in the Drop Down List. ![]() What is the use for drop down lists? If someone uses the worksheet that we created, they can click on an arrow and then click on one of the entries in the list in order for the cell to be filled. We can make a worksheet more efficient by creating drop down lists. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |