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. 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. 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.
0 kommentar(er)
