How to Create a Drop-Down Menu in Google Sheets

Hey there, fellow spreadsheet enthusiasts! Today, I'm going to show you how to create a drop-down menu in Google Sheets. This little trick is going to save you time and make data input a breeze. Let's dive right in!

Step 1: Create a List

The first thing you need to do is create a list of options that you want to appear in your drop-down menu. For example, if you're creating a drop-down menu for the "Type of Expense" column in your budget spreadsheet, you might want to include options like "Utilities," "Groceries," "Transportation," and "Entertainment."

To do this, simply list out your options in a vertical column. You can put this list in a separate sheet if you want to keep things organized, or you can put it in the same sheet as your data.

Pro tip: Keep your list simple. Remember, the goal is to make data input easier. If you have too many options, it defeats the purpose.

Step 2: Select the Cell(s) Where You Want the Drop-Down Menu to Appear

Next, select the cell or cells where you want your drop-down menu to appear. For example, if you want the drop-down menu to appear in the "Type of Expense" column, select the cells in that column where you want the drop-down menu to appear.

Step 3: Go to Data Validation

Now it's time to set up the data validation. In the menu bar at the top of your screen, click on "Data," then click on "Data validation."

Step 4: Choose "List from a Range"

Under "Criteria," select "List from a range." Then, click on the box to the right of "List of items." This is where you'll input the range of cells that contain your list of options.

Pro tip: Make sure you include the name of the sheet in your range. For example, if your list is on Sheet2 and it's in cells A2 through A5, your range should be "Sheet2!A2:A5."

Step 5: Save and Enjoy!

Click "Save" and voila! You now have a beautiful, functional drop-down menu in your Google Sheet. Now, when you go to input data, all you have to do is select the option you want from the drop-down menu. No more typos or misspellings!


Creating a drop-down menu in Google Sheets might seem like a small thing, but it can make a big difference in the speed and accuracy of your data input. Plus, it looks pretty cool! Give it a try in your next spreadsheet and see how much time it saves you. Happy spreadsheeting!

By clicking “Accept”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.