This tutorial is available for all users. Start with a 7 Day Free Trial today and get access.
Hey there stranger!
Let's not be strangers any more. Start a FREE TRIAL today to view this tutorial, right now.
Naughty or Nice? - Google Sheets' New Dropdown Chips
About this Tutorial
0:08 Well, you can use now Google Sheet's new dropdown interface in order to select this. So let me show you. This just rolled out very recently.
0:18 We go to insert and we can insert a dropdown. Now over here we have some options. The moment that you apply this dropdown, it only applies it to B one, but we can actually change this right here, apply to range B one to B or B, colon B, and it'll apply to the entire range.
0:36 The entire column and the dropdown options are gonna be naughty. We just changed this to naughty and we changed this to Nice.
0:44 And the cool thing is that instead of doing dropdown plus conditional formatting, we can actually do that right here in the dropdown menu.
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.
1:03 This looks a lot like Air Table, doesn't it? Pretty cool interface. Pretty new, different way to do dropdowns now in Google Sheets.