Why is Drop Down List in Google Sheet better than in Excel - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Learn why is Drop Down List in Google Sheet better than in Excel. This will also contribute to answers to what makes Google Sheets better than Excel?   Adding Drop Down List  1) Select cell B2  2) Data ~ Data Validation  3) Add Rule  4) Criteria to "Dropdown (from a range)"  5) '212'!A14:A  6) OK  7) Done  8) Close Data Validation Rules window    Why is Drop Down List in Google Sheet better than in Excel,What makes Google Sheets better than Excel?,What are two differences between Google Sheets and Excel?

Transcript

00:00In my previous video, I demonstrated how you can do a drop-down list in Excel. In

00:04this video, I'm going to show you why Google Sheet drop-down list is much

00:07better than Excel. To start off with, let's add a drop-down on this cell B2

00:11here. Select the cell, go data, data validation. On the far right-hand side,

00:16you have a data validation rule window that pops up here. Click on add rules. In

00:21the criteria, you're gonna pull down here and select drop-down from range and then

00:26click on this icon here. This pop-up should appear. Click on this text box and

00:31now select the elements that you want to include on your drop-down list. One thing

00:35I'm gonna do over here is that instead of D7, we're gonna remove the 7 from the D

00:41here. So what essentially this means is that any item below cell D3 and below

00:46will be included and click OK. So this essentially allows you to do auto

00:50expansion. So I'll show you what I mean by that. Click on done and let's close this

00:55window here. And let's say for example, have a look at this guy here. You have all

00:59the items in here. And if you go ahead and add Apple in here, you can see on your

01:04drop-down, Apple appears as well. The beauty of Google Sheet drop-down is that

01:09let's say if you have duplicate entries here like this, you can see that it only

01:14appears once. So it resolves into Unique and show you only one of each item. Let me

01:19show you as a test. I'm just gonna put a fake here and put Apple like this. You can see

01:24there's only one Apple and the fig up here. So it prevents duplicate. Another

01:28capability that the drop-down on Google Sheet have is that, let's say for example,

01:32if you remove a bunch of items from your list here, and if you go to a drop-down,

01:36you can see that the item that was removed are not in the list. Hence, you

01:41don't have a blank spaces or white spaces as well. Let me know in the comment

01:44sections are these features in Google Sheet a game changer for you and your

01:48organization.

Why is Drop Down List in Google Sheet better than in Excel - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended