Sheets Drop-downs








Add drop-down cells to enhance your spreadsheet in seven easy steps.

Create a drop-down list

  1. Open a spreadsheet in Google Sheets.
  2. Select the cell or cells where you want to create a drop-down list.
  3. Click Data and then Validation.
  4. Next to “Criteria,” choose an option:
    • List from a range: Choose the cells that will be included in the list.
    • List of items: Enter items, separated by commas and no spaces.
  5. The cells will have a Down [v] Arrow. To remove the arrow, uncheck “Display in-cell button to show list.”
  6. If you enter data in a cell that doesn’t match an item on the list, you’ll see a warning. If you want people to only enter items from the list, choose “Reject input” next to “On invalid data.”
  7. Click Save. The cells will show a drop-down list. To change the color of a cell based on the option selected, use conditional formatting.

Change or delete a drop-down list

  1. Open a spreadsheet in Google Sheets.
  2. Select the cell or cells you’d like to change.
  3. Click Data and then Validation.
  4. To change the options listed, edit the items next to “Criteria.”
  5. To delete a list, click Remove validation.
  6. Click Save. If you change the contents of the range you’ve selected, the changes will be made in the list automatically.

Walk–through

Sheets Dropdown My Google Site
 

Source: Google G Suite





By | 2017-07-20T14:53:59+00:00 July 16th, 2017|Categories: Tutorial|Tags: |0 Comments

Leave A Comment