ComputersSoftware

As in "Excel" make a drop-down list (step-by-step instruction)

Adding a drop-down list to an Excel spreadsheet will help make data entry faster by offering users a list of items from which to select the required one instead of performing information entry 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 the Excel program for several minutes, thereby greatly improving the speed of data entry. Below is a description of this process.

Instructions for Excel

Open the table on the page where you want to create 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 must be executed in the same row or column, and should not contain empty cells.

To make a list of the required items in a separate sheet, 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.

Basics of how to make a drop-down list in Excel

Click on the cell that you have selected for this purpose. 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.

Required settings for creating

Check or uncheck the box "Ignore empty", depending on whether the cell containing the drop-down list can remain empty.

Click the "Enter message" tab to display the message box that opens when you click the drop-down list. Make sure that the check box next to the menu item "Show input message when selecting a cell" is set, and enter a title. So you follow all the instructions on how to make a drop-down list in Excel.

Click the "Error Alert" tab to display an error message if incorrect data is entered. Make sure that the "Show Error" warning is enabled by checking the corresponding box.

Click "OK" to save the verification criteria and create a drop-down list.

How to make a drop-down list in Excel: useful notes

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 all the text.

To delete a drop-down list, select the cell 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 "Clear All", and then click "OK".

As you can see, the guide on how to make a drop-down list in Excel is quite 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.

Similar articles

 

 

 

 

Trending Now

 

 

 

 

Newest

Copyright © 2018 en.birmiss.com. Theme powered by WordPress.