Click here for directions on how to use this tool, or view the directions below.
The Validation tool allows creators of a spreadsheet to set predetermined drop-down choices for cells. Not only could this expedite the process, but also ensure that all formatting is the same for the cells. The directions to use it are below.
First, select the cells that you would like the validation to apply to.
Second, click Data then Validation from the toolbar.
Third, choose your criteria for the cells. In the example below I chose “List of Items”. Then you need to type in the choices that will appear in the drop-down for each of the selected cells from step one. Be sure to click Save.
Users are now able to select from a drop-down menu.