Creating a Drop Down List in Excel 2007

Since entering data into a spreadsheet is probably the most commonly performed operation in Excel, Microsoft has included a number of tools and features that make it easier to carry out this task.

One of these, and one that can save you some time if you have to enter the same data repeatedly, is the drop down list.

A drop down list gives you a set number of entries to choose from when entering data. Not only can this speed up data entry, but it can also prevent people from misspelling entries or even from entering the wrong data altogether.

To find out how easy it is to use this feature, read the article on Creating a Drop Down List in Excel 2007.

Related Articles

• Excel 2007 Freeze Panes
• Excel 2007 Step by Step Database Tutorial
• Excel 2003 Step by Step Database Tutorial