Join us at GITEX 2024! Discover our solutions at Hall 4, Booth H-30 Book your live demo today.
header icon
document-icon
How to lock create a drop down for existing data in Google Sheets ?
By Mitisha
|
Sep 05, 2024
|
document-icon Kopyst
|
16 Steps
document-icon
How to lock create a drop down for existing data in Google Sheets ?
By Mitisha
|
document-icon Kopyst
|
16 Steps

1
2
Select the "Cell" and right click here.
Merged Image
3
Click on the "Dropdown"
Merged Image
4
Click on this "Arrow" icon.
Merged Image
5
Select the "Color" from given option.
Merged Image
6
Click on this "Arrow" icon.
Merged Image
7
Select the "Color" from given option.
Merged Image
8
Click on this "Arrow" icon.
Merged Image
9
Select the "Color" from given option.
Merged Image
10
Click on this "Arrow" icon.
Merged Image
11
Select the "Color" from given option.
Merged Image
12
Click on this "Arrow" icon.
Merged Image
13
Select the "Color" from given option.
Merged Image
14
Click "Advanced Options"
Merged Image
15
Select "Arrow"
Merged Image
16
Click "Done"
You can successfully lock create a dropdown for existing data in google sheets by following these steps
Merged Image