how do you fix the drop down menu in excel 2016

Then, click on the ‘Data’ menu at the top of the spreadsheet and select the ‘Data validation’ option in the drop-down. It can be on the same worksheet or a separate worksheet. Next, select the cell or the range of cells where you want to create the Drop Down list. Here, in this example spreadsheet, we have a list of city names as branches. You can make a drop-down list in Google Sheets by using a list of items contained in a range of cells.įirst, open the Google spreadsheet and enter the list of items in a range of cells that you want to include in the drop-down list. Create a Drop-Down Menu Using a Range of Cells in Google Sheets You can either make a drop-down list with the values in a range of cells or manually specifying items for the list. There are two ways you can add a drop-down menu in Google Sheets. You can quickly create a drop-down using the data validation dialog in Google Sheets. Creating a Drop-Down List in Google Sheetsĭrop-down is a data validation function that allows users to control what can be entered in the worksheet. In this tutorial, we’ll cover everything about creating and managing a drop-down list in Google Sheets. To do that, you can create a drop-down menu with a list of task statuses where the user can select from instead of entering the data manually. And you want your team to update the status of each task as Done, Pending, Priority, Skipped, and Task-in progress. When collaborating on Google Sheets, sometimes, you may want other users to enter repeated values into a column. To avoid inaccuracy, typos, and to make the data entry fastener, you may want to add a drop-down list to ensure that users only input the provided values.įor example, you’re creating a list of tasks that you want your team to perform. The drop-down list ensures that users enter only the values that are available in a given list into the cells. You can create a Drop-Down List in Google Sheets using the list of items in a range of cells or by manually entering the items.Ī Drop-down list (also known as a drop-down menu or a pulldown menu) is a menu, similar to a list box, that allows users to choose an option from a list of pre-defined options.

How do you fix the drop down menu in excel 2016