You are viewing the article How to Add a Drop-Down Box in Excel 2007 at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
wikiHow is a “wiki” site, which means that many of the articles here are written by multiple authors. To create this article, volunteer authors have edited and improved the article over time.
This article has been viewed 1,379 times.
The drop-down box in Excel 2007 spreadsheets can speed up the data entry process by providing users with a list of items to choose from instead of having to enter information each time. When you insert a drop-down box into a cell in a spreadsheet, the cell displays an arrow mark. The user will enter data by clicking on the arrow and then selecting the desired item. You can set up a drop-down box in just a few minutes and this will greatly improve data entry speed.
- To create a list of desired items on a separate worksheet, click the tab of the spreadsheet to import data. Enter then highlight the data that will show up in the list. Right-click the highlighted range of cells and then click “Name a Range” from the list that appears. Enter a name for the range in the “Name” box and then click “OK”. You then have to protect or hide the workbook to prevent other users from changing this list.
- If you’re creating a name range, in the “Source” box, type an equals sign and the name of the range.
Advice
- If the drop-down list item is longer than the cell it contains, you can change the cell width to display the full text.
- To delete a frame or drop-down list, click on the cell containing the frame/drop-down list. Click the “Data” tab in the Microsoft Excel 2007 ribbon. Click the “Data Validation” button in the “Data Tops” tool group. Click the “Settings” tab, click the “Clear All” button, and then click “OK.”
wikiHow is a “wiki” site, which means that many of the articles here are written by multiple authors. To create this article, volunteer authors have edited and improved the article over time.
This article has been viewed 1,379 times.
The drop-down box in Excel 2007 spreadsheets can speed up the data entry process by providing users with a list of items to choose from instead of having to enter information each time. When you insert a drop-down box into a cell in a spreadsheet, the cell displays an arrow mark. The user will enter data by clicking on the arrow and then selecting the desired item. You can set up the drop-down box in just a few minutes and this will greatly improve data entry speed.
Thank you for reading this post How to Add a Drop-Down Box in Excel 2007 at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: