![]() ![]() In the “Allow:” dropdown menu, select “List”.In the “Source:” box, enter in your values separated by commas.Click OK to save the Data Validation options.Your cells will now have a menu when they are selected in Excel. That’s it! You have now created a drop down menu for the cells you selected. ![]() Excel Drop Down List Method #2: Refer to a Data Range You’ll only be able to enter values that are in the list you specified – and you can still type directly into the cell if you want. What if you want to update your menu items later? If one of the departments in your company has a name change, then you would have to select all of the cells that use the drop down menu, and manually update the details. (Although, if your dropdown menu is limited to only one cell, it’s not so bad…) #MAKING DROP DOWN MENUS IN EXCEL FOR MAC 2011 UPDATE#
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |