![office word 2016 for mac drop down not dropping down office word 2016 for mac drop down not dropping down](https://www.addintools.com/documents/word/images/shot-classic-sort.png)
- #Office word 2016 for mac drop down not dropping down how to#
- #Office word 2016 for mac drop down not dropping down Pc#
Now let's see how to create an excel dropdown menu using values already present in the spreadsheet. Drop-down menu with values taken from the spreadsheet
![office word 2016 for mac drop down not dropping down office word 2016 for mac drop down not dropping down](https://www.addintools.com/documents/word/images/shot-classic-clipboard.png)
Then, to change the options available in the drop-down menu, select the cells in your spreadsheet again, click the button Data validation Excel and change the values present in the field the origin. Click on this arrow and you will see a menu appear with all the options you previously specified in the field the origin excel. For example, if you want items to appear in the drop-down menu Value 1, Value 2 y Value 3, in the Excel Source field, you must write Value 1 Value 2 Value 3.Īt this point, press the button good guidance on save settings, select whatever cell you have entered the drop down menu and you will see a small arrow on the right. In the window that opens, select the item list of menu allow and write in the field the origin, all the options you want to show in the menu (separating them with a semicolon). Now you must define the values that will appear in the drop-down menu. To select "sparse" cells across multiple rows and columns, use the join Ctrl + click on Windows and the combination Cmd + click on Mac
![office word 2016 for mac drop down not dropping down office word 2016 for mac drop down not dropping down](https://wordknowhow.files.wordpress.com/2013/06/untitled-1.jpg)
#Office word 2016 for mac drop down not dropping down Pc#
If you need a hand to select multiple cells at the same time, know that you only need to click on the first cell to be included in the selection after which the button must be pressed Shift (Shift) in the keyboard from the PC and click on the last cell to be selected (whenever you want to select a range of cells that belong to the same column or row). If you can't find it, it's the icon that shows two blank text fields: next to the first one there is a green check mark and next to the second one there is a red prohibition sign. To create the first type of drop-down menu, one containing values defined directly by the user, you must select the cells in which to insert the menu and click the button Data validation located on the card data Excel (top right). As already mentioned above, Excel dropdown menus can contain values defined directly by the user, therefore, sentences, words or figures present exclusively within the menu, or values already present in other areas (or other pages) of the sheet calculation.