Let’s say you have created a spreadsheet template that requires input from different users, eg. a sales pipeline for your sales team. In one cell, the input has to be in a very specific manner, eg. months, spelt correctly. Now if left to the different users, there may be typo errors and moreover it doesn’t make sense to have to type an input that’s restricted to some specific list.The answer is to create a drop-down list in that cell for the user to select. That way the spelling will be consistently accurate and not so tedious to type in manually.
Select the cell where you want the drop-down list as the input.
I’ve selected cell C1 in the example.
In the box that opens up, choose Settings, Validation criteria, List.
Highlight (select) the list from A1 to A7, enter. Close the Data Validation box, and click OK in the Settings box.
That’s it. Now there’s a little arrow in the cell C1 for your drop-down list of rainbow colours.