How to create a drop-down list in Google Sheets


If you have a Google Sheet filled with inconsistently entered data, it may take some time to make cell contents consistent. A series of sorts (Data | Sort) or find-and-replace (Edit | Find And Replace) actions can help transform a jumble of entries into a standardized set of cells.





Like it? Share with your friends!

What's Your Reaction?

Angry Angry
0
Angry
Confused Confused
0
Confused
Buffoon Buffoon
0
Buffoon
Cry Cry
0
Cry
Cute Cute
0
Cute
WOW WOW
0
WOW
Dislike Dislike
0
Dislike
Fail Fail
0
Fail
Geek Geek
0
Geek
Like Like
0
Like
Andy Wolber

Send this to a friend