![word 2016 for mac dropdown box word 2016 for mac dropdown box](https://cdn.osxdaily.com/wp-content/uploads/2016/08/convert-word-doc-to-pdf-mac.jpg)
Dynamic source listĪ better and more flexible way to manage the pull-down list is to grab the choices from a list of cells. For example use Yes | No | Maybe not Yes | No | Not Sure. Try to make your list choices start with different letters or at least the first two letters different. Only existing selections can appear in autocomplete. That’s important when there are pull-down list choices not often used.
![word 2016 for mac dropdown box word 2016 for mac dropdown box](https://i.ytimg.com/vi/vQdMsTUZKCU/maxresdefault.jpg)
In this example, Optional is being autocompleted after typing ‘O’ or ‘Op’, because ‘Optional’ is already in the column, NOT because it’s in the data validation source. However, in a usual list or table, the standard Excel autocomplete will start working once there are cells with each option. There’s no autocomplete available in this simple dropdown (in other words, the validation source list doesn’t become an autocomplete). Keep your hands on the keyboard by pressing Alt + down arrow to pull down the list.
![word 2016 for mac dropdown box word 2016 for mac dropdown box](https://d2d42mpnbqmzj3.cloudfront.net/images/stories/doc-word/word-insert-date-picker-with-default-value/doc-word-insert-date-picker-with-default-value-1.png)
There are various ways to use a dropdown cell, some obvious, others not so obvious.Ĭlick the wedge on right will show the entire list of options. Instead use the option ‘Apply these changes to all other cells with the same settings’. If you’re happy, copy the cell to others in the list or table.Īnnoyingly, Format Painter does NOT copy data validation settings. Source: type the options separated by commas.Ĭlick OK and test on the cell. Allow blank cells, otherwise there’s an error. Make a simple drop-down list by selecting a cell then Data | Data Tools | Data Validation | Settings. Without pull-down lists or some data validation, all sorts of little ‘bludners’ can creep into your lists. No risk of misspelling or other errors that mess up your charts and reports. It’s useful for limiting the responses in a cell to what you expect. We’re talking about adding a pull-down list to any Excel cell. Later, other options for better pull-down lists like AutoComplete, tooltips and different types of warning.
#WORD 2016 FOR MAC DROPDOWN BOX HOW TO#
We’ll show that simple tip then how to use the pull-down and its limitations. Making a pull-down list is easy and there’re many tips showing the basics. Drop-down list boxes are useful in Excel but, like many things in Office, there’s more than one way to do it and more to know that the simple examples often given.