Adding a drop-down list to an Excel spreadsheetwill help to make data entry faster by offering users a list of elements from which to select the required one instead of performing information input each time. When you put such data into a cell in a spreadsheet, it starts to display an arrow. You enter data by clicking on the arrow, and then select the desired entry. You can set the drop-down list in Excel in a few minutes, thereby greatly improving the speed of data entry. Below is a description of this process.
Open the table on the page you wantcreate a drop-down list. Create a list of items that should be reflected in the list. Enter the data in the order in which they will be subsequently opened. Records should be executed in the same row or column, and should not contain empty cells.
To make a list of the required items in a separatesheet, click the sheet tab where you want to enter the data. Select a type and then select the content that appears in the list. Right-click on the selected range of cells and enter a name for the range in the "Name" field, then select "OK". You can protect or hide the sheet so that other users can not make changes to the list.
Click on the cell that you selected for thisgoals. Go to the Data tab in the Microsoft Excel Ribbon. A dialog box called "Data Validation" appears. Go to the "Settings" tab and click "List" from the "Allow" menu, located in the drop-down list. Click on the radio button in the Source menu. Select the list of items that you want to include in your drop-down list in Excel.
If you created a range name in the Source field, enter an equal sign, then enter the name of the range.
Check or uncheck the box "Ignore empty", depending on whether the cell containing the drop-down list can remain empty.
Go to the "Write message" tab toDisplay a message box that opens when you click a drop-down list. Make sure that the checkbox next to the menu item "Show input message when selecting a cell" is set, and enter the title. So you follow all the instructions on how to make a drop-down list in Excel.
Go to the "Alert error" tab fordisplay an error message if incorrect data is entered. Make sure that the "Show Error" warning is enabled by checking the appropriate box.
Click "OK" to save the verification criteria and create a drop-down list.
If the drop-down record in the list is larger than the cell size containing the list, you can change the width of the cell to view the entire text.
To delete a drop-down list, selectcell containing it. Click the Data tab in the Microsoft Excel Ribbon. Click the "Check Data" button in the "Working with Data" group. Go to the "Settings" tab, click the "Clear All" button, and then click "OK".
As you can see, a guide on how to"Excel" make a drop-down list, is fairly simple. This instruction does not require any special knowledge, it is necessary only at the initial level to be able to work with spreadsheets. It is also worth noting that in various versions of the Excel program, menu items may have some differences with the above, this should be taken into account when working.
