Frustrated With Sheets New Dropdown Pills?

Intermediate

About this Tutorial

3 options to show dropdowns. It looks actually much closer to Airtable, but some people don't want this some sheets sort of fanatics, enthusiasts, people who love Google Sheets and don't really want to look.

Video Transcript

<div>0:00 Hey, are you frustrated with the sheets new drop-down pills? This is this pill form that the drop-downs have taken. What is interesting about this is that it looks really different than Google Sheets, right? 0:11 It looks actually much closer to Airtable, but some people don't want this some sheets sort of fanatics, enthusiasts, people who love Google Sheets and don't really want to look. 0:20 Like something else, but also these things get in the way sometimes of styling.

They, they sort of draw the eye to these drop-downs and sometimes we don't want to drop, draw the eye to the drop-down. 0:30 We actually want to like just get the data there. Well, I want to share with you one extra thing you might not know about. 0:37 If you just right click on drop-down here, I'm going to move my face over. A little bit. This is the end result if we use drop-down from a range . 0:45 And we're going to get this when we use the drop-down with a range , unless we do this one thing, go down to advanced options . 0:53 It doesn't even look like it really is an option.

It looks even like there's no options here. It's sort of a header , but if you click on advanced options down here, and you scroll down, again, you have to scroll down a little bit, so it is very hard to find. 1:05 You have display style. Now you can change the display style to one of three things. The chip is what you see here, and that's the new default way of using drop-downs. 1:15 You can default back to the original style, which is an arrow. This works just like the new drop-down pills and chips do, except they just look like an arrow. 1:27 Which brings us to the third one.

You can also choose plain text . Now plain text is interesting because we didn't have this option before. 1:35 We had the arrow option, and that was the only option. Now we have chip , arrow, and plain text . But what does plain text do? 1:41 It doesn't look like you can change it. It blends in very well with everything else.

But if you double-click on the drop-down where you want a drop-down, it works. 1:53 So this becomes a little less intuitive that there is a drop-down there, but it provides you an option to make it visually fit in. 2:01 And more, if maybe not every single person who uses this is using this for the first time, if you have sort of sheets that a few people use consistently, you can say, Hey, I'm going to change this so that this arrow doesn't show up, but you can still change these options just like you would any other 2:20 drop-down option.

This drop-down and it doesn't look like a pill, this pill form. And again, some people really like this sort of this rounded edges in Google sheets is very different, but some people want even the original idea of a drop-down, which is an arrow. 2:37 Or again, just to summarize, we have this last option, which is really. Interesting, which is to show nothing, but it still works exactly like a drop-down does. 2:47 Hopefully this was helpful to you. Bye.</div>