Question Locked

Google Sheet - Data Validation and Dropdown content

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

Thank you for sharing the key content with us ( https://www.techrepublic.com/article/how-to-edit-a-drop-down-list-in-google-sheets/#:~:text=Edit%20the%20text%20to%20add,each%20item%20by%20a%20comma.&text=In%20a%20web%20browser%2C%20select,Save%20to%20apply%20your%20changes. )

I have a query :
- If I have the characters present in the cell and wanted to add the dropdown in the same cell range, without losing the existing data present in cell, can I do it in google sheet ?

Example : Column C has three type of data values such as "WIP, NP, DONE"; Now, I want to add the dropdown to that range and if data is already present it should by default select existing value else it will be blank and awaiting the user action. Can we do it by anyway ?

1 reply

by AliGreer43 edited

1. Select the range of cells in column C where you want to add the dropdown list.
2. Click on the "Data" menu at the top of the Google Sheets interface.
3. From the dropdown menu, select "Data validation."
4. In the data validation dialog box that appears, choose "List of items" under the "Criteria" section.
5. In the "List of items" field, enter the values you want in the dropdown list, separated by commas (e.g., WIP, NP, DONE).
6. Check the "Show dropdown list in cell" option.
7. Click "Save" to apply the data validation.
Now, the cells in column C will have a dropdown list with the specified values. If the cell already contains one of the dropdown values, it will be selected by default. Otherwise, the cell will be blank until the user selects a value from the dropdown.

This discussion is closed to new replies.