Do you fancy yourself a Google Sheets power user? If so, you might have encountered an occasion or two where a handy drop-down list was necessary. This is especially so if you’re building a spreadsheet that requires selecting from several options over and over. It’s one thing if you have to type something a couple of times, but when you have to type those same items repeatedly, that repetition adds up.
Or maybe you’re sharing the new Sheet with other users, and you want to simplify the data entry process as much as possible.
I want to show you how to create a drop-down in Google Sheets. It’s actually much easier than you might think, thanks to a handy, built-in GUI.
And thus, without further ado, let’s get to creating.
Creating your first Sheets drop-down
You might also check the box associated with Show Validation Help Text, as that will give the user help; should they input invalid data, they will get a warning.
After configuring your drop-down list, click Save to save the information.
Using the drop-down list
After creating the drop-down list, it’ll appear in a sheet with a downward-pointing arrow. All a user has to do is click the drop-down and select from the options you’ve made available (Figure 3).
You might also consider adding a cell either above or directly to the left of the drop-down and add content to that new cell indicating what the drop-down is used for.
And that’s all there is to adding a drop-down list in Google Sheets. And here you thought it was going to be a complicated task. Next time around, we’ll learn how to add conditional formatting to your drop-down lists for even more spreadsheet fun.
Disclaimer : OneNewsTech.com is an automatic aggregator around the global media. All the content are available free on Internet. We have just arranged it in one platform for educational purpose only. In each content, the hyperlink to the primary source is specified. All trademarks belong to their rightful owners, all materials to their authors. If you are the owner of the content and do not want us to publish your materials on our website, please contact us – email@example.com. The content will be deleted within 24 hours.