Others

Question 1

How to make a Dropdown list

Answer 1

1. Create a list in a different spreadsheet.
2. Click on the cell where to create the dropdown.
3. Data > Data Tools > Data Validation > Settings > Select “List” from the Menu > Source > Click the arrow with underline Icon in Source box > Select the list

For Yes or No, or Y or N, follow the process above and just type Yes or No, or Y or N, in the Source box instead.