How To Create A Drop Down List In Excel 2010


A drop-down list in Excel 2010 appears to be a straightforward process, which is understandable considering how useful it is and how many applications it can be put to.

However, if you have ever attempted to create a dropdown menu in Excel, you may have discovered that it is a little more complicated than it appears.

Making things as simple as possible is usually a good idea when entering data into spreadsheets or when creating spreadsheets for others to use. This is especially true when creating spreadsheets for others to use. Incorporating drop-down menus is a good way to accomplish this goal.

In cases where you only have a few different options, such as a month or day of the week, or even a really long option that you do not want to type over and over again, a drop-down list can not only save you time but can also help you avoid any misspellings or typos. Using the steps outlined below, you will be able to create a drop-down list in Microsoft Excel 2010.

Read More: How To Get Rid Of Section Breaks In a word

Create A Drop-Down List In Excel 

When you add data to a drop-down list, the data can be on the same worksheet as the list, on a different worksheet within the same workbook, or in a completely different Excel workbook. In this tutorial, we’ll go over a number of different cookie types. To follow along, fill in the blanks in columns D and E of the image below with the information shown.

To create a drop-down menu, do the following:

  1. Make cell B3 the active cell by selecting it from the list.
  2. Select the Data option
  3. Choose Data Validation from the drop-down menu to display the Data Validation dialogue box.
  4. Select the Settings to tab from the drop-down menu.
  5. To the right of Allow, click the down arrow.
  6. Select the List option.
  7. Position the cursor within the Source text box.
  8. Select cells E3 through E10 in the worksheet to include the information contained in this range of cells in the list.
  9. .Click on the OK button. With the exception of Excel for Mac, where you click Done.

The presence of the drop-down list is indicated by the presence of a down arrow next to cell B3. When you click on the down arrow, a drop-down menu appears, displaying the names of the eight cookie types.

Read More: How To Get Free Steam Wallet Codes 2021

Remove A Drop-Down List

  1. Select the cell that contains the drop-down list that needs to be removed from the table.
  2. Select the Data option.
  3. choose Data Validation from the drop-down menu to display the Data Validation dialogue box.
  4. elect the Settings tab from the drop-down menu.
  5. remove the drop-down list, select Clear All from the menu.

Read More: How To Change Period Size In Microsoft Word

Follow Techworldnews for the Best of the Technology.


Please enter your comment!
Please enter your name here