课程: Google Workspace Hacks: Unlocking Digital Productivity
今天就学习课程吧!
今天就开通帐号,24,600 门业界名师课程任您挑!
Create dropdown options
- [Instructor] Right now I'm inside of a Google sheet that I've created, and you can see here that I need to enter some information. For some of the boxes I need to type in the information. But for this third one down, there's actually a dropdown box. It's asking group, and then I can select the group that I belong to. This can be really helpful in a lot of situations, especially if you're having others fill out information in spreadsheets that you're sharing. I want to take a look at how to create these dropdown boxes inside of Google Sheets. So let's say that I want to add another cell. I'm going to go right here and put in team. Next over to the side, I want people to have the option to be either on the sales, marketing, or content team. Now the way that I can do this is I need to navigate to somewhere else in the spreadsheet and put in the values that I want to use. Now I'll scroll down here a ways where I actually put in these other ones, and I can type in the options that I…