Software·43,920 discussions

Google Sheet – Data Validation and Dropdown content

Tags: Google, Software

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 ?

Topic

My way

In reply to Google Sheet – Data Validation and Dropdown content

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.

[Author]

Replies