Creating a Drop Down List in Excel

Since entering data into a spreadsheet is probably the most commonly performed operation in Excel, There are a number of built in 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 tutorial on Creating a Drop Down List in Excel.

Related Tutorials

• Excel Freeze Panes
• Excel Step by Step Database Tutorial
• Excel Data Entry Form Tutorials