Buzz
Most people are familiar with what Google Sheets is, how to create and use its basic features. However, when it comes to working regularly with spreadsheets, knowing how to create Drop Lists in Google Sheets can be your lifesaver when you have to enter a series of similar data fields.
Guide to Creating Dropdown Lists in Google Sheets
The Easiest Way to Create Drop Lists in Google Sheets
- 1. Quick Guide
- Step 1: Open your Google Sheets file, select the range of cells to apply the Drop List to.
Step 2: Click Data => Select Data Validation.
Step 3: Create a Rule => Choose Dropdown menu in Criteria.
Step 4: Enter Drop List content and select Done.
2. Detailed Guide
Step 1: Open the Google Sheets file you want to create Drop Lists => Select the range of cells you want to create Drop Lists.
Step 2: Click Data => Select Data Validation.
Step 3: Click Add rule.
Step 4: Here you will customize the data display rule.
- Range of cells (1) you previously highlighted.
- Select Dropdown Criteria (2) to manually enter content.
- Enter content to display in the Drop List (3), you can select Add another item (4) if you want to add new content.
Step 5: Click Advanced options to set rules and Display Type of the Drop List.
Step 6: Press Done to apply Rules.
Step 7: Now go back to the cell where the rule was applied, click the triangle icon and the Drop List will appear.
After successfully creating a Drop List in Google Sheets, you'll be able to instantly select data from the dropdown list in Google Sheets without having to manually input data from each cell using the keyboard as before. Don't forget to adjust Wrap Text in Google Sheets to display data in each cell more visibly and systematically.
