#HOW TO MAKE A DROP DOWN LIST IN EXCEL FROM A TABLE HOW TO#
How to Create a Drop-Down List in Google Sheets.It also makes sure that your data entry is error-free as you’re allowing a user to select from a drop-down list instead of entering the data manually (which may lead to misspelled words or incorrect format). The upside to making a drop-down list is that it’s quite simple and gives immediate results. Whether you’re making a budget for your monthly expenses or calculating grades of every student in the class, a drop-down list can be a helpful and quick way to do that. This way, you don’t have to manually enter the text – simply select it from a drop-down list (as shown below). Google Sheets has some useful features that help you be more efficient when it comes to data entry.ĭrop-down lists are one such feature, which allows you to quickly select from a pre-filled list.
You can also easily remove all the drop downs at once from all the cells. You will also learn how to copy drop-down lists from one cell and paste it in other cells. You can use the drop-down menu to select the name of the student and use the formulas to automatically extract the score details of that student. For example, suppose you have a list of students and their marks in five subjects. You can also use drop-down lists in Google Spreadsheets to create interactive charts, to-do lists, and dashboards.įor example, you can create a drop-down with a to-do list where the user can select from options such as task completed, task-in-progress, yet to start.Īnother (advanced) use of the drop-down list can be to extract data for the selected item. This also ensures that there are no errors (such as misspelled words). In this tutorial, you’ll learn how to quickly create a drop-down list in google sheets using data validation.ĭrop Down lists can be used in data entry where you want the user to select from predefined options only. Click one of the cells in which you’ve configured data validation, and select the appropriate value.Watch Video – Creating a Drop-down List in Google Sheets Press OK after all settings are configured.If you don’t want a message to show up, uncheck the box. If you want an error message to pop up when someone enters a value that is not on the predefined list, check the Show error alert after invalid data is entered box.
If you don’t want a message to pop up, uncheck the box. If you’d like a message to pop up when the drop-down cell is clicked to give instructions, check the Show input message when cell is selected box.
Why is the data validation option greyed out or disabled?.Can I make a drop-down list without listing the values in the spreadsheet?.