Google Sheets has a new way to do dropdowns. Is it naughty or nice?
Members-only tutorial
Watch the video and get the practice sheet with membership.
About this Tutorial
Sheet Resources
Video Transcript
<div>0:00 So you're trying to apply naughty or nice to a list of names and you don't want to type in naughty or nice.<br>0:08 Well, you can use now Google Sheet's new dropdown Learn how to ensure your data meets specific criteria in Google Sheets. Opens in new tab interface in order to select Discover how to select specific data using the query function in Sheets. Opens in new tab this. So let me show you. This just rolled out very recently.<br>0:18 We go to insert and we can insert a dropdown Learn how to ensure your data meets specific criteria in Google Sheets. Opens in new tab . Now over here we have some options.
The moment that you apply this dropdown Learn how to ensure your data meets specific criteria in Google Sheets. Opens in new tab , it only applies it to B one, but we can actually change this right here, apply to range Find out how to apply settings to a specific range in your spreadsheet. Opens in new tab B one to B or B, colon B, and it'll apply to the entire range Understand what a range is and how to use it effectively in Google Sheets. Opens in new tab .<br>0:36 The entire column Learn how to work with entire columns in your Google Sheets. Opens in new tab and the dropdown Learn how to ensure your data meets specific criteria in Google Sheets. Opens in new tab options are gonna be naughty. We just changed this to naughty and we changed this to Nice.<br>0:44 And the cool thing is that instead of doing dropdown Learn how to ensure your data meets specific criteria in Google Sheets. Opens in new tab plus conditional formatting Explore how to format cells based on certain conditions in Sheets. Opens in new tab , we can actually do that right here in the dropdown Learn how to ensure your data meets specific criteria in Google Sheets. Opens in new tab menu.<br>0:54 We can say naughty and nice and we can color code these right away and we can hit done.
And now we have this pretty cool interface that has rounded corners.<br>1:03 This looks a lot like Air Table Get insights on how to create and manage tables in Google Sheets. Opens in new tab , doesn't it? Pretty cool interface. Pretty new, different way to do dropdowns now in Google Sheets.</div>